Microsoft Access 2000 Training Course

Training Course Outline

• Overview of Access 2000
  • Introduction to database concepts and terminology
  • An introduction to Access 2000
  • Database planning and design
• Creating tables
  • Examining a table
  • Creating a table with the Table Wizard
  • Creating a table in Design View
  • Types of primary keys
• Working with tables
  • Adding records
  • Modifying the table design
  • Finding and editing records
  • Deleting, adding, and copying records and values
  • Filtering and sorting records
• Using select queries
  • Selecting fields and sorting records
  • Refining the results of a query
  • Using queries to perform calculations
  • Joining tables in a query
• Creating and using forms
  • Creating a form
  • Modifying the form design
  • Using a form to locate and organize information
  • Multiple-table forms
• Creating and using reports
  • Creating a report
  • Creating a report that contains totals
• Creating and maintaining a database
  • Creating a database
  • Managing a database and its objects
  • Database maintenance

To see more details as to our East Anglian Training Venues click one of the links below:

Cambridge | Milton Keynes | Norwich | Peterborough | Luton | Ipswich