top of page

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.

Our Salient Features:

  • Hands-on Labs and Homework

  • Group discussion and Case Study

  • Course Project work

  • Regular Quiz / Exam

  • Regular support beyond the classroom

  • Students can re-take the class at no cost

  • Dedicated conf. rooms for group project work

  • Live streaming for the remote students

  • Video recording capability to catch up the missed class

bottom of page