IT Expert System

MS Access Module

Microsoft Access is a Desktop database technology that combines powerful features of relational database along with easy to use interface to create Desktop Database application quickly. Using this database, users can create small to medium size desktop applications and deploy and maintain the same.

Office Admin Program

Course Content

1. Introduction to Microsoft Access

Understanding Databases and Access
Access Interface and Ribbon
Creating a New Database
Tables and Data Types

2. Building Database Tables

Creating Tables
Setting Primary Keys
Data Validation and Field Properties
Importing Data from Excel and CSV

3. Relationships and Referential Integrity

Understanding Relationships
Establishing Relationships
Referential Integrity
Enforcing Data Integrity

4. Querying Data

Introduction to Queries
Creating Basic Queries
Criteria and Sorting
Calculated Fields and Expressions

5. Advanced Queries and Reporting

Parameter Queries
Crosstab Queries
Action Queries (Update, Delete, Append)
Introduction to Reports

6. Creating Forms

Introduction to Forms
Form Design Tools
Creating Data Entry Forms
Form Controls and Navigation

7. Building Custom Forms

Combo Boxes and List Boxes
Sub forms and Tab Controls
Form Design Best Practices
Form Macros

Staffing Support

Resume Preparation
Mock Interview Preparation
Phone Interview Preparation
Face to Face Interview Preparation
Project/Technology Preparation
Internship with internal project work
Externship with client project work

8. Introduction to Reports

Creating Basic Reports
Grouping and Sorting Data in Reports
Calculated Controls in Reports
Report Macros

9. Data Analysis with Access

Exporting Data
Introduction to PivotTables and Pivot Charts
Using Access with Excel
Importing and Exporting Data

10 Database Security and Advanced Topics

User-Level Security
Backup and Maintenance
Introduction to VBA (Visual Basic for Applications)
Course Review and Q&A

Course Assessment:

Weekly quizzes to assess understanding.
Hands-on projects to apply knowledge.
Final project: Create a professional document showcasing various MS Access skills.