|
|
| |
 |
|
|
Module 3: Microsoft Access
- 1 Week (14 hours) |
- Introduction to the MS Access Tutorial
- Intended Audience
- Pre-Requisite Knowledge
- Brief overview of Relational Databases and Database Applications
- A Business Example
- Starting Microsoft Access
- Review of Starting Microsoft Access
- Creating and Viewing Tables
- Creating a Table Using the Design View
- Exercise: Creating a Table
- Viewing and Adding Data to a Table
- Exercise: Adding Data to a Table
- Creating Relationships Between tables
- Review of Creating and Viewing Tables
- Creating and Running Queries
- Single Table Queries
- Exercise: Single Table Queries
- Multiple Table Queries
- Exercise: Multiple Table Queries
- Review of Creating and Running Queries
- Creating and Running a Data Entry Form
- Creating a Single Table Form using the Wizard
- Exercise: Creating a Single Table Form
- Review of Creating and Running a Data Entry Form
- Creating and Running a Report
- Creating a Single Table Report using the wizard
- Exercise: Creating a Single Table Report
- Review of Creating and Running a Report
- Summary
- Interview questions and answers discussion
- Written test
- Oral presentation test
|
|
|
|