Centre for Continuing Education

Microsoft Access Course: Level 2

Microsoft Access. Open to everyone.

Learn Microsoft Access the smart way with Microsoft Access courses at CCE, The University of Sydney.

Aims

The aim of this Microsoft Access training course is to build on the introductory skills of Microsoft Access Course: Level 1. You will learn how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and be introduced to some basic automation techniques involving macros.

Outcomes

Upon completion of this Microsoft Access training course, you should be able to:

  1. Use various data validation features in Access to protect data.
  2. Format the data in a table.
  3. Perform more advanced queries using a variety of querying techniques.
  4. Create and use parameter queries.
  5. Create calculated queries.
  6. Modify and adapt an existing form according to specific needs.
  7. Create and use macros in Access.
  8. Work with a number of macro techniques.
  9. Create and work with macros in forms.

Content

This Microsoft Access training course covers the following topics:

Data validation

  • Assigning Default Values.
  • Validation Rules And Text.
  • Validating Numbers.
  • Setting Required Fields.
  • Working With Validations.

Formatting tables

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

Querying 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.
  • Problem Characters.
  • Querying With A Lookup Table.
  • Sorting Query Data Numerically.
  • Displaying NULL Values.
  • Querying For Uniqueness.

Parameter queries

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

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.
  • Checking The Current Tab Order.
  • Changing The Tab Order.
  • Inserting The Date Into The Form Header.

Creating and using macros

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

Macro techniques

  • Creating A Print Macro.
  • Using Conditions To Enhance A Macro.
  • Creating A Sequence Of Conditions.
  • Understanding The Versatility Of MsgBox.
  • Using The MsgBox Function.
  • Reconfiguring A Message Box.
  • Using The InputBox Function.

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.
  • Creating A Search Macro.
  • Running The Search Macro.
  • Understanding The Search Macro.
  • Naming Macros.
  • Referencing Macro Sheet Macros.

Delivery Style

This Microsoft Access training course is delivered as presenter-taught computer-based training in a Microsoft Windows environment.

Intended Audience

This Microsoft Access training course assumes some knowledge of the software to create basic databases and generate reports.

You should be familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening files, saving files, familiarity with the accessing the Internet and use of common web browsers. If you do not have these skills, we recommend attending Basic Computer Skills Course and Effective Internet Use before attempting this course.

Features

  • Free repeat class - Conditions apply
  • Free USB flash drive
  • Expert trainer
  • Dedicated computer for every student
  • Small class size
  • Student notes – yours to keep
  • Statement of completion

Enrol Now
There are places available
Enrol Now
There are places available
If there isn't a class to suit you, please join the waiting list.