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
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.
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
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.