Access v7

Introduction to Access v7:

• 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

Intermediate Access v7:

• 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 v7:

• 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 v7 - New Features

• Initial differences
• Converting a database
• Running converted and unconverted versions
• Compatibility issues
• Tips when converting a database

• Create Tables in Datasheet View
• Redesign Tables in Datasheet View
• Transferring Data to Other Applications
• Spell Check and AutoCorrect
• Filtering Records
• Sort Records
• Formatting Datasheets
• Synchronise Multiple Copies of a Database
• Querying Data
• Make-Table Query

• New Wizards
• Improved Wizards
• Linked Table Manager
• Pivot Table Wizard

• Menu builder Wizard
• Create a Custom Shortcut Menu for a Form, Report, or Control
• Create a Custom Menu and its Commands

• The LookUp Wizard
• Subform/Subreport Wizards

• Create a Replica of your Database
• Changes Made when you Replicate
• Fields that are added to each existing table in the database
• New tables that are added to the database
• New properties that are added to the database
• Changes to the behavior of AutoNumber fields
• Changes to the size of the database file

• What’s New with Database Design
• Create a Database Using a Database Wizard.
• Optimize Your Database's Performance.
• Save Network Overhead with the Splitter Wizard.
• Set Properties for Your Database.
• Easily Customize Your Database.
• Control how an Access Database or Application Starts
• Considerations when Setting Options in the Startup Dialog Box.