skip to navigation skip to content
Self-taught course

Provided by: University Information Services


Booking

This course is self taught (Materials may be loaned out).

Bookings cannot be made on this course (Course is not taking bookings).

More information about UIS self-taught courses.


Booking / availability

Microsoft Access 2013 - Level 2 (with Challenge Exercises)
LoanNew

Self-taught course

Description

The aim of this course is to build on the introductory skills of Level 1. The student learns how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros.

Target audience

Anyone who wants to further their skills with Microsoft Access 2013.

Prerequisites

Microsoft Access 2013 - Level 2 (with Challenge Exercises) assumes some knowledge of the software to create basic databases and generate reports. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Topics covered

Data Validation

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

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
  • Practice Exercise
  • Practice Exercise Sample

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
  • Practice Exercise
  • Practice Exercise Sample

Parameter Queries

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

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
  • Practice Exercise
  • Practice Exercise Sample

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
  • Practice Exercise
  • Practice Exercise Sample

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
  • Practice Exercise
  • Practice Exercise Sample

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
  • Practice Exercise
  • Practice Exercise Sample

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
  • Practice Exercise
  • Practice Exercise Sample
Objectives

At the completion of this course you should be able to:

  • use various data validation features in Access to protect data
  • format the data in a table
  • perform more advanced queries using a variety of querying techniques
  • create and use parameter queries
  • create calculated queries
  • modify and adapt an existing form according to specific needs
  • create and use macros in Access
  • work with a number of macro techniques
  • create and work with macros in forms
Format

Watsonia workbook with 101 topics. Files for the exercises are provided on a CD or can be downloaded here

System requirements

Windows with Microsoft Access 2013

Duration

Approximately 10 hours

Related courses
Theme
Spreadsheets

Booking / availability