CPSC 1105 - Technological Solutions: Access Exam Study Guide
  1. EXAM - Tuesday, April 18, 2006 @ 1:30 p.m. (be on time)
  2. YOU MUST HAVE A SAM ACCOUNT
  3. Bring your photo id
  4. There are training sessions for the exam available through SAM
Access Tasks (26 questions)
  1. Launch Access
  2. Create a new Access database
  3. Use Microsoft Help Assistance to find out information
  4. Create a new database based on a template
  5. Edit a table
  6. Remove a record from a table
  7. Open a query
  8. Open a Form
  9. use the Navigation bar
  10. format the datasheet
  11. Using the Table Wizard to create a table
  12. Create a new table in Design View
  13. Add new fields to a table
  14. Set the primary key
  15. Change the view
  16. Change the data type of a field
  17. Use the Query Wizard to create a query
  18. Create a query in design view
  19. Use the Form Wizard to create a form
  20. Create a Summary report using the Report Wizard
  21. Print a Report