Transcript Slide 1 - WordPress.com

Lesson 03 :
Creating Database
At the end of this lesson, students
should be able to:
• Form by using wizard :
Add record, Edit record
• Query by using wizard
• Report by using wizard
Create Form
1. Open Microsoft Access 2003
2. Click Open an Existing Database, then click file students profile
and click OK.
3. In the database window, click Form and double click Create
Form by using wizard.
Step 2
Click Create Form by using wizard
Step 1
Click Form
Figure 1
4. Click double arrow to select Available Fields
Click here
Figure 2
5. The selected Fields will be remove from left to right.
Then click Next
Click Next
Figure 3
6. Click Next
Click Next
Figure 4
7. Click Standard for style. Then click Next
Step 1
Click
Standard
Step 2
Click Next
Figure 5
8. Click Finish
Click Finish
Figure 6
9. The form will display as below
Figure 7
Add Records
1. Open Microsoft Access 2003
2. Click Open an Existing Database,then click file students
profile and click OK.
3. In the database window, double click students profile in
the Tables pane to open the table in Datasheet view, as
shown in Figure 9.
Double
Click here
Figure 8
4. To add new record, click on icon New Record
that
can be seen at database toolbar or at the bottom of
datasheet window (refer Figure 9).
Icon New
record
Figure 9
5. Add five more record as below. (refer Figure 10)
address
icno
name
Alias b Mohamad
No. 5, Jalan Desa Kayang 3, Desa kayang, 01000
Kangar.
950918-02-5533
Mohd Shahid b Mohd
Som
No. 39, Taman Tapah, Jalan Pahang 35000 Tapah,
Perak.
950912-05-5321
Noorul-Aini bt Ambak
No 15, Jalan Limau Kasturi, 4/4A 40000 Shah Alam,
Selangor.
950212-11-5678
Noor Asiah bt Zakaria
Lot 2646, Kg Simpang Tiga, Bt 6 3/4, 53100 Gombak,
Selangor
950402-04-5566
Fasitah bt. Mansor
No. 36, Jln. Melati, Tmn. Mewah, 31000 Batu Gajah,
Perak
950606-03-5432
Figure 10
6. The record will display as below
7. Save record.
8. Close students profile : Table.
Step 1
Click to Save
Record
Step 2
Click to
Close Table
Figure 11
Edit Record.
1.Open Students Profile table.
2.To edit record, click inside the selected field. (sex and email)
Step 1
Click to edit
Record sex
Step 2
Click to edit
Record email
Figure 12
3. Insert in all the record for sex field and email field. (refer Figure 13)
numbers name
sex
add
email
1
Abdul Rahman b.
Idris
Male
[email protected]
2
Johana bt.
Muhammad
Female
[email protected]
3
Faridah bt Abdullah
Female
[email protected]
4
Rosnani bt. Sembok
Female
[email protected]
m
5
Hassan b. Wahid
Male
[email protected]
6
Alias b Mohamad
Male
[email protected]
7
Mohd Shahid b Mohd
Som
Male
[email protected]
8
Noorul-Aini bt Ambak
Female
[email protected]
9
Noor Asiah bt Zakaria
Female
[email protected]
10
Fasitah bt. Mansor
Female
[email protected]
Figure 13
4. Repeat step 2 above to add in 5 postcodes (see bold figure)
inside the first five record. (Refer Figure 14).
Numbers
name
sex
address
1
Abdul Rahman b.
Idris
male
2304, Rumah Rumah Tasek Gelugor, 13300
Pulau Pinang
2
Johana bt.
Muhammad
female
No 24, Jln 1, Taman Seri Sinar, 50600 Kuala
Lumpur
3
Faridah bt Abdullah
Female
No 39, Jln Pinang Merah 11, 81000 Bandar
Tengg, Johor
4
Rosnani bt. Sembok
Female
No 1005, Bukit Datu, 21200 Kuala Terengganu,
Terengganu
5
Hassan b. Wahid
Male
No 101, Taman Rapat Jaya, 41000 Kelang,
Selangor
Figure 14
5. The Table will display as below
6. Save and Close students profile table.
Step 1:
Click to
Save Table
Step 2
Click to Close
Table
Figure 15
Create Query.
1. Open Microsoft Access 2003
2. Click Open an Existing Database, then click file students
profile and click OK.
3. In the database window, click Queries and
click create query by using wizard.
Step 2
Click Create Query by using wizard
Step 1
Click Query
Figure 16
4. Click double arrow to select Available Fields
Click here
Figure 17
5.The selected Fields will be remove from left to right.
Then click Next
Click Next
Figure 18
6. Click Finish
Click Finish
Figure 19
7. A dialog box will display as below.Click icon design view.
Click icon
design view
Figure 20
8. A dialog box will display as below.
Figure 21
9. At the row Criteria, type-in Male and press Enter
10. Click icon Run
Step 2
Click Icon Run
Step 1
Type-in Male
Figure 22
11. A dialog box for male students will be display
Figure 23
Save Query.
1.Click File and Save As
Step 1
Click File
Step 2
Click Save As
Figure 24
2. Save file as : male students profile Query
Click OK
Figure 25
3. The file will be save as below
Figure 26
4. Click File and Close to end this session.
Step 1:
Click File
Step 2
Click Close
Figure 27
Create Report
1. Open Microsoft Access 2003
2. Click Open an Existing Database, then click file
students profile and click OK.
3. In the database window, click Report and click create
report by using wizard.
Step 2
Click Create Report by
using wizard
Step 1
Click Report
Figure 28
4. Click double arrow to select Available
Fields
Click here
Figure 29
5. The selected Fields will be remove from left to right.
Then click Next
Click Next
Figure 30
7. Click Next
Click Next
Figure 31
6. Click Next
Click Next
Figure 32
8. At the Layout click Tabular.Select Landscape at
the Orientation.Then click Next.
Step 1: Click
Tabular
Step 2.Click
Landscape
Step 3.Click
Next
Figure 33
9. Select the Casual style.Then click Next.
Step 1: Click
Casual
Step 2: Click
Next
Figure 34
10.Click Finish
Click
Finish
Figure 35
11. A dialog box report will display as below.
Diagram 36