Australia
New Zealand
Hong Kong
Malaysia
Philippines
Thailand
Indonesia
Microsoft Access Training - Essentials Course - Singapore
Learn the basics of Microsoft Access for effective database management
Learn the basics of Microsoft Access for effective database management
5.00
Learn the basics of Microsoft Access for effective database management
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.
Instructor-led courses, delivered remotely across Singapore.
Course Details
Download Course PDF
Upcoming Courses
Access Training Courses
Access EssentialsThis 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.
Instructor-led courses, delivered remotely across Singapore.
Access AdvancedThis 2-day Microsoft Access Advanced course is designed for individuals looking to expand their knowledge and skills in database management. Learn to create complex queries, customise reports, implement macros, and optimise database performance to meet advanced data management needs.
Instructor-led courses, delivered remotely across Singapore.
Access Essentials Singapore 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
Frequently Asked Questions
What is Remote Training?
Remote training at Nexacu, means our team of experienced trainers will deliver your training virtually. With remote learning students can access our usual classroom training courses via video conferencing, ask questions, participate in discussion and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions.
Which courses are available if I am working from home?
Currently all of our Public Courses are available to be delivered remotely. Book any course as normal and you will receive login details and instructions in the days before your course.
How can I prepare if I am attending an online course?
The browser you use is very important. It is recommended you use Chrome, Edge, or Firefox. The latest version must also be installed. Note that Internet Explorer is not compatible with our delivery technologies.
Windows 10 is highly recommended as the operating system you use. If you are using an apple device, use Safari or a similar modern browser if you cannot use any of the browsers recommended above. Your training experience may diminish due to different features and appearances. Nexacu's trainers are unable to provide detailed guidance for macOS.
To download and unzip files, log in to your student portal. Click on the "Materials" tab and download your exercise files.
Extract your Exercise Files to the specified folder below. Note you will have to create this folder first.
