Access Review for TestChapter 1-6

Chapter 1

  1. Know meanings of field, table, field value, record, database
  2. Know meanings of primary key, foreign key, relational database
  3. Be familiar with datasheet view, field selector, record selector
  4. Be able to tell which navigation button is being used
  5. Know what a query is and how to use the Query Wizard, including the use of the buttons
  6. Know what a form is
  7. Know what a report is and how to use the AutoReport: Columnar form.

Chapter 2

  1. Be familiar with the guidelines for designing a database
  2. Know what a composite key is
  3. Know what date redundancy and properties are
  4. Be familiar with rules and tips for naming fields, know what a data type is
  5. Be familiar with the various data types, know what a field size is
  6. Know how to define a field in a table
  7. Know properties concerning primary keys, meanings of entity integrity, null value, and how to select a field as a primary key
  8. Know what a table structure is
  9. Know how to enter records in a table
  10. Know how to delete a field from a table
  11. Know how to add a field between two existing fields in a database
  12. Know what the Format property does and how to use it to control the display of a field value
  13. Know how to copy records from another database
  14. Know what update means, how to delete, change and add records

Chapter 3

  1. Know what Query by example means
  2. Know how to create and run a query
  3. Know what a join is
  4. Know what a one-to-many relationship, primary table, and related table are
  5. Know what we mean by referential integrity, cascade updates, and cascade deletes
  6. Know how to define a relationship between two tables
  7. Know how to create a query based on two tables
  8. Know what is meant by sorting, sort key, and sort orders--descending and ascending
  9. Be able to give examples of unique vs. non-unique sort keys, difference between primary and secondary sort key
  10. Know how to set up a sort in a query datasheet
  11. Know what a filter is and how to use a Filter by Selection
  12. Know how to state criteria in a query and what is meant by condition, comparison operator, and how to create a query that uses the criteria row
  13. Given an example of a condition that has been set up for a query, be able to tell what kind of records would be selected, or vice versa.
  14. Know how to change the datasheet appearance
  15. Know how to set up the criteria for AND and OR in a query
  16. Know what a calculated field is and how to use the expression builder to build one
  17. Know what an aggregate function is and how to use one
  18. Know what a group operator is and how to use one in conjunction with the aggregate function

Chapter 4

  1. Know what a Form Wizard is and how to use one
  2. Know what AutoFormat is for a form and to change it
  3. Know how to navigate a form
  4. Know what the Find command does and how to use it with records
  5. Given one of the wildcard characters in a word, be able to determine if certain information would be found
  6. Be able to print selected records
  7. Know how to use a form to change data in a table
  8. Know how to create a form consisting of a main form and a subform and navigate between them.
  9. Know how to use the Report Wizard to create a report
  10. Know how to insert a picture in a report and make adjustments
  11. Know what it means to compact a database and how to do it

Chapter 5

  1. Know what a Lookup wizard, how to create one, and how to use it to add information for a new record using it
  2. Know what a pattern match is for a query and how to use one
  3. Know what a list-of-values match is for a query and how to use one
  4. Know what a non-matching value is for a query and how to use one
  5. Know how to use AND and OR operators in a query
  6. Know what a parameter query is and how to create one
  7. Know how to create a custom form
  8. Know the meanings of control, bound control, unbound control, and calculated control
  9. Know how to add fields to a form
  10. Know how to select and move controls on a form
  11. Know how to change a label's caption
  12. Know how to resize a control
  13. Know how to add a form header and footer
  14. Know how to add a label to a form
  15. Know how to apply formatting changes to a label
  16. Know how to add a picture to a form
  17. Know how to change the background color of a form
  18. Know what a multi-page form is and how to create one using tab controls
  19. Know how to align objects on a form
  20. Know what a Control Wizard is and how to use it
  21. Know how to add subforms to a report
  22. Know what a filter is and how to use the Filter by Form option
  23. Know how to save a filter as a query
  24. Know how to apply a filter that was saved as a query

Chapter 6

  1. Know what a report is, what the sections are and what each section does
  2. Know how to modify a saved query
  3. Know how to create a report in design view
  4. Know how to add fields to a report
  5. Know how to move and resize controls
  6. Know how to change a caption property
  7. Know how to align controls
  8. Know how to add a date to a report
  9. Know how to add a page number to a report
  10. Know how to add a report header section and a title to a report
  11. Know how to add a line to a report
  12. Know how to sort and group data in a report
  13. Know how to calculate group totals and overall totals
  14. Know how to hide duplicates in a report
  15. Be familiar with the meanings of the following terms: object, source, destination, importing, embedding, linking
  16. Know how to embed a chart in a report
  17. Know how to insert a linked object in a report
  18. Know how to export an access table or query to Excel and then use Excel to do calculations