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

  Mask

  Window

  Text

  Ribbon

 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:

  tables, queries, forms, and reports.

  tables, keys, records and cells

  files, tables, records and fields

  fields, cells, records and data types

 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

  report

  form

 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

  Designer views

  Primary Keys

  Reports

 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

  binary in format (i.e. unreadable)

  appear in ASCII

  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

  default

  design

  datasheet

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

  double arrow

  down facing arrow in a circle

  search bar

  grey pane


Report an error