4.45 (725 reviews)
$440
Build a database without writing code or being a database expert.
This practical hands-on course will enable you to understand the main concepts of databases and help you develop a database application. Training available on Microsoft Access 365, 2019, 2016 and 2013. Select your version when making a booking.
Design a multiple table database
Create tables and add fields and set data types
Add records
Create forms for data entry
Sort and filter data in tables and forms
Create simple queries
Create reports based on tables and queries.
Course Overview
Audience:
Students who need to learn basic database techniques and skills required to modify an existing database or create a new database.
Prerequisites:
For best outcomes, participants should be familiar with the Windows operating system and basic mouse and keyboard techniques.
Inclusions
Training Manual with step by step instructions
Practice files relevant to the training material
Training Completed files you are free to take away any completed files for review
Unlimited online support as training does not stop when you walk out our door
Course Content
Getting Started
- What is Microsoft Access?
- Basic Terminology - Tables, Records, Forms, Queries and Reports
- Understanding a relational database
- Opening Microsoft Access
- Interface Overview
- Ribbon and commands
- Quick Access Toolbar
- Closing Microsoft Access
Working with Tables
- Opening Tables
- Table Views
- Datasheet View
- Navigating Records in a Datasheet
- Adding and Editing records in a datasheet
- Managing Column widths and row heights
- Moving a Column
- Hiding / Unhiding Columns
- Freezing / Unfreezing Columns
Working with Data through Forms
- Understanding forms and their relationship to tables
- Moving a round a form
- Understanding form controls
- Find records through a form
- Filtering data
- using a data sheet
- on a split form
- by date
- by selection
- Sorting Data
- Printing records
- Export to PDF
- Export to Excel
- Deleting a record
Working with Reports
- Running a Report
- Understanding the relationship of the report data
- Veiwing the Report structure
- Printing the report
Creating a table
- Planning a new Table
- Creating a Table
- Setting Field properties and data types
- Using a Lookup field
- Setting a Primary Key
- Setting Indexes
- Entering Data into a Table
Creating Forms to View and Edit Data
- What is a Form?
- Bound vs. Unbound Controls
- Creating a Form with the Wizard
- Using Design View to Modify Your Form
Creating a New Database
- Planning a Database
- Creating a Database from a Template
- Creating a Blank Database
- Using Database Objects
- Setting Navigation Options
Creating Queries to Select Records
- What is a Query?
- Creating a Query with the Wizard
- Using Design View to Modify a Query
- Using Queries
Creating Reports
- What is a Report?
- Creating a Report with the Wizard
- Using Design View to Modify a Report
- Using Reports
Delivery Options
Public Courses
Live online - learn by doing.
Our Live Online courses are conducted through a dedicated learning platform that enables us to provide instructor-led, hands-on training to develop real skills, in real time. Each participant logs into their own virtual environment setup specifically for the course. This is a fully interactive experience - just like in a classroom. No passive lectures. No videos to follow - real time hands-on practice with your instructor guiding you every step.
Instructor:
- provides real-time live hands-on instruction and demonstration,
- provides step-by-step practical activities for participants,
- can assist participants on their screen, if necessary,
- can share participant screens to enhance discussion.
Participants:
- receive hands-on instruction, step-by-step exercises and skill-builder activities,
- see the instructor screen while working on their own environment,
- can interact with the instructor and the group of participants,
- can ask questions at any time,
- join the course from any location with internet using a Course Invitation.
- no need for any software, just a computer with internet and a browser.
- no downloads on installs necessary on the participant computer.
Inclusions:
- E-Book Training Manual/activity booklet will be provided
- Certificate of Completion
- Post-course support to the level of the course
- Access to any training exercises used during the session
Session Times:
- Full Day Course: 9:00 am-4:30 pm
- Half Day Course: 9:00 am-12:30 pm or 1:30 pm-5:00 pm
Private Courses
Private sessions can be arranged through our Live Online platform for group training. Group training content and duration can also be tailored to your needs. To discuss your training requirements, contact our Course Scheduling team.
Classroom
Classroom sessions are delivered at a nominated location (Private courses only).
Requirements:
If training is being delivered on your site:
- A computer is required for each participant, configured with appropriate software (if necessary).
- If participants are using laptops, ensure power cords are provided for use during the session.
- The instructor will bring their own laptop - please provide power
- Screen/Projector for trainer to connect their laptop to. Please indicate the connection method - hdmi or wifi.
Inclusions:
- Training Manual/activity booklet
- Certificate of Completion
- Post-course support for queries relating to the course content.
Access Essentials
| Event | Event Date | Location | Individual Price | Register |
|---|---|---|---|---|
| Access Essentials | 13-03-2026 | Live Online | $495.00 | |
| Access Essentials | 24-04-2026 | Live Online | $495.00 | |
| Access Essentials | 05-06-2026 | Live Online | $495.00 |
Brochure