Centre for Continuing Education

Microsoft Access Course: Level 2

Microsoft Access. Create databases fast without being a developer.

Learn Microsoft Access the smart way with Microsoft Access courses at 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

What others say.

  • This is the best teacher I have come across after 5 years of high school and 5 and a half years of university. He is one of the rare few capable of teaching in a way that neglects neither the talented students, nor the students who are struggling in the class. I highly recommend these classes.

  • A very well structured course. The tutor was very helpful and friendly and had made the difficult concepts easy enough to understand and follow. The class was packed with information but I was never once bored or lost track of things.

  • Great one day course. Venue was very well located and equipped. Very impressed indeed. I’ll be back for Level 3!

  • It was a very busy day! I was most appreciative of the efforts of the presenter to outline details which would be essential in my work with MS Access. He was very knowledgeable and capable and ready to help all students including myself if/when difficulties arose.

Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
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.