Home / Training Courses / ACSL2: Microsoft Access - Creating Relational Databases

Training Courses

search courses

ACSL2: Microsoft Access - Creating Relational Databases

Guaranteed to Run Scheduled Fully Booked

Location

Wellington

Feb 2021

9 23

Mar 2021

9 23

Apr 2021

6 20

May 2021

4 18

Jun 2021

1 15 29

Jul 2021

13 27

Aug 2021

10 24

Sep 2021

7 21

Oct 2021

5 19

Nov 2021

2 16 30

Dec 2021

Code: ACSL2

Length: 1 Day

Overview

Expand your knowledge of relational database design.

Delivery format(s)

On-Site

Classroom

Anywhere

OBJECTIVES

Expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports.

PREREQUISITES

Access - The Essentials class or equivalent knowledge.

WHAT YOU’LL LEARN

After completing this course, students will be able to:

Design a relational database.
Join tables to retrieve data from unrelated tables.
Validate data entered into a database.
Use advanced queries to manipulate your data.
Organise a database for efficiency and performance, and to maintain data integrity.
Customise reports to organise the displayed information and produce specific print layouts.

COURSE OUTLINE

Designing a Relational Database
 Relational Database Design
 Create a Table
 Create Table Relationships

Joining Tables
 Create Query Joins
 Relate Data Within a Table
 Work with Subdatasheets

Using Data Validation
 Use Field Validation
 Use Form and Record Validation

Creating Advanced Queries
 Create Parameter Queries
 Summarise Data
 Create Subqueries
 Create Action Queries
 Create Unmatched and Duplicate Queries

Courses you might be interested in

ACSL1: Microsoft Access - The Essentials Microsoft Office, Access Code: ACSL1 Learn how to use Microsoft Access to manage data and create a database.

ACSL3: Microsoft Access - Creating Complex Databases Microsoft Office, Access Code: ACSL3 Create complex Access databases by structuring existing data, writing advanced queries, making use of forms & reports, & performing database maintenance.