Access Adv

Access Adv

Our 1 day Advanced Microsoft Access training course is suitable for those with a sound working knowledge of Microsoft Access 2007, Microsoft 2010 or Microsoft 2013 and 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 complete understanding of the higher functions of Access.
• You will learn to automate functions by creating simple and then very advanced macros.
• You will advance your querying ability and then to use SQL statements in your queries.
• You will discover how to work with objects, and the fundamentals of database management.
• Finally you will be taught how to protect your valuable data sources.
• You will then be qualified to progress to our VBA Access course.

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
• Use Conditions To:
  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