CIS105 

Survey of Computer Information SystemsLesson 10 Quiz

 

This assessment is worth 25 points.

Please make sure you have answered the questions completely prior to submitting. Once submitted, you will not be able to return to this section.

 

Question

1 of 25

If you wanted the user to pick from a particular list, what would you choose from the data type drop- down list for that field?

Long Text

Short Text

Lookup Wizard

List

Question

2 of 25

What is SharePoint?

An application that lets others in your office share your computer's database

A PowerPoint alternative

An Access alternative

A host server

Question

3 of 25

How many records do most forms display?

zero (Forms don't display records)

one

two

All the records at the same time

Question

4 of 25

If you see plus signs (+) next to records in Datasheet view, you know two or more tables are related.

True

False

Question

5 of 25

The primary key can only be a single field.

True

False

Question

6 of 25

You should normally check the Enforce Referential Integrity box.

True

False

Question

7 of 25

In Datasheet view, what does a pencil symbol to the left of a record indicate?

Data in that record has recently been modified and saved.

Data in that record is about to be deleted.

Data in that record has not been saved yet.

Data in that record has a data integrity violation and needs to be changed.

Question

8 of 25

Which of the following is not one of the three methods for creating a database?

database from a template

blank desktop database

custom Web app

blank cloud database

Question

9 of 25

How many characters can you store in a field with a Long Text data type?

12,256

Unlimited

1,000

64,000

Question

10 of 25

A good practice is to make backups of your databases on different storage devices.

True

False

Question

11 of 25

A database designer must be concerned only with what fields might be needed rather than file size.

True

False

Question

12 of 25

What field property helps to ensure correct data is entered?

Format

Validation rule

Required

Validation text

Question

13 of 25

What field property makes up for the limitation of the field naming rules or common practices?

Input Mask

Format

Caption

Validation Rule

Question

14 of 25

When you close a table after using a selection filter and then reopen it, what happens to the filter?

The filter is still operating.

The filter is not saved.

The filter is removed permanently.

The filter is removed, but Toggle Filter will bring it back.

Question

15 of 25

Although you can link to external data, it is not recommended.

True

False

Question

16 of 25

Where can you not use calculated fields?

In a form

In a table

In a module

In a report

Question

17 of 25

Which of the following is not a property of a number data type?

Caption

Allow zero length

Validation

Required

Question

18 of 25

What is the most common relationship type?

Many-to-many

None-to-none (finds records with no matching primary and foreign keys)

One-to-many

One-to-one

Question

19 of 25

Access does not require a primary key for every table.

True

False

Question

20 of 25

Searching a Web site to help you find just the right product (typically) involves database technology.

True

False

Question

21 of 25

To limit the number of records displayed when a query is run you should add ________.

fewer tables

sorting

criteria

fewer fields

Question

22 of 25

A primary key can be a combination of several fields.

True

False

Question

23 of 25

In datasheet view what do the rows indicate?

Information

Fields

Records

Tables

Question

24 of 25

What database object organizes your data by rows and columns?

Form

Report

Table

Macro

Question

25 of 25

Which of the following is not critical when you first design a database?

What tables you will need

What type of data you will store in each field

What field names you will use

What fields you will need