Access 97

Introduction to Access 97:

• database concepts
• database layout
• launching access.
• the access menu system
• dialog boxes
• getting help
• creating a new database
• closing a database (vs exit access)
• opening a database

• Pasting Records
• Sorting the Table
• Deleting a Table
• Table Layout Changes
• Find
• Replace
• Wildcards

• Database Design.
• Creating Tables Using the Table Wizard
• Creating Tables In The Datasheet View
• Creating Tables in the Design View
• Data Types
• Field Properties
• Data Display Format Vs Input Mask
• The Input Mask
• Data Entry Problems
• Moving and Copying Records

• The Simple Query Wizard
• The Design View
• Modifying the Query
• Using Basic Criteria
• Additional Criteria
• Parameters
• Multiple Object Queries
• Custom Calculations in a Query
• Calculating Fields continued
• Grouping Fields

• Reports
• The Report Wizard

Intermediate Access 97:

• Types Of Query
• The Crosstab Query
• The Make Table Query
• The Append Query
• The Delete Query
• The Update Query

• Reports.
• AutoReport
• The Report Wizard
• Creating a Report With Calculated Totals.
• Using the Chart Wizard
• Altering the Chart
• Using the Label Wizard
• Modifying and Redesigning The Report.

• Forms.
• Using AutoForm
• Creating A New Form
• Using the Form Wizard
• Creating A Form With A Subform.
• Modifying And Redesigning The Form
•  

• What Is Database Replication?
• Creating and Maintaining a Replicated Database
• Replication Commands
• To Replicate The Database With Access:
• To Use Briefcase To Create A Replica
• Synchronisation
• Resolving Synchronisation Conflicts
• Convert A Replica Set To Access 97

Advanced Access 97:

• Database Concepts.
• Database Design
• Normalisation
• Database Integrity
• Types of Relationship
• Creating Table Links
• Referential Integrity

• Optimising Performance
• The Performance Analyzer
• The Add in Manager
• Compacting Your Database
• The Database Documentor
• The Database Splitter
• Recovering Damaged Databases
• Importing And Linking Tables

• List And Combo Boxes
• Check Boxes, Option & Toggle Buttons.
• Option Groups
• Command Buttons
• Calculated Fields.
• Using Form’s Input Values
• Create A Form With Multiple Pages Or Tabs
• Tab Order
• Inserting Graphics in Forms or Reports
• AutoFormat

• Securing A Database
• Adding A Database Password
• Setting User Level Security
• Workgroups
• Activating the Logon Procedure
• Creating and managing security accounts
• Creating A Security Group Account
• The Security Wizard
• Changing Ownership
• Assigning and Removing Permissions
• Encrypting and Decrypting a Database

Access 97 (Macros & Programming)

• Using Access 97Built in Macros
• Access (Basic) Macro Sequences
• Assigning Macros to Command Buttons
• Using Macros in a Menu System
• Creating a basic Menu System with Macros
• Exercises

• Overview of VBA
• Macros
• Creating Macros
• Opening a Macro
• Adding an action to a Macro
• Opening the Macro or Module windows from a form or report
• Creating a Macro
• Creating a Macro Group
• Setting action arguments in a macro
• Entering an expression in a macro action argument
• Using conditions in a macro
• Running a macro
• Running a macro from another macro or from a Visual Basic procedure

• Controls
• Label
• Text Box
• Check Box
• Option Button
• Option Group
• toggle buttons or option buttons
• List Boxes
• Combo Boxes
• Drop-down list boxes

• Creating a Command Button
• Making a command button on a form a Cancel button
• Hiding a command button on a form
• Creating an event procedure for a command button on a data access page
• Creating a command button that finds a record
• Creating a command button that edits or applies a filter on a form
• Creating a command button that prints or mails a report
• Creating a command button on a form that prints a table
• Creating a command button on a form that runs a query or a macro