Microsoft Access: From ZERO to ADVANCED

Microsoft Access is one of the most used database management software and one with a high demand on the market. It's a perfect tool that helps you store all kinds of information for reporting, analysis, and reference. It is also an important application to understand how SQL works.

If you have no knowledge whatsoever in this software, this course is for you You will be gaining all the required skills to be a complete professional in no time. It is worth noting that such courses allow you to quickly gain required skills, without having to enroll in a full semester course.

This course is divided into 5 sections, and made up of 17 chapters. All the exercise files are provided with the videos so you can follow along with the instructor. Some files are also in Excel format which can easily be imported in Microsoft Access. This shows the versatility between the different software of the Microsoft Office suite.

The course is divided into the following sections and chapters:

1. Create and Manage Databases

   • Create and Modify Databases

   • Manage Relationships and Keys

   • Navigate through a Database

   • Protect and Maintain Databases

   • Print and Export Data

2. Build Tables

   • Creating Tables

   • Manage Tables

   • Modify Fields

3. Create Queries

   • Create Queries

   • Modify Queries

   • Calculated Fields

4. Create Forms

   • Create Forms

   • Configure Controls

   • Format Forms

5. Create Reports

   • Create Reports

   • Reports Control

   • Format Report