Byron Employment

Byron Employment. Over 158,183 Jobs Australia Wide.

Delivery Method

  • Classroom

Upon completion of our Microsoft Access 2003 level 2 training you will know how to automate operations, protect and secure data, and perform complex queries in Microsoft Access 2003. It is ideal for people who working in offices, clubs or for home use.

Completion of Microsoft Access level 1 or equivalent experience.

The course duration is 2 days.

Delivery Method

One on one training can be arranged.

Group bookings only - all states and territories.

Splitting a database

Database security

Using the database splitter
Working with a split database
Updating database links
Splitting a database quick reference
Understanding database security
Creating a workgroup
Creating an administrator
Removing the default admin user
Logging on as the system administrator
Securing a database
Adding groups
Adding users
Assigning permissions
Testing database security
Joining another workgroup
Database security quick reference

Action queries

Macro basics

Creating a make table query
Viewing a table created by a make table query
Expressions & update queries
Preparing an update query
Running an update query
Creating a saved update query
Running a saved query
Creating a delete query
Creating an append query
Action queries quick reference
Macros versus VBA
Creating a macro
Running a macro
Modifying an existing macro
Interacting with the user
Documenting macros
Macro basics quick reference

Aggregate queries

Macro techniques

Creating an aggregate query
Working with aggregate queries
Creating queries with multiple aggregates
Modifying aggregate headings
Aggregating calculated fields
Applying criteria to aggregates
Creating a query to nest
Creating an aggregate from a query
Aggregate queries quick reference
Creating a print macro
Using conditions to enhance a macro
Creating a sequence of conditions
Using the msgbox action statement
The msgbox function
Using msgbox in a condition
Reconfiguring a message box
Using the inputbox function
Macro techniques quick reference

Table & query relationships

Macros on forms

Understanding join types
Using default joins
Orphan records
Viewing orphan records
Deleting orphan records
Creating an exception query
Viewing a query in sql
Table & query relationships quick reference
Creating an event macro
Creating a group macro
Attaching macros from a group
Creating a group macro for forms
Attaching macros to form events
Setting form properties
Testing form property changes
Macros on forms quick reference

Database replication

Option groups and macros

Understanding database replication
Creating a replica
Creating additional replicas
Creating a partial replica
Synchronising to a replica
Synchronising from a replica
Synchronising to a partial replica
Database replication quick reference
Testing a sample option button macro
Creating an option group
Copying toggle buttons
Option group properties
The applyfilter macro action
Creating a filter macro
Using the applyfilter macro action
Handling exceptions
Attaching a macro to an option group
Option groups and macros quick reference

Data access pages

VBA introduction

Creating a data access page
Applying themes to data access pages
Working with data access pages
Using a data access page outside access
Quick reference
Introductory VBA terminology
Writing a simple form procedure
Examining a simple sub procedure
The msgbox and inputbox functions
Editing an existing procedure
Creating a standard module
Testing the code
Modifying a module
Creating a button on a form
Running a procedure from a control
Navigating the VBA editor
VBA introduction quick reference

Data access page techniques

Database protection

Creating a data access page design
Promoting and demoting fields
Working with data access page fields
Displaying related records
Formatting a pivot table list
Adding columns to a pivot table list
Creating a scrolling marquee
Formatting a page
Quick reference
Setting a password
Opening a file with a password
Removing a password
Encoding a database file
Decoding a database file
Hiding database objects
Viewing and unhiding an object
Database protection quick reference

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (03) 9699 4940
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (03) 9699 4940 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search