Home, sweet home
View when our computer courses are being run
See what each computer course entails
See what Computer Solutions s.c. can do for you
Need a website?  Let Computer Solutions s.c. design one for you
See where Computer Solutions s.c. likes to surf
Click here to tickle your funny bone
See our Computer newsletter
Send the Webmaster some email

 

Microsoft Access 2000 - Level 3

Course Outlines

Course Schedule

Course Description

This course is meant to expand on the previous levels of Access offered by Computer Solutions s.c..  This includes advanced forms, and form field functions, totaling data inside of queries, creating macros, using a switchboard, and an introduction to Visual Basic.  It is intended for users who are charged with creating a user-friendly database application.  Using the techniques discussed in this course, the designer can minimize user input errors.

It is also intended to show the students ways of interpreting and displaying data.  Creating forms with sub-forms built in to display additional information does this.  Detail tables may also be used to organize repeated data.  The inclusion of basic Visual Basic theory will aid the developer in creating a more error free environment for the end-user.  Functions and procedures will be touched on.  Although the depth of the Visual Basic component offered in this course is limited, it will give the student a foundation from which to expand his/her programming knowledge.

Course Objectives

Ø      Learn how to create Tabbed Forms

Ø      Learn how to use Sub-Forms and Detail Tables

Ø      Creating and using Macros

Ø      Automating the Startup Screen for a Database

Ø      Using Totals inside of Queries

Ø      Creating Calculated Controls within Forms, Queries, and Reports

Ø      Introducing Visual Basic

Ø      When to use Code instead of Macros

Ø Creation of Procedures and Functions

Duration

The duration of the course is one day. This day begins at 8:30 am and ends at 4:30 pm.

Pre-requisites

The student must have an understanding of basic database design theory.  It is recommended that attendees take Access Level 1 and Access Level 2 before attempting Access Level 3.


Table of Contents

Introduction
A. Purpose
I Database Models
A. The Centralized Database Model
B. The Inclusive Model
C. Linking Data
II The User Interface
A. Things to Consider
IV Forms
A. Form Controls
B. Differences Between Using Multiple Pages and Tabs on a Form
C. Using Sub-Forms
D. Change Tab Order In a Form
V Using Visual Basic Code
A. Form Controls
B. Conditional Statements
C. DoCmd Object
VI Creating Switchboard Forms
A. Using the Switchboard Manager
VII Macros
A. What is a Macro?
B. Create a Macro
C. Considerations When Setting Options in the Startup Dialog Box
D. Using the Startup Options

Relevant Links
Access Level 1
Access Level 2
Database
Development
Our Services