lab sheet 2_database basics

5/12/2018 Lab Sheet 2_database Basics - slidepdf.com

http://slidepdf.com/reader/full/lab-sheet-2database-basics 1/6

PUSAT PENGAJIAN DIPLOMAUNIVERSITI TUN HUSSEIN ONN MALAYSIA (UTHM)

DIT2044/DAT20404 PANGKALAN DATA

LAB SHEET 2: DATABASE BASICS

Objective(s): When you have completed this task you will

1. Be able to create form.

2. Be able to create query.

3. Be able to create report.

Instructor: Encik Syarizul Amri Bin Mohd Dzulkifli

Lab: MKPTM4

1.0 ACTIVITIES:

(a) Carry out the task individually

(b) Continue from lab sheet 1.

(c) Finish and show the exercise at lab on week 6.

2.0 CREATE FORM:

2.1 In the Objects list, click Forms.

2.2 Double-click Create form by using wizard.

Prepared by: Syarizul Amri Bin Mohd Dzulkifli 1





2.3 When the Form Wizard window appears, click the button.

All the table fields should be added to the form:

2.4 Click the button. When the next screen appears, leave

Columnar selected, then click the button. When the next screen

appears, make sure Standard is selected, then click the button.

2.5 When the last screen appears, type:

Friends of Mine Data Input Form in the box.






2.6 Click the button.

The form should open and look like this:

On the Menu Bar, click File, then Close to return to the database window.

3.0 CREATE QUERY:

3.1 In the Objects list, click Queries.

3.2 Double-click Create query by using wizard.






3.3 When the Simple Query Wizard opens, double-click First Name in the

Available Fields list.

First Name should appear in the Selected Fields column. Click the

button. This should add the Last Name field to the Selected Fields list:

3.4 Double-click Phone Number. This should add the Phone Number

field to the Selected Fields list. Click the button.

3.5 When the final screen appears, type:Names and Numbers






3.6 Click the button. The query is automatically saved andexecuted.

Your queries should have 5 records based on lab sheet 1 that you have done.

On the Menu Bar, click File, then Close to return to the database window.

4.0 CREATE REPORT:

In the Objects list, click Reports. Double-click Create report by using wizard.

When the Report Wizard window appears, click the Tables/Queries drop-down

arrow. When the list appears, click Table: Friends of Mine.

Click the button to move all the fields into the Selected Fields list.

In the Selected Fields list box, click ID, then click the button. The ID field

should be removed. Click the button. When the next screen appears, click

the button.

When the next screen appears, click the first drop-down arrow, then click City in the

list. Click the button.






Choose layout and style

When the next screen appears, make sure Tabular is checked in the Layout

section. Then click the button.

When the next screen appears, click Soft Gray in the list of available styles. Then

click the button.

View the report

When the final screen appears, type:

My Friends in the box.

Then click the Preview the report radio button. Click the button. The

report is automatically created, saved and opened. On the Menu Bar, click File, and

then Close to return to the Friends database window. On the Menu Bar, click File,

then Exit to close Access.


lab sheet 2_database basics

Documents