Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101


Home > Jan's CompLit 101 > Working with Databases > Basics > Quiz
Icon: Arrow - Previous pagePrevious    NextIcon: Arrow - Next page

Jan's Working with Databases

Basics: Quiz

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 or Short Text

 b. Memo or Long Text

 c. Number

 d. Decimal


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

 a. Create ribbon tab > Form button

 b. Create ribbon tab > Form Design

 c. Create ribbon tab > Form Wizard

 d. File > New > Form


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

 a. 50 characters

 b. 64 characters

 c. 255 characters

 d. 65,535 characters


5. You can change the size of a control on a form 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.  If Print Preview shows pages with a small amount of printing, you may be able to fix that by _____.

 a. reducing the margins

 b. scaling pages to fit the paper size

 c. changing the font for the form or report

 d. all of the above


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