This Microsoft excel course is a self study workbook. It will be available for immediate download when payment has been received.
The user can study the areas described below in their own time.
It will be necessary to have access to a computer with ACCESS 2000 application installed (this is not supplied with this course).

Overview and objectives Who is the course intended for ? Access 2000 is the database from Microsoft designed specifically to manage and manipulate large amounts of data. 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. This course is meant for new, recent or intending users of Access 2000 who have little or no existing database knowledge. 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