Byron Employment

Byron Employment. Over 71,639 Jobs Australia Wide.

Delivery Method

  • Distance Learning
  • Price: $345.00

Course Overview

The skills and knowledge covered in this course are sufficient to automate operations using macros, secure and prtect data and have a general understanding of the programming environment of Microsoft Access 2003. This course is primarily desgined for those who need to know how to automate operations using Acess 2003.

Learn To

  • Split the tables from a database file
  • Completely secure a database file and its objects so that unauthorised access is prevented
  • Create and maintain multiple copies of a database file
  • Create aggregated queries
  • Create a data access page
  • Create data access pages using the Design View
  • Create simple macros
  • Use conditions in macros
  • Create macros that used with forms
  • Create a macro for an option group to provide instant filtering
  • Write a simple procedure in VBA

Objectives

Splitting a Database

  • Using the Database Splitter
  • Working with a Split Database
  • Updating Database Links

Database Security

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

  • 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

Aggregate Queries

  • 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

Data Access Pages

  • Creating a Data Access Page
  • Applying Themes to Data Access Pages
  • Working with Data Access Pages
  • Using a Data Access Page
  • Outside Access

Data Access Page Techniques

  • 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 PivotTable List
  • Creating a Scrolling Marquee
  • Formatting a Page

Macro Basics

  • Macros Versus VBA
  • Creating a Macro
  • Running a Macro
  • Modifying an Existing Macro
  • Interacting With the User
  • Documenting Macros

Macro Techniques

  • 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 an A Condition
  • Reconfiguring a Message Box
  • Using The InputBox Function

Macros on Forms

  • 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

Option Groups and Macros

  • 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

VBA Introduction

  • 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
  • Project - Loan Simulator Code
  • Testing the Code
  • Modifying a Module
  • Creating a Button on a Form
  • Running a Procedure from a control
  • Navigating the VBA Editor
CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 9779 9800
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 9779 9800 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search