Lab Session - Database Software

Instructions 

1. Bring you own device
2. With installed MS Access
3. Note book to jot down instructions and notes

Lecture Notes | Latest | old |

File to download (Exercise)

1. Introduction to Microsoft Access - Video 1
2. Overview of data, databases and information -  Video 1
3. File processing systems and databases - Video 1
4. Database Management system - Video 1
5. Application Development Languages and tools

Mirosoft Access

1. Introduction to Database
2. Introduction to Objects
3. Getting Started
4. Working with Database
5. Working with Tables
6. Customizing Tables
7. Working with Forms
8. Sorting and Filtering Records
9. Designing a simple Query
10. Multi-table Queries Part 1
11. Multi-table Queries Part 2
12. Modifying Queries
13. Create a Totals Query
14. Creating Reports
15. Printing Reports
16. Use the Reports Wizards
17. Formatting Reports
18. Modifying Tables
19. Creating Form
20. Customizing Forms settings
21. Formatting Forms
22. Others - How To Change Currency Microsoft Access 

File to download (Exercise)

Student Ms Access - sample Q for excercise

1. Step 1: Create and Rename a File
2. Step 2: Create and Format the Manufacturers Table
3. Step 3: Create and Format the Customers Table
4. Step 4: Create and Format the Manufacturers Form
5. Step 5: Create and Format the Customers Form
6. Step 6: Enter data into a form for the Manufacturers 
7. Step 7: Enter data into a form for the Customers
8. Step 8: Create Queries - Sorting the customer’s record
9. Step 9: Create Queries - Customers from MRAN
10. Step 10: Create Queries - Manufacturers discount of => 5%
11. Step 11: Create Queries - Customers Purchase
12. Step 12: Create Queries - City Jengka
13. Step 13: Create Report - Customers Purchase