Introduction to
Microsoft's Access
by K. Yue
1. Resources
- MS Access is a relational database management system.
- MS Access is a mature product and there are plenty of tutorials, examples, and resources.
- It is based on the relational model.
- To start, it is necessary to be familiar with the following basic concepts:
- row
- column
- column value
- data type
- primay key
- foreign key
- relationsihp
- query
- SQL
- As a GUI tool, there are also various important views.
- Our course only requires less than 1% of the features provided by MS Access.
- As a starter, make sure you know how to:
- create a table
- populate a table
- create a simple query
- Not covered in Access in this course, but important:
- create form
- create report
Classroom Demonstration
(1) New database:
Donation(DonationId, LName, FName, EMail, Address, Time)
Data:
Bun Yue, yue@uhcl.edu, $100, today
and so on.
(2) Existing database: pvfc.mdb (in course page of UHCL Blackboard).