Access 365 - Part 1

Course Description

This course is designed to help users become comfortable with navigating the Microsoft Access interface, designing and creating a new database from scratch, querying a database, generating reports, sharing, importing and exporting data.
1 Day
Contact us for pricing
 

Getting Started with Access

What is Microsoft Access?
Components of a Database
Create a Simple Database
Creating a Simple Form

Working with Table Data

Work with Table Data
Work with Records
Sort and Filter Records
Create Lookups and Relationships

Query a Database

Use a Query to View Data from Multiple Tables
Sort and Filter Data in a Query
Perform Calculations in a Query

Create Advanced Queries

Create Parameter Queries
Create Action Queries
Create Find Duplicate and Find Unmatched Queries
Summarize Data

Generate Reports

Create a Report
Add Controls to a Report
Advanced Reporting

Design a Relational Database

Relational Database Design
Working with Tables
Modify a Table and Fields
Create Table Relationships

Joining Tables

Create Query Joins
Working with Subdatasheets and Subqueries

Importing and Exporting Data

Import Data into Access
Export Data
Create a Mail Merge
AccessMS AccessMicrosoft AccessOffice 365Access 365Access 2016Access 2019