Training Courses

search courses

ACSL1: Microsoft Access - The Essentials

Guaranteed to Run Scheduled Fully Booked
Location
Wellington
Auckland
Christchurch
Sep 2020
28
Oct 2020
12
12
16
Nov 2020
2 16 30
27
Dec 2020
7
Jan 2021
11 25
Feb 2021
9 22
Mar 2021
8 22
Apr 2021
6 19
May 2021
3 17 31
Jun 2021
14 28
Jul 2021
12 26
Aug 2021
9 23
Sep 2021
6 20
Oct 2021
4 18
Nov 2021
1 15 29
Dec 2021
13
Code: ACSL1
Length: 1 Day
Overview

Learn how to use Microsoft Access to manage data and create a database.

Delivery format(s)
On-Site
On-Site
Classroom
Classroom
Anywhere
Anywhere
OBJECTIVES
Learn how to use Microsoft Access to manage data and create a database
PREREQUISITES

None.

WHAT YOU’LL LEARN

After completing this course, students will be able 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.
COURSE OUTLINE

Getting Started with Access 
 Orientation to Microsoft Access 
 Create a Simple Access Database 
 Get Help and Configure Options in Microsoft Access 

Working with Table Data 
 Modify Table Data 
 Sort and Filter Records 

Querying a Database 
 Create Basic Queries 
 Sort and Filter Data in a Query 
 
Using Forms 
 Create Basic Access Forms 
 Work with Data on Access Forms

Generating Reports 
 Create a Report 
 Add Controls to a Report 
 Enhance the Appearance of a Report 
 Prepare a Report for Print 
 Organise Report Information 
 Format Reports

Enquiry Form