Program Overview 

Microsoft Access is a Database Management System (DBMS) from Microsoft which combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a part of Microsoft Office suite of applications, included in the professional and higher editions.

Learning Objectives 

This course is an introduction to databases through Microsoft Access. It is designed for people who are used to managing data in spreadsheets but wish to understand why and how a database will provide a better solution. The course covers the difference between spreadsheets and databases and takes students through the process of creating a database, from design through to data population. In the second part of the course, students learn the fundamentals of the SQL query language and gain a full understanding of how to write queries in Access for retrieving and updating data.

Course Content

• Getting Started with Access
• Orientation to Microsoft Access
• Create a Simple Access Database, Get Help and Configure Options in Microsoft Access;
• Working with Table Data Modify Table Data;
• Sort and Filter Records; Querying a Database;
• Create Basic Queries;
• Sort and Filter Data in a Query;
• Perform Calculations in a Query
• Using Forms
• Create Basic Access Forms;
• Work with Data on Access Forms
• Generating Reports
• Create a Report; Add Controls to a Report; Enhance the Appearance of a Report;
• Prepare a Report for Print; Organize Report Information; Format Reports;
• Designing a Relational Database; Relational Database Design, Create a Table; Create Table Relationships
• Sharing Data Across Applications: Import Data into Access; Export Data to Text File Formats; Export Access Data to Excel; Create a Mail Merge

Course Outcomes: At the end of the course, participants will be able to use MS Access and create well structured databases; and generate reports from created databases

Duration: 2 Weeks