Microsoft Access

Introduction

Intermediate Level 1

Intermediate Level 2

Queries

Advanced

VBA Level 1

VBA Level 2

Version 2007 Upgrade

 

Register Now

 

View Course Outline PDF

(all Access Courses show in one PDF file)
 

 

 

Pay $ 345. to $ 645. for this course using TICKETS instead (Minimum Purchase of 11 Tickets).…Click here for More Information.

 

Course Dates (9am to 4pm)

 

Versions

North York

 

 

 

Version 2003

Apr 28/29/30

Aug 5/6/7

 

 

 

 

 

Course Prerequisites

 

Required: Solid understanding of all Access Introduction & Intermediate Level I topics.

 

Course Description

 

Topics include: securing a database (activating security, adding users and setting permissions), using functions (domain, date, string, logical, and case), creating macros (macro actions, conditions, autoexec and autokeys macros), creating customized menus, creating customized toolbars, the Switchboard Manager, and creating unbound forms/reports.

 

Detailed List of Topics

 

Security

Creating a Workgroup File

Creating Users & Groups

Placing Users in Groups

Setting User Passwords

Owning the Database

Opening Exclusively

Setting Permissions

Testing Permissions

Query Permissions

Permissions for Other Objects

Creating a User Table

Setting a Database Password

User Level Security Wizard

 

Access Command Line Options

Load a Database Automatically

Startup Picture

Default User Login

Default Password

Default Workgroup

No Shortcut Icon?

 

Built-in Functions

Database References

Date Functions

      Year

      Month

      Day

      Weekday

      Date

      Now

      DateSerial

Special Functions

      IIF

      Switch

      IsNull

      Format

      Eval

      CurrentUser

      CurentObjectName

Text Functions

      Left

      Mid

      Right

      Chr

      InStr

      UCase

      LCase

Domain Functions

      DAvg

      DMax

      DMin

      DSum

      DCount

      DLookup

 

Compact, Repair & Encrypt

Compacting/Repairing a Database

Compacting Database on screen

Making a Compacted Copy

Encrypting a Database

 

Creating Macros

Delete Buttons (with Wizard)

Close Buttons (with Wizard)

Creating a Macro

Macro Object vs. Macro Names

Selecting Actions

      OpenForm

      OpenReport

      MsgBox

      Maximize

      StopMacro

      GoTo Control

      Stop Macro

      GoToRecord

      Run Command

      PrintOut

      SetValue

      RunMacro

      ShowToolbar

      FindRecord

      ApplyFilter

      ShowAllRecords

Adding Where Conditions

Using the Conditions Column

Special Macro Types

      SendKeys

      AutoKeys

      AutoExec

Database Startup Settings

 

Customizing Toolbars

Editing Toolbars

Adding & Removing Icons

Resetting a Toolbar

Creating a Toolbar

Adding Icons

Icons to Open Objects

Editing Icons

Macros Icons

Copy a Icon Image

Assigning a Toolbar to a Form

Converting Macros to Toolbars

 

Customized Menus

Creating a Menu Bar

Creating the Menus

Displaying & in Menus

Fly-Out Menus

Adding Commands

Attaching a Menu to a Form

Attaching a Menu to a Report

Converting Macros to Menus

 

Switchboard Manager

Creating a Switchboard

Setting it to Open Automatically

Editing a Switchboard

Going beyond the 8 Button Limit

 

Unbound Forms & Reports

 

Changing Next AutoNumber

 

  

Computer Training Courses, SoftSkills Seminars & Access Database Development

Computer Help is a division of MPM Skills Development Inc.
Toronto, Ontario, Canada.

Phone: 416.494.4912, Fax: 416.494.9952

www.Computer-Help.ca

Question or Comment - Email Us