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.

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 

  • Queries  

    • 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 

  • 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

 IT Expert System, Inc. is approved to operate by the Private Business and Vocational Schools Division of the Illinois Board of Higher Education.

 IT Expert System, Inc. is not accredited by a US Department of Education recognized accrediting body. IBHE Mandatory Disclosure Reporting

 IT Expert System, Inc Training programs are approved by the Illinois State Approving Agency for the enrollment of qualified veterans and/or other eligible persons to receive Montgomery GI Bill® education benefits.

‘PMP’ and 'CAPM' are registered marks of the Project Management Institute, Inc.

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

Office:

951 N. Plum Grove Rd.

Suite A, C
Schaumburg, IL, 60173

Ph: 847 350 9034

Email: info@itexps.com

Branch Office:

1560 Wall Street,

Suite #111,

Naperville, IL 60563 

Ph: 847 350 9034

Email: info@itexps.com

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