Databases Intro:

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.  The smallest piece of data in a database is a _____.

   a. data bit

 b.  field

 c.  record

 d. none of the above

2. A datasheet displays the data in a _____.

   a. table with rows and columns

   b. form showing one record

   c. print-out

  d. none of the above

3. For a spreadsheet to work as a database, the following condition must be met:

 a. Uses less that 13,000 rows and 125 columns.

 b. No cell contains more than 35,000 characters.

 c. Each record is on exactly one row.

 d. all of the above

4.   Which of the following is not used as a delimiter in a text database?

   a. comma

   b. semi-colon

   c. space

 d. slash

5. To arrange the records in a database in alphabetical order based on LASTNAME , you would _____ the records.

 a. filter

 b. sort

  c. purge

 d. concatenate

6. A flat file database uses:

   a. text separated by delimiters

   b. a single table for all records

   c. multiple tables that are joined together

 d. a special type of spreadsheet

7.  The language most often used for queries in databases is _____?

  a. SQM

  b. QSL

  c. SQL

  d. none of the above

8.  A primary key is _____.

   a. a field that has a unique value for each record

   b. a code that allows the user to open the database

   c. a code that allows one database to connect to another

   d. none of the above

9. To easily see all of the parts of a record to edit the information, you would usually use a ____.

   a. datasheet

   b. table

   c. form

 d. report

10. A query can perform the following: 

 a. sort records

 b. filter records

 c. do calculations

 d. concatenate text from fields

 e. all of the above

 f. none of the above