MS Access Database for Industry & Business (3 Days)

Access enables people to create powerful database solutions that let you organize, analyze and share information more effectively. For examples employee database, attendance, employee performance, production history database, KPI monitoring, inventories, tools management, guest history, etc. The focus is on optimizing the databases for efficient data entry and generating comprehensive reports.
Target audience
1. Officers, Clerk, Engineers & Technicians
2. Database beginner
3. Professional developer
Course Objective
On completion of course, users will able to:
1. Create tables, forms and reports.
2. Use queries to find, filter, update and calculate.
3. Create forms that handle data automatically
4. Optimize the database for easy navigation, and data input.
Course Content
1. Introduction
2. Working with Tables
3. Designing Tables
4. Relationships
5. Designing Queries
6. Designing Forms
7. Report Design
8. Macros
9. Importing and Exporting
10. Customizing Access