Microsoft Access Training - Essentials Course
Learn the basics of Microsoft Access for effective database management
All courses available in-class or remotely. To attend remotely, select "Remote East" or "Remote West" as your location on book now.
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.
Microsoft Access Training - Essentials Course
Learn the basics of Microsoft Access in 2 days. Understand table creation, manage data, and design queries for effective database management.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
Access Essentials Course Details
Access Essentials Course Details
Access Essentials Course Details
Access Essentials Course Details
Access Essentials Course Details
Access Essentials Course Details
Access Essentials Course Details
Access Essentials Course Details
Access Essentials Course Details
Access Course Outlines
Microsoft Access City Pages
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
