Microsoft Access

Time: 24 hours




Course overview:


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..


Course Content


Getting Started

  • Database Concepts 

  • Overview of Access database 

  • Setup access on your computer 

  • Explore the user interface 


Create a sample database 

  • Create a simple database 

  • Create table 

  • Add / Update data 

  • View data 

  • Formatting table contents 


Working with tables

  • Manage relationships  

  • Creating Primary Keys 

  • Setting up Referential integrity with foreign keys 

  • Record navigations


  • Creating Queries using Query interface  

  • Creating Parameter Queries 

  • Creating group queries 

  • Creating join queries 

  • Sorting data 

  • Formatting Query fields

Creating Forms for Data Entry

  • Creating a form 

  • Data validation 

  • Saving, updating and deleting forms 

  • Working with Form Controls 

  • Setting form control properties 

  • Managing Labels

Special notes:

Additional Theory + Labs



Creating Reports 

  • Creating and modifying reports 

  • Creating reports with application parts 

  • Deleting Reports 

  • Using Report Controls – Grouping, Filtering, Sorting data 

  • Using sub forms and other form controls 

  • Formatting Reports – Creating Multi Column reports, using calculated fields, setting margins, background and orientation 

  • Formatting Reports – Setting Page breaks and Page numbers, applying themes

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

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


951 N Plum Grove Rd, Suite B,

Schaumburg IL 60173

Branch Office:

1560 Wall Street, Suite #111,

Naperville, IL 60563

Branch Office:

O'Hare Lake Office Park,

2400 East Devon Ave, Suite #257

Des Plaines, IL 60018

Tel: 847 350 9034

  • LinkedIn Social Icon
  • Facebook Social Icon

Disclaimer: At this time, we are not offering any training programs for Nebraska residents.

 'PMP' and 'PMI' are registered marks of the Project Management Institute, Inc.

'GI Bill' is a registered trademark of the U.S. Department of Veterans Affairs (VA).

InfoTekGuide - A Leading IT Training Provider in Schaumburg and Naperville