Access Data Processing Course Details

Introduction To Databases

• What Is A Database?

• Computerising A Database

• Designing An Access Database

• Defining A Data Store

• Populating A Database

• Extracting Information From A Database

• Reporting Data

Getting Started With Access 2000

• Starting Access 2000

• Access 2000 Opening Screen

• The Title Bar

• The Menu Bar

• Toolbars

• The Status Bar

• Menus And Submenus

• Speedkeys

• The Database Window

• The Database Window Toolbar

• Scroll Bars

• Exiting Access

Getting Assistance With Access 2000

• Using The Office Assistant

• Getting Help Without The Office Assistant

• Manipulating The Help Window

• Help For Screen Objects – Screentips

Creating Tables And Adding Records

• Creating A Table Using The Table Wizard

• Datasheet View

• Adding A Record

• Saving Changes

• Moving Around The Datasheet

• Finding A Record

• Modifying Records

• Deleting A Record

Designing Table Structures

• Table Design - Hints And Tips

• Creating Tables

• Switching Between Views

• Saving Tables

• Field Properties

• Field Size Property

Working With Data 

• Sorting Data

• Filtering Data

• Using Advanced Filters

Simple Select Queries

• What Is A Query?

• Creating A Query

• Modifying A Query

• Restricting Records Returned By A Query

• Simple Calculated Fields

• Summary Queries

• Multi-Table Queries

Forms

• What Is A Form?

• Using Autoform To Design Forms

• Using Wizards To Design Forms

• Entering Data Using A Form

Simple Reports

• Reporting From Access

• Printing From Datasheet View

• Autoreports

• Designing A Report

• Using Report Wizards

• Label Reports

• Modifying Reports

Access Tools

• Importing From Other Data Sources

• Importing Data Using Drag-And-Drop

• Backing Up And Restoring A Database

• Compacting And Repairing A Database