Access 2000

Introduction to Access 2000:

• 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

• Records
• Sorting the Table
• Deleting a Table
• Table Layout Changes
• Find
• Replace Pasting
• 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 2000:

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

• 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 2000 Database Administration

• Sharing an Access database on a network
• Editing data in an Access database in a multiuser environment
• Saving design changes to a shared database
• Choosing a record-locking strategy
• Optimizing multiuser performance
• Sharing an Access database on a network server
• Specifying the default record-locking strategy used in a multiuser environment
• Avoiding data-locking conflicts
• Changing how often data is updated

• 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

• 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

• 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 2000 Database Programming Introduction:

• 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

• Data Access Pages
• Creating a data access page by using AutoPage
• Creating a data access page by using a Wizard
• Making an existing Web page into a data access page
• Form vs report vs report snapshot vs data access page
• Strategies for creating data access pages
• Grouping records on a data access page
• Connecting a data access page or other Web page to a database
• Types of data sources for a data access page
• Calculating totals
• Themes
• Choosing a default theme for new data access pages
• Example 1
• Example 2

• Accessing the Internet from MS Access 2000
• Web Pages created by MS Access 2000
• How Web server processes server-generated HTML format
• Web Folders
• Creating a Web Folder
• Where to save on the Web
• Publishing a data access page to Web Folders or any Web server
• Sharing the database connected to a data access page
• Publishing server-generated HTML files to a Web server
• Publishing static HTML files to Web Folders or any Web server
• Saving a copy of a data access page to a Web server in Windows Explorer
• Saving a copy of a data access page to a Web server in Access
• Opening a data access page on a Web server in Access

Introduction to Microsoft Web Folders

• Using Hyperlinks in Table Fields
• Using Text Hyperlinks on Forms
• Using Graphical Hyperlinks on Forms

• Report Snapshots
• Snapshot Viewer
• Benefits of report snapshots and Snapshot Viewer
• Using Report Snapshots
• Using Report Snapshots on the WWW
• Sending report snapshots in e-mail
• Creating a report snapshot
• Creating a report snapshot by using the OutputTo action and publish it to the Web
• Exercises