MS Access – Fundamentals to Advanced

Start Dates: TBC

Duration: 1 Day

Full Fee: 100

Network Members Fee: 60

https://www.ifsskillnet.ie Book Now

Programme overview

In this course, students will use Access 2016 to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Learning outcomes

In this course, you will create and manage an Access 2016 database.

You will learn how to:

  • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
  • Organise and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

Who is the course for?

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

Modules

1 – Getting Started with Access

Orientation to Microsoft Access

Create a Simple Access Database

Get Help and Configure Options in Microsoft Access

2 – Working with Table Data

Modify Table Data

Sort and Filter Records

3 – Querying a Database

Create Basic Queries

Sort and Filter Data in a Query

Perform Calculations in a Query

4 – Using Forms

Create Basic Access Forms

Work with Data on Access Forms

5 – 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

6 – Designing a Relational Database

Relational Database Design

Create a Table

Create Table Relationships

7 – Joining Tables

Create Query Joins

Relate Data Within a Table

Work with Subdatasheets

8 – Using Data Validation

Use Field Validation

Use Form and Record Validation

9 – Creating Advanced Queries

Create Parameter Queries

Summarize Data

Create Subqueries

Create Action Queries

Create Unmatched and Duplicate Queries

10 – Organizing a Database for Efficiency

Data Normalization

Create a Junction Table

Improve Table Structure

11 – Using Advanced Reporting Techniques

Include Control Formatting in a Report

Add a Calculated Field to a Report

Add a Subreport to an Existing Report

For more information on training providers, please contact info@ifsskillnet.ie.

Use this section to give an overview of the trainer provider