Deck 12: Tables,Keys,and Relationships

Question 1

The ________ in a table dictates what data can be stored in a field.

A) data type
B) description
C) field name
D) field properties

Answer 1

A

Question 2

Tables have ________ view(s).

A) two
B) three
C) four
D) one

Answer 2

A

Question 3

The ________ data type generates the value by automatically incrementing the value for each new record to produce unique keys.

A) Short Text
B) Calculated
C) Number
D) AutoNumber

Answer 3

D

Question 4

Which of the following is NOT a design objective when creating tables?

A) Minimize the file size
B) Ensure that there is a way to import data
C) Minimize any errors
D) Encourage data consistency

Question 5

Which of the following is NOT true about a table's Design view?

A) The upper pane contains three columns.
B) Data types include items such as Default Value, Caption, and Format.
C) The field Properties pane gives more information on how the data is stored, entered, and processed.
D) Unless a caption is defined, the field name is the column label in Datasheet view.

Question 6

In a database,a(n)________ is a field that uniquely identifies a record.

A) input mask
B) Yes/No field
C) primary key
D) named range

Question 7

In Datasheet view,the ________ icon that appears in the record selector indicates that the record is being modified.

A) arrow
B) pointer
C) eraser
D) pencil

Question 8

An appropriate example of the type of data that could be stored in a Short Text data type field is ________.

A) name and addresses
B) customer ID
C) salary
D) quantity

Question 9

Data can be entered into a database using one of two methods: entering the data directly into the table or entering it in ________.

A) a query
B) a report
C) a form
D) the relationship window

Question 10

All of the following fields would have a Short Text data type EXCEPT:

A) email address.
B) zip code.
C) phone number.
D) student ID number.

Question 11

A phone number is an example of a(n)________.

A) attribute
B) entity
C) relationship
D) property

Question 12

An appropriate example of the type of data that could be stored in an Attachment data type field is ________.

A) start time
B) company website
C) employee photo
D) gross pay

Question 13

Which of the following is NOT true about undoing in Access?

A) If you have made changes to several fields in a single record, you can click Undo to undo each of them.
B) Just like in other Office applications, there is a great deal of undo/redo functionality in Access.
C) Pressing Esc gets you out of an error.
D) Until the design of an object is saved, you can click Undo to undo design changes.

Question 14

Which of the following is NOT true regarding compound fields?

A) Break product information into StyleNumber, Color, and Size fields.
B) Break addresses into fields such as StreetAddress, City, State, and ZipCode.
C) Break names into FirstName and LastName fields.
D) Break dates into Month, Day, and Year fields.

Question 15

A(n)________ is a link between tables.

A) field
B) property
C) relationship
D) line

Question 16

A character,such as a colon or comma,that separates fields is a ________.

A) slicer
B) delimiter
C) definition
D) named range

Question 17

Database design can be looked at as a ________ process.

A) two-step
B) three-step
C) four-step
D) five-step

Question 18

The ________ data type stores a maximum of 255 characters in the field.

A) Short Text
B) Long Text
C) OLE Object
D) Lookup Wizard

Question 19

In a customer table,a(n)________ field would serve as a good primary key.

A) phone number
B) customer ID
C) address
D) date of birth

Question 20

Access can import smaller sections of a worksheet known as a ________.

A) named range
B) slicer
C) definition
D) delimiter

Question 21

A relationship between tables in which a record in one table has many matching records in the second table is a ________.

A) 1:N
B) M:N
C) 1:1
D) There would not be a relationship between the two tables.

Question 22

By establishing a relationship between two tables that is based on a common field in the two tables,a ________ is being created.

A) join
B) link
C) location
D) path

Question 23

When a relationship is defined to enforce referential integrity and Cascade ________ Related Fields,Access will automatically change the data through all related tables when a revision is made to the data in the table that contains the primary key.

A) Update
B) Change
C) Delete
D) Remove

Question 24

If one customer can purchase many items,one-to-many is called the ________ of the relationship.

A) cardinality
B) redundancy
C) joining
D) integrity

Question 25

The ________ Date Format field property formats the date as 9-Nov-15.

A) Short
B) General
C) Medium
D) Long

Question 26

All information about a database's table joins are stored ________.

A) on the Create tab
B) in the Navigation pane
C) in the Relationships window
D) in Backstage view

Question 27

The ________ key in one table acts as a primary key of another table.

A) numeric
B) natural
C) composite
D) foreign

Question 28

The ________ property in the Design view of a table defines how Access should display the data.

A) Default Value
B) Input Mask
C) Data Type
D) Format

Question 29

In a database,a table or entity represents ________.

A) adverbs
B) adjectives
C) verbs
D) nouns

Question 30

The ________ Time Format field property formats the time as 22:10.

A) Short
B) Military
C) Medium
D) Long

Question 31

An input mask sets a specific ________ and provides the punctuation,so it does not have to be typed manually.

A) template
B) field name
C) starting file
D) relationship

Question 32

When a database is ________,redundancy is minimized.

A) shared
B) normalized
C) joined
D) delimited

Question 33

When a relationship is defined to enforce referential integrity and Cascade ________ Related Fields,Access will automatically change the data through all related tables when data is removed from the table that contains the primary key.

A) Update
B) Change
C) Delete
D) Remove

Question 34

Unless a common field is being joined,such as a foreign key to the same foreign key in
A different table,Access cannot form a ________ relationship with a single relationship.

A) 1:N
B) M:N
C) 1:1
D) M:1

Question 35

A relationship between tables in which a record in one table has only one matching record in the second table is a ________.

A) 1:N
B) M:N
C) 1:1
D) There would not be a relationship between the two tables.

Question 36

The field ________ defines the maximum length of data within a field.

A) row height
B) size
C) piece
D) section

Question 37

Being able to format a phone number in a field as [phone] without manually entering the symbols occurs when an ________ has been applied to the field.

A) wizard
B) link
C) input mask
D) relationship

Question 38

When two fields are needed to uniquely identify a record,a ________ key is used.

A) numeric
B) natural
C) composite
D) foreign

Question 39

If one student in tblStudents can register for many classes in tblClasses,the relationship would be noted as a ________ relationship.

A) many-to-many
B) one-to-one
C) one-to-many
D) There would not be a relationship between the two tables.

Question 40

Which of the following is NOT true about referential integrity?

A) The matching fields on both sides of the relationship have the same data types.
B) You cannot enter a value in the foreign key field on the many side table that is not a primary key on the one side table.
C) The primary key field values on the one side of the relationship must be unique.
D) All foreign key fields and primary key fields must have values entered and cannot remain null.

Question 41

An entity stores data about people,places,or things.

Question 42

In Excel,a defined group is a group of cells that have been renamed.

Question 43

To copy and paste from Excel into Access,ensure that the columns are exactly the same in the two applications.

Question 44

The upper part of a table's Design view has four columns.

Question 45

A delimiter is a character that separates fields within a text or Word file.

Question 46

When importing data from an Excel worksheet into a new Access table,the headings are often imported as the field names.

Question 47

The Description property in a table's Design view is required.

Question 48

Database design is considered to be a three-step process.

Question 49

The Date/Time data type requires you to choose either date or time.

Question 50

If you accidentally delete the wrong record,you can click Undo to restore it.

Question 51

The Undo button will permit a user to undo up to 100 changes.

Question 52

Tables have two views: Datasheet view and Design view

Question 53

The size of a field can be changed in a table's Design view.

Question 54

A person's phone number would serve as a good primary key.

Question 55

When manually entering data into an Access database,there is one method which is to enter it directly into the table.

Question 56

Relationships between tables must be based on common fields.

Question 57

An entity is a characteristic of an attribute.

Question 58

The OLE Object data type allows for cross-application editing.

Question 59

If you cause an error in Access,you can press Esc to get out of it.

Question 60

The power of Access can be seen when relationships are created between tables.

Question 61

When a database is normalized,cardinality is minimized.

Question 62

A(n)________ is an association between tables.

Question 63

A field that uniquely identifies a record is called a primary ________.

Question 64

The AutoNumber data type is best used for the primary key.

Question 65

The process of normalization causes multiple smaller tables to be created.

Question 66

A quantity field would be best formatted as the ________ data type.

Question 67

When you have a one-to-one relationship,you could combine the two tables into a single table.

Question 68

To help Access determine what can be entered and stored in a field,select an appropriate ________ in Design view.

Question 69

In the United States,the ________ data type displays the data with a dollar sign and two decimal places.

Question 70

Deleting individual fields from a table is ________ and cannot be undone.

Question 71

In text files,tables are implied by the separation of columns as denoted by a(n)________.

Question 72

In Excel,a group of cells that has been renamed is known as a named ________.

Question 73

Participants' first and last names will be stored in the Putt for Paws tournament.This is an example of a(n)________.

Question 74

The terms null and zero are synonymous.

Question 75

The ________ data type displays checked box.

Question 76

A phone number field would be best formatted as the ________ data type.

Question 77

The ________ data type lists either values retrieved from a table or query or a set of values that you entered when the field was created.

Question 78

The maximum length of a data field is indicated by its ________.

Question 79

To ensure that information is entered,sorted,and displayed consistently,an input mask can be defined in a field.

Question 80

Participants in the Putt for Paws tournament will be stored in the database.This is an example of a(n)________.