TEST BANK FOR YOUR OFFICE MICROSOFT OFFICE 2013 1ST EDITION VOLUME 1 BY AMY KINSER

Your Office: Microsoft Office 2013, Volume 1 (Kinser et al.)

Access Module 1 Workshop 2

1) Which of the following is NOT one of the three steps in database design?

A) Identify your entities.

B) Identify the attributes.

C) Specify the relationships between the tables.

D) Determine the queries you want to create.

Answer:  D

Diff: 1      Page Ref: 626

Objective:  Understand Database Design

Text:  Your Office: Microsoft Office 2013 Volume 1

2) Which of the following is NOT true regarding database design?

A) An entity is a person, place, item, or event that you want to keep data about.

B) A field is an instance of an entity.

C) An attribute is information about the entity.

D) A relationship is an association between tables based on common fields.

Answer:  B

Diff: 1      Page Ref: 626

Objective:  Understand Database Design

Text:  Your Office: Microsoft Office 2013 Volume 1

3) Which of the following is true when breaking compound fields into smaller parts?

A) Break names into first name and last name fields.

B) Leave city, state, and zip code together in one field.

C) For faster sorting, include the street address in the same field as the city, state, and zip code field.

D) Always separate the area code from the phone number field.

Answer:  A

Diff: 2      Page Ref: 627

Objective:  Understand Database Design

Text:  Your Office: Microsoft Office 2013 Volume 1

4) Illustrating some of the basic principles of database design, notice that a person's name is split into two fields and the address is ________.

A) left as one field

B) split into two fields

C) split into three fields

D) split into four fields

Answer:  D

Diff: 1      Page Ref: 627

Objective:  Understand Database Design

Text:  Your Office: Microsoft Office 2013 Volume 1