Access Essentials

This practical hands-on course will enable you to understand the main concepts of databases and help you develop a database application. Training available on Microsoft Access 365, 2019, 2016 and 2013.  Select your version when making a booking.

• Design a multiple table database

• Create tables and add fields and set data types

• Add records

• Create forms for data entry

• Sort and filter data in tables and forms

• Create simple queries

• Create reports based on tables and queries.

Audience:

Students who need to learn basic database techniques and skills required to modify an existing database or create a new database.

Prerequisites:

For best outcomes, participants should be familiar with the Windows operating system and basic mouse and keyboard techniques. 

Inclusions

• Training Manual with step by step instructions

• Practice files relevant to the training material

• Training Completed files you are free to take away any completed files for review

• Unlimited online support as training does not stop when you walk out our door

Course Content

Getting Started

• What is Microsoft Access?

• Basic Terminology - Tables, Records, Forms, Queries and Reports

• Understanding a relational database

• Opening Microsoft Access

• Interface Overview

• Ribbon and commands

• Quick Access Toolbar

• Closing Microsoft Access

Working With Tables

• Opening Tables

• Table Views

• Datasheet View

• Navigating Records in a Datasheet

• Adding and Editing records in a datasheet

• Managing Column widths and row heights

• Moving a Column

• Hiding / Unhiding Columns

• Freezing / Unfreezing Columns

Working With Data Through Forms

• Understanding forms and their relationship to tables

• Moving a round a form

• Understanding form controls

• Find records through a form

• Filtering data

  • using a data sheet

  • on a split form

  • by date

  • by selection

• Sorting Data

• Printing records

• Export to PDF

• Export to Excel

• Deleting a record

Working With Reports

• Running a Report

• Understanding the relationship of the report data

• Veiwing the Report structure

• Printing the report

Creating A table

• Planning a new Table

• Creating a Table

• Setting Field properties and data types

• Using a Lookup field

• Setting a Primary Key

• Setting Indexes

• Entering Data into a Table

Creating Forms To View and Edit Data

• What is a Form?

• Bound vs. Unbound Controls

• Creating a Form with the Wizard

• Using Design View to Modify Your Form

Creating A New Database

• Planning a Database

• Creating a Database from a Template

• Creating a Blank Database

• Using Database Objects

• Setting Navigation Options

Creating Queries To Select Records

• What is a Query?

• Creating a Query with the Wizard

• Using Design View to Modify a Query

• Using Queries

Creating Reports

• What is a Report?

• Creating a Report with the Wizard

• Using Design View to Modify a Report

• Using Reports