Transcript Access-L1

Lesson 1
Introduction of Databases
Using Microsoft Access
Overview
•
•
•
•
What is database
Steps to design a database
Elements, menus, toolbar of MS Access
Work with MS Access
What is database
• A collection of information
• eg, lists of names, address, phone no for
contact
• Each item of information in the list such as
name, phone no is called a field.
• The collection of field information for one
person in the list is a record.
• Field and record information is contained
in a grid called a table.
Phone list of teaching staffs
Fields
Name
Address
Phone no
subjects
Mr. Lau WT
Flat 5603, block
10, City One,
Shatin
26488222
Computer
Ms Cheung
MW
Flat 5604, block
10, City One,
Shatin
Flat 5605, block
10, City One,
Shatin
26488333
Computer
Physics
26484444
Mathamatics
Physics
Mr. Mak C H
Record
Database Storage and
management
• Objects you create are stored in a single
database file
• eg : stafflist.mdb
• A computer application that you use to
create and maintain databases is
database management system (DBMS)
Design a Database
1.
2.
3.
4.
5.
Define purpose
Plan database objects
Create tables
Create queries
Create forms and reports
Assignment
•
•
1.
2.
3.
4.
5.
6.
Design your own contact list
Which includes
Class
Name (may set as primary key)
Class no
Favourite subject
Birthday
Phone no
Tasks included
1. Open a database
2. Create fields in a table with different data
types
3. Add records to the table using
DATASHEET view
4. Create an AUTOFORM
5. Add records to the table using the Form
Short Quiz
1. What is the term describes all the data
for one entity in a table?
• Record
• File
• Field
• Query
Short Quiz
2. What is the extension of a database file?
• Filename.acc
• Filename.mdb
• Filename.msdb
• Filename.dbms
Short Quiz
3. Which of the following should be the most
suitable as a datatype of the field
DateofBirth?
• text
• currency
• hyperlink
• Date/Time
Design your own contact list
Private key
Manage data base
•