Preview

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.
ribbon_design_access_1.png

  Window

  Ribbon

  Mask

  Text

 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

  FALSE

  TRUE

 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.

  TRUE

  FALSE

 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
forms_gettingaroundaccess1.png

  queries

  key

  form

  report

 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

  Queries

  Primary Keys

  Reports

  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 __________________.
reports_with_barcodes_1.png

  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.

  TRUE

  FALSE

 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.
Navigation_create_pane.png

  wizard

  datasheet

  default

  design

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

  search bar

  down facing arrow in a circle

  double arrow

  grey pane