02 4967 5631

0416 056 759


Access Intermediate


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