Training Courses

search courses

ACSL2: Microsoft Access - Creating Relational Databases

Guaranteed to Run Scheduled Fully Booked
Location
Wellington
Auckland
Oct 2021
19
Nov 2021
2 16 30
Dec 2021
14
2
Jan 2022
18
Feb 2022
1 15
Mar 2022
1 15 29
Apr 2022
12 26
May 2022
10 24
Jun 2022
7 21
Jul 2022
5 19
Aug 2022
2 16 30
Sep 2022
13 27
Oct 2022
11 25
Nov 2022
8 22
Dec 2022
6 20
Code: ACSL2
Length: 1 Day
Overview

Expand your knowledge of relational database design.

Delivery format(s)
On-Site
On-Site
Classroom
Classroom
Anywhere
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

Enquiry Form