Courses

• ≡   Nationally Recognised Qualifications
   
• ≡   Desktop Applications
   
• ≡   Short Courses
   
• ≡   IT Technical Training
   

Recently Viewed Courses

≡ Access 2007/10 Lvl 2  x

Email This List or Clear List

Microsoft Access 2007/2010 - Level 2 - Intermediate

This course has been mapped against the learning outcomes and performance criteria for the Unit of Competency BSBITU301A Create and use databases from the Certificate III in Business. Successful completion of this course and the required assessments leads to a Statement of Attainment.

     

Dates for next course:	18-Jun-13, 20-Aug-13 and 22-Oct-13
Training Location	9 Denison St, Newcastle West
Training Format:	Classroom
Duration:	1 days
Price:	$440.00   This course is GST free

Overview

In this course, students will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and also by performing database maintenance. (Second Edition). This course is not suitable for Access 2002/2003. Our earlier courses can be found here

Learning Outcomes

At the completion of Microsoft Access 2007 Level 2 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
• create and use macros in Access
• work with a number of macro techniques
• create macros on forms

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
• Querying 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

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

Forsythes Training provides instructor led computer training on the Microsoft Office and Adobe range of applications. We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia.With our mobile training room we can provide a range of courses on-site at your premises.