Australia
New Zealand
Singapore
Hong Kong
Malaysia
Philippines
Thailand
Indonesia
Microsoft Access Training - Essentials Course
Learn the basics of Microsoft Access for effective database management
Delivered remotely across APAC.
Microsoft Access Training - Essentials Course
This 2-day Microsoft Access Essentials course is designed to introduce you to the fundamentals of database design using Microsoft Access. Gain practical skills in creating tables, managing data, designing queries, and generating reports to effectively manage and utilise your databases.
Delivered remotely across APAC.
US$0
10 max
2 days
US$0
10 max
2 days
US$0
10 max
2 days
US$0
10 max
2 days
US$0
10 max
2 days
US$0
10 max
2 days
Select your country to view prices, and course dates.
Upcoming Courses:
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.
Access Essentials Course Details
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Access Essentials Course Details
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Access Essentials Course Details
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Access Essentials Course Details
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Access Essentials Course Details
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Access Essentials Course Details
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Access Course Outlines
Other Courses
Other Courses
Course Rating
Contact Us
What do I need to know to attend?
A basic understanding of Windows and experience with one other Windows application, such as Word or Excel.
Access Essentials Learning Outcomes
- Create tables with appropriate fields, data types, and properties
- Establish relationships between tables
- Design user-friendly forms
- Generate and print professional reports
Access Essentials Course Content
- Introduction to Microsoft Access
- Understanding the Microsoft Access Interface
- Starting and Exiting Microsoft Access
- Overview of Database Fundamentals
- Table Design and Data Entry
- Designing Tables with appropriate fields and properties
- Understanding field properties and data types
- Entering and modifying table data
- Working with Lookup Lists
- Creating Tables for Lookup Lists
- Setting up and managing Lookup Lists
- Sorting, Finding, and Filtering Data
- Sorting data within tables
- Finding and filtering records
- Using the Replace function for data management
- Creating Simple Queries
- Introduction to Query Design
- Creating basic queries to extract specific data
- Applying criteria to queries for focused results
- Normalisation Techniques
- Understanding 1st, 2nd, and 3rd Normal Forms
- Normalising data to ensure database efficiency
- Structuring tables to eliminate redundancy
- Managing Table Relationships
- Defining relationships between tables
- Understanding primary and foreign keys
- Implementing relationship types (One-to-Many, Many-to-Many)
- Importing and Linking Data
- Importing data from other applications
- Linking Access Tables from other Access files
- Using the Database Splitter for data management
- Applied Queries and Calculations
- Creating Multi-Table Queries
- Working with Parameter Queries
- Performing calculations within queries
- Creating Forms
- Introduction to Form Design
- Customising forms for data entry and navigation
- Report Design and Printing
- Designing reports to present data effectively
- Setting default margins for reports
- Generating and printing reports from your database
phone
email
enquiry
