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/
|