Microsoft Access (Basic - Intermediate)

In this course, students will learn how to use Microsoft Access to manage your data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.

What You Will Learn:

• design a simple relational database
• manipulate table data
• join tables
• query in database
• create reports
• import and export data

Who Should Attend:

• This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Prerequisite:

• To ensure success, students should be familiar with using personal computers, and should have experience using a keyboard and mouse. Students should be comfortable in the Microsoft Windows® environment, and be able to use Microsoft Windows to manage information on their computers. Specific tasks the students should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.

Course Structure:

• Module 1 – Getting Started with Microsoft Access
• Explore the User Interface
• Explore the Ribbon
• Create a Simple Access Database
• Get Help in Microsoft Access
• Module 2 – Working with Table Data
• Modify Table Data
• Sort and Filter Records
• Create Lookups
• Module 3 - Querying a Database
• Join Data from Different Tables in a Query
• Sort and Filter Data in a Query
• Perform Calculations in a Query
• Module 4 – Creating Advanced Queries
• Create Parameter Queries
• Create Action Queries
• Create Unmatched and Duplicate Queries
• Summarize Data
• Module 5 – Generating Reports
• Create a Report
• Add Controls to a Report
• Enhance the Appearance of a Report
• Prepare a Report for Print
• Module 6 – Customizing Microsoft Access Environment
• The Access Options Dialog Box
• Module 7 – Designing a Relational Database
• Relational Database Design
• Create a Table
• Create Table Relationships
• Module 8 – Joining Tables
• Create Query Joins
• Join Tables That Have No Common Fields
• Relate Data within a Table
• Work with Subdatasheets
• Create Subqueries
• Module 9 – Organizing a Database for Efficiency
• Data Normalization
• Create a Junction Table
• Improve Table Structure
• Module 10 – Sharing Data Across Applications
• Import Data into Access
• Export Data to Text File Formats
• Export Access Data to Excel
• Create a Mail Merge
• Module 11 - Advanced Reporting
• Organize Report Information
• Format Reports
• Include Charts in a Report
• Add a Calculated Field to a Report
• Add a Subreport to an Existing Report