Access

OBJECTIVES: After completing these classes, students will be able to

  • Create a database
  • Design an Access table
  • Create a table in a database
  • Define fields in a table
  • Understand the rules for naming tables and fields
  • Determine data types for fields
  • Modify field properties
  • Determine the field that will be the primary key
  • Add, delete or modify fields in a table
  • Change from design view to datasheet view (and vice versa)
  • Implement relationships between tables
  • Enter data into a record
  • Add additional records to a table
  • Change data in a table
  • Use a form to view a record
  • Save a table
  • Create a report
  • Understand the terms used when working with an Access database

For advanced students: use a query

Click here for a list of Data types you will need to know.

Access error messages can seem cryptic, so here is a list of common error messages and what they mean: Access Errors

There are two presentations on Access:
Access Tables
Access Queries and Reports

Online Microsoft Access tutorials:

http://office.microsoft.com/en-us/access-help/training-courses-for-access-2013-HA104030993.aspx

http://office.microsoft.com/en-us/training/overview-RZ006118141.aspx?section=1

http://fisher.osu.edu/~muhanna.1/837/MSAccess/

 

 

lmayer@elgin.edu