Access Test

Question 1

(T/F)

1. Tables are sometimes called entities

Answer 1

True

Question 2

1. What is data?

Answer 2

Facts and statistics only

Question 3

(T/F) Tables are related sets of information

Answer 3

True

Question 4

(T/F) The LONG text field can be used as often as you like.

Answer 4

False

Question 5

2. What does DBMS stand for?

Answer 5

Database Management System

Question 6

(T/F) 3. Each foreign key is a primary key in another tab

Answer 6

True

Question 7

(T/F)

3. In a business narrative, tables can be identified as adjectives

Answer 7

False

Question 8

. What is the maximum number of characters for the SHORT text data type.

Answer 8

255

Question 9

. Entities are made up of rows and columns. The columns are called

Answer 9

fields

Question 10

4. Excel is an example of

Answer 10

Flat File Database

Question 11

(T/F) 4. There are 5 types of relationships.

Answer 11

False

Question 12

A foreign key is a column in a table used to reference a primary key in another table.

Answer 12

True

Question 13

5. A primary key is typically set to what type of data?

Answer 13

Autonumber

Question 14

. What is the most common database model?

Answer 14

Relational Database Model

Question 15

(T/F) . A 1:1 relationship generally occurs when a table is a subset of another table

Answer 15

True

Question 16

(T/F) A foreign key can be data type SHORT text when the primary key is a number.

Answer 16

False

Question 17

(T/F). A 1:M relationship exists when a record can relate to 1 or more records in a second table

Answer 17

True

Question 18

(T/F) The many in a 1:M relationship can relate to only one record in the primary table.

Answer 18

True

Question 19

When designing a database, the first prinicple is to reduce

Answer 19

Redundant or duplicate information

Question 20

A primary key field holds data that

Answer 20

uniquely identifies each record in a table

Question 21

Whata data type should you use for a field that will store telephone numbers

Answer 21

SHORT text

Question 22

Each field in a table must contain:

Answer 22

a unique name

Question 23

If you let MS Access create a primary key for you, what field name does it use?

Answer 23

ID

Question 24

In design view how can you tell that a field is the primary key?

Answer 24

The key symbol appears on the row selector button.

Question 25

Which of the following is not a valid data type?

Answer 25

Text & Numbers

Question 26

(T/F) After you save your table structure, you cannot edit or change it.

Answer 26

False

Question 27

(T/F) You can enter only numbers in a numbers field

Answer 27

True

Question 28

(T/F) In Access Query design mode, to match a word or phrase simply type the text you want to match in the criteria area

Answer 28

True

Question 29

Yor* will find

Answer 29

York

Question 30

Working with dates requires what symbol surrounding the date?

Answer 30

#

Question 31

(T/F) Changing a field name has no effect on the data stored.

Answer 31

True

Question 32

(T/F) To add a field in table design view, type the field name in the field name box and press enter.

Answer 32

True

Question 33

Which of the following features is found in a relational database management system but not in a file management system?a. The ability to store records b. the ability to define relationships between tables c. the ability to retrieve records d. all answers are correct

Answer 33

all answers are correct