Training Courses

search courses

ACSL2: Microsoft Access - Creating Relational Databases

Guaranteed to Run Scheduled Fully Booked
Location
Wellington
Auckland
Christchurch
Oct 2020
13
15
29
Nov 2020
3 17
30
Dec 2020
1
17
Jan 2021
12 26
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
14
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