DATA VALIDATION

• Assigning Default Values
• Validation Rules And Text
• Validating Numbers
• Setting Required Fields
• Testing Validation Rules

FORMATTING TABLES

• Changing Column Widths
• Formatting Cells In The Table
• Changing Fonts
• Moving Columns In A Table
• Freezing Columns In A Table
• Hiding Columns In A Table
• Unhiding Columns

QUERY TECHNIQUES

• Modifying A Saved Query
• Creating AND Queries
• Creating OR Queries
• Querying Numeric Data
• Querying Dates
• Using A Range Expression
• Querying Opposite Values
• Moving Fields In A Query
• Sorting Query Data
• Removing Fields From A Query
• Querying Using Wildcards
• Querying With A Lookup Table
• Sorting Query Data Numerically
• Displaying NULL Values

PARAMETER QUERIES

• Creating A Parameter Query
• Displaying All Records
• Using Parameters To Display A Range
• Using Parameters In Expressions

CALCULATIONS IN QUERIES

• Creating A Calculated Field
• Formatting Calculated Fields
• Summarising Data Using A Query
• Changing The Grouping
• Calculating With Dates
• Using Criteria In Calculations
• Concatenating String Fields

MODIFYING FORMS

• Understanding Form Design And Layout
• Switching Between Form Views
• Selecting Form Objects
• Working With A Control Stack
• Changing Control Widths
• Moving Controls On A Form
• Aligning Controls
• Understanding Properties
• Changing Label Captions
• Adding An Unbound Control
• Adding A Control Source
• Formatting A Control
• Changing The Tab Order
• Inserting The Date Into The Form Header

CREATING AND USING MACROS

• Understanding Macros And VBA
• Creating And Running A Macro
• Modifying An Existing Macro
• Interacting With The User
• Stepping Through A Macro

MACROS ON FORMS

• Understanding Macros On Forms
• Creating Navigation Macros
• Accessing Event Macros
• Creating Unassigned Buttons
• Programming An Event
• Running An Event Macro
• Modifying An Event Macro
• Setting Echo Off
• Adding A Close Button