Go to the FGCU Homepage navigation bar
    
Technology Skills Orientation
Access 2000 Tutorial
A-Z FGCU Index FGCU Calendar of Events Campus Tour Library Search FGCU Web FGCU Webmail Contact FGCU
 
Access 2000 Tutorial

Begin the Access tutorial »


Getting Started

  • A few terms
  • Getting started
  • Blank Access database
  • Access database wizards, pages, and projects
  • Open an existing database
  • Converting to Access 2000

Screen Layouts

  • Database window
  • Design view
  • Datasheet view

Creating Tables

  • Introduction to tables
  • Create a table in design view
  • Field properties
  • Primary key
  • Indexes
  • Field validation rules

Datasheet Records

  • Adding records
  • Editing records
  • Deleting records
  • Adding and deleting columns
  • Resizing rows and columns
  • Freezing columns
  • Hiding columns
  • Finding data in a table
  • Replace
  • Check spelling and AutoCorrect
  • Print a datasheet

Table Relationships

  • Declaring table relationships

Sorting and Filtering

  • Sorting
  • Filter by selection
  • Filter by form
  • Saving a filter
  • Remove a filter
       

Queries

  • Introduction to queries
  • Create a query in design view
  • Query wizard
  • Find duplicates query
  • Delete a query

Forms

  • Create a form using the wizard
  • Create a form in Design View
  • Adding records using a form
  • Editing forms

Form Controls

  • List and combo boxes
  • Check boxes and option buttons
  • Command buttons

Subforms

  • What is a subform?
  • Create a form and subform at once
  • Subform wizard
  • Drag-and-drop method

More Forms

  • Multiple-page forms using tabs
  • Conditional formatting
  • Password text fields
  • Change control type
  • Multiple primary keys

Reports

  • Using the wizard
  • Create in Design View
  • Printing reports

Importing, Exporting, Linking

  • Importing
  • Exporting
  • Linking

Keyboard Shortcuts


Office 2000 Tutorials · Word · Excel · Power Point · Access · FrontPage

FGCU does not provide personal support for Office 2000 programs to outside parties.

 
 

© FGCU 2009. This is an official FGCU web page.
Florida Gulf Coast University is an equal opportunity/affirmative action institution.

Contact the Webmaster | FGCU Directory