Access Basics:

Title: Jan's Illustrated Computer Literacy 101
Did you want: Working with Databases: Access 2007, 2010, 2013, 2016

For each question, click on Radio Button the radio button for your answer. You will be notified immediately whether your choice is correct or not. Double clicking may work better in some browsers.

Choose the BEST answer. 

1.  A field which has a unique value for each record can be used as a _____.

   a. target value

 b.  primary key

 c.  record source

 d.  foreign key

2. To use the values for calculations like totals and averages, the field's data type must be _____.

   a. Text

   b. Memo

   c. Number

   d. Decimal

3. Which of the following is not a way to create a new form?

 a. New Objects | AutoForm

 b. Database Window | Forms | Create a form in Design view

 c. Database Window | Forms | New button on Database Window toolbar

 d. File | New | Form

4.   The default size of a Text field in a table is _____.

   a. 1 inch

   b. 23 mm

   c. 50 characters

 d. 12.75 points

5. To change the size of a control on a form or report, you must be in _____ view.

 a. Datasheet

 b. Design

  c. Form

 d. Print Preview

6.  To create a list of values to choose from for a field, you would use  _____.

   a. AutoForm

   b. AutoReport

   c. Table Wizard

 d. Lookup Wizard

7.  To print only certain records which are not adjacent, you must use a _____.

  a. datasheet

  b. subdatasheet

   c. form

   d. report

8. The record source for a form or report can be a _____.

   a. table

   b. query

   c. filter

   d. a or b

   e. none of the above

9. The easiest way to hide records that do not match a certain value in a field, like having a value equal to $50, would be to use ____.

   a. Filter by Selection

   b. Filter by Form

   c. Advanced Filter

 d. the Sort button

10. In the Relationships window, the line between two tables is called a _____ line.

 a. join

 b. link

 c. connection

 d. none of the above