Microsoft Access 2003/2007/2010 Advanced Training Belfast NI

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
Insert 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:
Carry Out Actions Depending On Criteria
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, Delete, Append)
AutoLookup & Crosstab Queries
Calculated Fields