Access 2007 Intermediate

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

Audience

Microsoft Access 2007 Intermediate is designed for users who have an understanding of how tables are created, records are entered, modified, and delete, and how simple queries, reports and forms are created.

Learning Outcomes

After completing this course, students will be able to:

� Use various data validation features in Access to protect data

� Format the data table

� Perform more advanced queries using a variety of querying techniques.

� Create and use parameter queries.

� Create calculated queries.

� Create. And use macros in Access.

� Work with a number of macros techniques.

� Create macros on forms

Prerequisites

Microsoft Access 2007 Intermediate assumes the student can create databases comprising of tables, simple queries, forms and reports. It would also be beneficial to have general understanding of personal computers and Windows operating system environment.

Price:		$253.00 (inc GST)

Course Outline

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 The 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

Query Using Wildcards

Problem Characters

Querying With A Lookup Table

Parameter Queries

Creating A Parameter Query

Displaying All Records

Using Parameters To Display A Range

Using Parameters In Expressions

Calculating In Queries

Creating A Calculated Query

Formatting Calculated Fields

Summarising Data Using A Query

Changing The Grouping

Calculating With Dates

Using Criteria In Calculations

Concatenating String Fields

Creating And Using Macros

Understanding Macros And VBA

Creating Macro

Running A Macro

Modifying An Existing Macro

Interacting With The User

Stepping Thru A Macro

Documenting Macros

Macro Techniques

Creating A Print Macro

Using Conditions To Enhance A MacroCreating 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 And 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

More Access Courses

Access 2007 Introduction

Access 2007 Advanced

Access 2003 Introduction

Access 2003 Intermediate

Access 2003 Advanced

Can't find a course or interested in corporate bookings?

Other course dates available for corporate bookings. Click here for more information »