Instructions
- Bring you own device
- With installed MS Access
- Note book to jot down instructions and notes
File to download (Exercise)
- Introduction to Microsoft Access - Video 1
- Overview of data, databases and information - Video 1
- File processing systems and databases - Video 1
- Database Management system - Video 1
- Application Development Languages and tools
Mirosoft Access
- Introduction to Database
- Introduction to Objects
- Getting Started
- Working with Database
- Working with Tables
- Customizing Tables
- Working with Forms
- Sorting and Filtering Records
- Designing a simple Query
- Multi-table Queries Part 1
- Multi-table Queries Part 2
- Modifying Queries
- Create a Totals Query
- Creating Reports
- Printing Reports
- Use the Reports Wizards
- Formatting Reports
- Modifying Tables
- Creating Form
- Customizing Forms settings
- Formatting Forms
- Others - How To Change Currency Microsoft Access
File to download (Exercise)
Student Ms Access - sample Q for excercise
- Step 1: Create and Rename a File
- Step 2: Create and Format the Manufacturers Table
- Step 3: Create and Format the Customers Table
- Step 4: Create and Format the Manufacturers Form
- Step 5: Create and Format the Customers Form
- Step 6: Enter data into a form for the Manufacturers
- Step 7: Enter data into a form for the Customers
- Step 8: Create Queries - Sorting the customer’s record
- Step 9: Create Queries - Customers from MRAN
- Step 10: Create Queries - Manufacturers discount of => 5%
- Step 11: Create Queries - Customers Purchase
- Step 12: Create Queries - City Jengka
- Step 13: Create Report - Customers Purchase
Tiada ulasan:
Catat Ulasan