Training Courses

search courses

ACSL1: Microsoft Access - The Essentials

Guaranteed to Run Scheduled Fully Booked
Location
Wellington
Oct 2021
18
Nov 2021
1 15 29
Dec 2021
13
Jan 2022
17 31
Feb 2022
15 28
Mar 2022
14 28
Apr 2022
12 25
May 2022
9 23
Jun 2022
6 20
Jul 2022
4 18
Aug 2022
1 15 29
Sep 2022
12 26
Oct 2022
10 24
Nov 2022
7 21
Dec 2022
5 19
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