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

  Ribbon

  Text

  Window

  Mask

 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, keys, records and cells

  files, tables, records and fields

  fields, cells, records and data types

  tables, queries, forms, and reports.

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

  FALSE

  TRUE

 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

  form

  key

  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

  Primary Keys

  Queries

  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

  binary in format (i.e. unreadable)

  visually appealing

  appear in ASCII

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

 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

  design

  default

  datasheet

  wizard

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

  double arrow

  grey pane

  search bar

  down facing arrow in a circle


Report an error