Access 2000 Introduction

This course is designed to give you an understanding of some of the major features and functions within Access. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given.

Target audience

New, recent or intending users of Access 2000 who have little or no existing database knowledge. A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required, gained either by previous experience or by attendance on a "PC Fundamentals" course.

Course content

Introduction to Access 2000 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 . 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 and deleting records

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 What is a form? . Using AutoForm to design forms . Using Wizards to design forms . Entering data using 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

About Courseware Company:: Instructor-led training courseware :: Self-study solutions :: Buy online today