Advanced Microsoft Access CourseTraining in Belfast Northern Ireland OR On your Own Premises - Call NOW to Book

17 May 2023

Our Advanced Microsoft Access training course is suitable for those with a sound working knowledge of Access who wish to progress to the most complicated functions and features.

Prerequisites

A working knowledge of Access or our Introduction to MS Access course will allow sufficient knowledge to attend our Advanced MS Access course.

Benefits

At the end of this course you will:

• Have a comprehensive understanding of the higher functions of Access
• Be able to automate functions by creating simple and then very advanced macros
• Have advanced your querying ability
• Know how to protect your database

You will then be qualified to progress to our VBA Access course.

Please contact us if you would like to:

• Discuss course content with the trainer prior to booking or attending a course
• Have us review your existing databases and make recommendations on the most appropriate course for you
• Schedule a closed course - the content of closed courses can be customised to suit your own requirements and we can even use your own databases as part of the learning tutorials - our trainers are experienced developers

Course Content

Create Expressions

• For Use Within Reports, Queries, Forms, Macros
• Definition Of (Symbols, Fields, Identifiers, Operators, Functions)
• Use To Define Calculated Control, Establish Validation Rule, Create Calculated Field
• Use To Set Condition For Running A Macro
• Create Using The Expression Builder

Forms

• Create Forms With Macros To Create A User Interface
• Create Custom Dialogue Boxes (Set Properties - Modal, Popup, Etc)
• Create Forms With Multiple Subforms
• Calculated Fields
• Use Expression Builder To Limit To Displayed Records
• Picture (Picture Properties, As Background, Etc ?€? Also For Report)

Security

• Assign & Change Database Passwords
• Security Account Password
• Prevent Users From Replicating, Setting Database Password And Changing Startup Options
• User-Level Security Wizard
• Create A New Workgroup Information File
• Join And Log Onto An Access Workgroup
• Permissions (Overview, Types, Assign & Remove Them)

Reports

• Specify Grouping Levels (Grouping Header/ Footer, Group On, Group Interval, Keep Together)
• Calculated Fields
• Report Properties (Force New Page, Keep Together, Events, Etc)
• Create Mailing Labels And Charts From Table/ Query Data

Macros

• Create A Macro (Actions, Arguments)
• Autoexec Macro
• Macro Functions (Setvalue, Setmenu Item, Msgbox, Run, Etc)
• Create A Macro Group
• Add An Action To A Macro
• Move An Action In A Macro
• Enter An Expression In A Macro Action Argument
• Enter An Expression In A Macro Action Argument
1. Carry Out Actions Depending On Criteria
2. Validate Data
• Show And Hide Macro Names And Conditions In The Macro Window

Queries

• Use The ! And . (Dot)Operators
• Expressions
• Aggregate Functions
• Parameter Queries ?€? With The Criteria Provided From A Form (Standard Or Custom Dialogue)
• Action Queries (Update, , Append)
• AutoLookup & Crosstab Queries
• Calculated Fields