Search                            Français                            







Corporate Solutions






Career Area

Contact Us



Access 2000


Microsoft Access 2000 Exam Objectives

Skill Sets

Exam Objectives

Planning and Designing Databases

  • Determine appropriate data inputs for your database
  • Determine appropriate data outputs for your database
  • Create table structure
  • Establish table relationships

Working with Access

  • Use the Office Assistant
  • Select an object using the Objects Bar
  • Print database objects (tables, forms, reports, queries)
  • Navigate through records in a table, query, or form
  • Create a database (using a Wizard or in Design View)

Building and modifying tables

  • Create tables by using the Table Wizard
  • Set primary keys
  • Modify field properties
  • Use multiple data types
  • Modify tables using Design View
  • Use the Lookup Wizard
  • Use the input mask wizard

Building and modifying forms

  • Create a form with the Form Wizard
  • Use the Control Toolbox to add controls
  • Modify Format Properties (font, style, font size, color, caption, etc.) of controls
  • Use form sections (headers, footers, detail)
  • Use a Calculated Control on a form

Viewing and organizing information

  • Use the Office Clipboard
  • Switch between object Views
  • Enter records using a datasheet
  • Enter records using a form
  • Delete records from a table
  • Find a record
  • Sort records
  • Apply and remove filters (filter by form and filter by selection)
  • Specify criteria in a query
  • Display related records in a subdatasheet
  • Create a calculated field
  • Create and modify a multi-table select query

Defining relationships

  • Establish relationships
  • Enforce referential integrity

Producing reports

  • Create a report with the Report Wizard
  • Preview and print a report
  • Move and resize a control
  • Modify format properties (font, style, font size, color, caption, etc.)
  • Use the Control Toolbox to add controls
  • Use report sections (headers, footers, detail)
  • Use a Calculated Control in a report

Integrating with other applications

  • Import data to a new table
  • Save a table, query, form as a Web page
  • Publish a presentation to the Web
  • Add Hyperlinks

Using Access Tools

  • Print Database Relationships
  • Backup and Restore a database
  • Compact and Repair a database


Word2000 ] Excel2000 ] Word2000 Expert ] Excel2000 Expert ] PowerPoint2000 ] [ Access2000 ] Outlook2000 ] Project2000 ] Project2000 Expert ]


Home ] Search ] Request ] Feedback ] Site Map ] Contact us ]


Send mail to with questions or comments about this web site.
Copyright © 1996 Office Technologies Inc.
Last modified: May 12, 2006