Microsoft Access 2000 Introduction

Course Aims
This training course is designed to give delegates an understanding of some of the major features and functions within Microsoft Access. An introduction to database theory and practice is given, as well as hints and tips on good database design techniques.
Who Should Attend?
New, recent or intending users of Microsoft Access 2000 who have little or no existing database knowledge. Note : A working knowledge of using PCs in the Microsoft Windows environment is required.
Course Outline: Microsoft Access 2000 Introduction
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 · Year 2000 Best Practice
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 · Format and Input Mask Properties · Caption Property · Default Value Property · Required Property · Allow Zero Length Property · Indexed Property
Working with Data
· Sorting Data · Filtering Data · Using Advanced Filters
Forms
· Creating a Form · Filling in a Form
Simple Select Queries
· What is a Query? · Creating a Query · Modifying a Query · Restricting Records Returned by a Query · Simple Calculated Fields · Summary Queries
Simple Reports
· Reporting from Access · Printing from Datasheet View · AutoReports · Designing a Report Using Report Wizards · Label Reports · Modifying Reports