MS Access Laboratory

Learning Outcomes

After completing this course, the student will be able to : Demonstrate the use of the existing facilities in MS Access in database management; Demonstrate Report based on data saved in table.

Topics

1. Introduction to Database Management System (DBMS)
2. MS Access environment
3. Create Table
4. Create Form
5. Entry and modify data into a table
6. Table relationship
7. Simple query
8. Query using criteria and Expression Builder
9. Structured Query Language (SQL)
10. Sort, index and filter data
11. Creating a multitable form and Data Entry Control
12. Create Switchboard
13. Create report