Study Notes Prior Test - Access and PowerPoint

Know the Following:

I. GENERAL INFORMATION:
  1. Exercises and vocabulary provided in each of the chapters covered (Access, Powerpoint).
  2. How to get into and out of Word, Excel, Access, Internet Explorer, and PowerPoint.

II. ACCESS:
  1. The difference between Database, Table, Record, & Field, and Key field, and the hierarchy that relates them, as discussed in the book.
  2. How to switch between database objects when you have a database window open.
  3. How to view the Design of your Table.
  4. How to write up a record (table) description for a database on a paper form, indicating the field data type.
  5. How to create a new table, identifying only one field as the Key Field. Know how to view the datasheet in a table.
  6. How to enter new data into a table.
  7. How to edit the data in a table.
  8. How to find records (one at a time) with a particular field value in a table.
  9. How to use filter by selection to find several records satisfying a certain criteria.
  10. How to do a query to show certain records with selected fields on the screen.
  11. Know what a Dynaset is.
  12. How to use the Form Wizard to construct an input form, which you can use to input data.
  13. How to use the Report Wizard to construct a report, and to print the report out.
  14. For Forms and Reports, know what a "Control" is and how to move one around when designing a Form or Report.

III. POWERPOINT:
  1. The different Views available to you in PowerPoint (Normal, Slide Sorter, Notes, Slide Show). Know how to switch between views.
  2. How to create a new blank presentation, or one with a design template.
  3. How to open an existing presentation.
  4. How to insert a new slide into a presentation.
  5. How to delete a slide from a presentation.
  6. How to change the text of a presentation.
  7. How to change the background design template of a presentation.
  8. How to save a presentation on a diskette for use elsewhere.
  9. How to get help in PowerPoint.
  10. How to print one or all slides and views.