meljun cortes computer application chp 6 ms access

7/31/2019 MELJUN CORTES Computer Application Chp 6 Ms Access

1/17

6-1

Chapter 6: Microsoft Access I

Learning Outcomes

- Creating a table with data

- Queries

- Forms

- Reports


2/17

6-2

Microsoft Access is a powerful program to create and manage your databases. It has

many built in features to assist you in constructing and viewing your information.

This lesson will help you get started with Microsoft Access and it is a very good idea

to use the Help Files that come with Microsoft Access, or go to Microsoft's web sitelocated at http://microsoft.com/office/access/default.htm for further assistance.

First of all you need to understand how Microsoft Access breaks down a database.

Some keywords involved in this process are:Database File, Table, Record, Field,

Data-type. Here is the Hierarchy that Microsoft Access uses in breaking down a

database.

Database File: This is your main file that

encompasses the entire database and that is saved to

your hard-drive or floppy disk.

Example) StudentDatabase.mdb

Table:A table is a collection of data about a specific

topic. There can be multiple tables in a database.

Example #1) Students

Example #2) Teachers

Field:Fields are the different categories within a

Table. Tables usually contain multiple fields.

Example #1) Student LastName

Example #2) Student FirstName

Datatypes:Datatypes are the properties of each field.

A field only has 1 datatype.

FieldName) Student LastName

Datatype) Text


3/17

6-3

6.1 Creating a table with data

Select Start All Programs Microsoft Access


4/17

6-4

Click on Blank Access databaseand press OK.


5/17

6-5

Click on Create

Click

Here


6/17

6-6

Click on Create table in Design view.

Click

Here


7/17

6-7

Key into Field Names StudID Data Type Number.

Key into Field Names Name Data Type Text.

Key into Field Names DOB Data Type Date/Time.

Click onto X .

Select Yes to save.

Key in

these

fields

Select the

corresponding

Data TypesClick Here to

Close

Select Yes


8/17

6-8

Click Yes to create a primary key.

Click

Yes


9/17

6-9

Double click on Table1

Double

Click

Here


10/17

6-10

Key in three student records as shown below.

Press the X to close the table.

Enter three

records

Click Hereto close


11/17

6-11

6.2 Queries

Select Object Queries.

Select Create query by using wizard.

Select on the double arrow symbol.

Select Finish.

You will see a Table 1 Query.

Click

Here

Click

HereClick

Finish

Select

Queries


12/17

6-12

Table 1 Query.

Click the arrows to go to next or previous records.

Click Here to go next record


13/17

6-13

6.3 Forms

Select Objects Form.

Select Create form by using wizard

Select on the double arrow symbol.

Select Finish.

Select

Forms

ClickHere

ClickHere

Click

Finish


14/17

6-14

Table 1 Form.

Click the arrows to go to next or previous records.

Click Here to go next record


15/17

6-15

6.4 Reports

Select

Re orts

ClickHere

Click

HereClick

Finish


16/17

6-16

Table 1 Report.


17/17

6 17

Exercises

1) Create a table called PCGames with the fields GameID, Desc, Price and Qty.

2) Create three records into the table.

3) Create a form, query and report from this table.

meljun cortes computer application chp 6 ms access

Documents