02 - Getting around Microsoft Access

 1. Access uses a tabbed ______ system instead of traditional menus. The _______ contains multiple tabs, each with several groups of commands
Note that certain groups also have a small arrow in the bottom-right corner - you can click this for additional options.





 2. The Navigation pane is a list containing every object in your database
For easier viewing, the objects are organized 
into groups by type. You can open, rename,
 and delete objects using the Navigation pane



 3. Databases in Access are composed of four objects:

  fields, cells, records and data types

  files, tables, records and fields

  tables, queries, forms, and reports.

  tables, keys, records and cells

 4. In Access, all data is stored in tables, which puts tables at the heart of any database.



 5. When you enter information into a _____ (as shown) in Access, the data goes directly into one or more related tables
A _______ is used for entering, modifying, and viewing records.

You have probably filled in one of these on many occasions, e.g. 
registering for school or applying for a part-time job.

The reason that a _____ is used (instead of just having a table)
is that it is an easy way to guide people toward entering data correctly
and provides a more user-friendly interface





 6. ________are a way of searching for and compiling data from one or more tables. Running _________is like asking a detailed question of your database


  Primary Keys


  Designer views

 7. Reports are useful because they allow you to present components of your database in an easy-to-read format. You can customise a report's appearance to make it __________________.

  complex so that a user or manager would not know what to do next

  appear in ASCII

  binary in format (i.e. unreadable)

  visually appealing

 8. If you're having trouble finding command you want, the Tell me feature can help. It works just like a regular search bar: Type what you're looking for, and a list of options will appear.



 9. Clicking on 'Create' will allow you to create a table, form, query or report. To create a quick form or report you could also use the ________ option.





 10. To minimize the Navigation pane, click the _________ in the upper-right corner

  search bar

  down facing arrow in a circle

  double arrow

  grey pane