This Advanced Microsoft Access course will give you in-depth knowledge of Access, including relational databases, complex queries, macros and integration with other MS applications.
Intermediate
2 Day Course
Certification Awarded
Online Support
Learning options for this course
![Classroom Training](https://iact.ie/wp-content/uploads/2021/04/Webinar-training.png)
Private Company
This course can be customised to your requirements and delivered exclusively to your employees at your premises, our centre, or globally as a live session.
![Classroom Training](https://iact.ie/wp-content/uploads/2021/04/Classroom-training.png)
Public Classroom
This course can be taken in a classroom setting at our Training Centre in Dublin 2. Maximum class size is 12 learners. Full interaction with expert trainers.
![Live Virtual Classroom](https://iact.ie/wp-content/uploads/2021/04/Virtual-training.png)
Live Virtual Classroom
Daytime or evenings using iLiveLearning. Full interaction with the trainer, just like in the classroom. Software provided, all you need is a computer / laptop.
Course overview
- This course starts by reviewing the design concepts for building a robust relational model. You will gain a fast, practical and extensive knowledge of the powerful features of Microsoft Access, learning how to build tables, forms, queries, reports and macros.
Skills you’ll learn
- Review of database theory
- Data modelling
- Design and building
- Tables
- Queries
- Forms
- Reports
- Macros
- Linking to external databases
- Access VBA
Who would benefit
- If you are currently working with Microsoft Access, this course is ideal for you.
Why take this course
- To become proficient in building and developing robust, scalable multi user Microsoft Access databases applications.
Certification
- At the end of the course, you’ll be Certified by the Irish Academy of Computer Training.
- CPD Certification
Requirements
- Completion of Access Foundations
- Software is provided in the Classroom and Live Virtual options
Learning paths
- Complete after our Access Foundations Course
- Part of IACT’s Microsoft 365 Learning Path
Why choose IACT
- Ireland’s leading training provider for 30 years
- Full-time Certified Trainers who use the software every day
- Smaller class sizes to accelerate learning
Course curriculum
Module 1 : Access Essentials
- Creating Tables
- Adding Fields
- Specifying Data Types
- AutoNumber
- Short Text
- Long Text
- Number
- Date/Time
- Currency
- Yes/No
- OLE Object
- Hyperlink
- Attachment
- Calculated
- Lookup Wizard
- Advanced Field Properties
- Field Size
- Format
- Input Mask
- Caption
- Default Value
- Validation Rule
- Validation Text
- Required
- Allow Zero Length
- Unicode Compression
- IME Mode
- IME Sentence Mode
- Text Align
- Primary Key – Simple
- Primary Key – Composite
- Indexing
Module 2 : Data Modelling
- Data Anomalies
- Database Normalisation
- First Normal Form
- Second Normal Form
- Third Normal Form
- Data Modelling Tips
- Referential Integrity
- Cascade Update
- Cascade Delete
- Relationships
- One to One
- One To Many
- Many To Many
Module 3 : SQL SELECT QUERIES
- SQL Order By Clause
- SQL Order By Clause
- SQL Group By Clause
- SQL Where Clause
- Parameter Queries
- Combining Clauses
- Aggregate Functions
- SUM
- MIN
- MAX
- AVG
- COUNT
- Action Queries
- UPDATE
- DELETE
- APPEND
- Calculations in Queries and Formatting Results
Module 4 : Forms
- Forms
- Form Design
- Blank Form
- Form Wizard
- Navigation Forms
- Sub Forms
- Form Dialogs
- Working with Controls, and Layout Views
Module 5 : Reports
- Reports
- Report Design
- Blank Report
- Report Wizard
- Labels Report
- Working with Controls, and Layout Views
Module 6 : Advanced SQL
- Creating Data
- Insert Single Record
- Insert Multiple Records
- Reading Data from multiple tables
- SQL Select Statement with Joins
- Updating Data
- SQL Update Statement
- Deleting Data
- SQL Delete Statement
- Make Table Query
- ..INTO STATEMENT
- Joining Data from Multiple Tables
- Inner Join
- Left Join
- Right Join
- Outer Join
Module 7 : Visual Basic for Applications VBA
- Modules Subroutines and Functions
- Subroutine / Function Scope
- Creating Variables
- Variable Scope
- Form Input / Output
- Conditional Logic
- IF Statement
- Select Case Statement
- Boolean Logic
- Using Switchboards
- Setting the Start-up Screen
- Macros
- Creating and assigning to Objects
- Editing Macros
- Startup Macro
Contact us.
We'll reply quickly.
Enquiry
I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.