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