Practical Evaluation - Microsoft Access 2000

Using the 'Table Wizard' Using the 'Table Wizard' Table Categories and Table Samples Table - Adding/Deleting Fields Creating a Categories Table Renaming a Field Setting a 'Primary Key' Relating Tables Displaying Help on Working with a Table The 'AutoNumber' Data Type Entering Field Names Creating Relationships Between Tables Viewing the Relationship Between Tables Opening a Table in 'Design' View Using the 'Window' Menu Tiling Windows The 'Relationships' Window Creating a Relationship Between Tables The Functionality of Relationships The Spelling Corrector Starting the 'Spelling Corrector' The 'Spelling' Dialog Box Spelling Correction Options Using the Spelling Corrector Locating and Sorting Data Opening a Table Sorting Data in Ascending Order Applying a Filter Replacing Data in a Field Removing a Filter Locating Data in a Field		Querying Access Creating a Query Adding a Field to the Query Grid Defining Selection Criteria Running a Query Sorting Based on a Specific Field Saving a Query Showing/Hiding Fields Deleting a Field from the Grid Using Expressions in Queries Opening a Query Including a Second Table in a Query Adding a Field to the Grid Running a New Query Adding Criteria to a Query Using Wild Cards in a Query The Database Wizard Starting the 'Database Wizard' Database Templates The 'Database Wizard' Selecting a Presentation Style Selecting a Print Style Including a Picture in Reports Overview of an Application The 'Switchboard' Form Navigating on the 'Switchboard' Accessing the 'Contacts' Form Accessing the 'Calls' Form Accessing a Different 'Switchboard' Page The 'Switchboard Manager' Closing a Database
Practical Evaluation Microsoft Access 2000 - Module 2 MAC00ACCP2P

	This entirely interactive practical evaluation was designed to evaluate your knowledge of this application. You will be able to determine, through a series of practical exercises, if you understand the essential concepts required to master this application.

Basic Knowledge of Microsoft Access 2000		Knowledge evaluated

1 - 2 hours


Using any computer with Internet access, the learner enters his/her confidential ID and obtains a list of evaluations to which he/she is subscribed. Once a practical evaluation is selected, a list of subject titles is displayed. When a title is clicked, the evaluation begins. The learner can obtain the definition of certain terms through the glossary at any time.

• No installation required • IBM PC compatible, Pentium 233 MHz minimum, 330 MHz and more strongly recommended. • Video card that supports 800x600 or greater monitor resolution, and 16-bit color • 32 MB RAM minimum, 96 MB and more strongly recommended. • Microsoft compatible mouse • Operating system: Windows 95, 98, 2000, NT 4.0, or more recent		• Sound card, speakers or headphones • Netscape 4.7 or Internet Explorer 5.0 (or more recent) • Internet connection: Modem 56 K minimum, high-speed connection is strongly recommended or network connection 10 Mbit minimum. • * If you use Windows XP, Internet Explorer 6 will only work if Java 1.4.0 or higher has been installed. In fact, due to a conflict between Sun and Microsoft, Microsoft excluded the JVM from it's distribution of Windows XP for Internet Explorer. In order to download and install the JVM, please consult the following site : http://www.eduperformance.com/download/jre.exe

EDU-PERFORMANCE CANADA 7900 Taschereau Blvd. W. Suite A-207 Brossard, Quebec J4X 1C2 Canada Tel.: (450) 466-7275 Fax: (450) 466-4915 Toll free: 1-888-EDU-PERF 1-888-338-7373 E-mail: info@eduperformance.com Web site: www.eduperformance.com		EDU-PERFORMANCE EUROPE International number: 1-450-466-7275 E-mail: infoepe@eduperformance.com

© 2006 Edu-Performance Canada Inc. All rights reserved. Duplication prohibited. All products and product names mentioned in this publication are trademarks or registered trademarks of their respective holders.