Deck 2: Workshop 2: Tables, Keys, and Relationships

Question 1

Which of the following is NOT true when copying and pasting data from Excel into Access?

A)There cannot be missing columns or columns in different orders between the two files.
B)Copying and pasting requires that the columns be exactly the same in Excel and Access.
C)If you have any doubt about the data being compatible,use the Append feature to add the data to the table.
D)You cannot paste fields that are nonnumeric into numeric fields.

Answer 1

C

Question 2

Which of the following is NOT true when entering data manually?

A)If the data does not already exist in another form,you can type the data directly into Access.
B)Data can be directly entered into a table.
C)Data can be entered in a form.
D)When you open a table in Design view,you can type data directly into the table.

Answer 2

D

Question 3

The most appropriate data type to use for a Street Address field is the ________ data type,so a street address can contain numbers,letters,and special characters.

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

Answer 3

C

Question 4

________ define the kind of data that can be entered into a field,such as numbers,text,or dates.

A)Field names
B)Description
C)Data types
D)Field properties

Question 5

Which of the following is NOT true when creating fields and entering data in those fields?

A)When you have fields such as name or address that are composed of several smaller fields,you should split them into their component parts.
B)Consider whether you might want to report on smaller parts of the field to determine what fields to create.
C)Enter first and last names in alphabetical order in case two people have the same last name.
D)Splitting fields into smaller parts allows for more flexibility for reporting.

Question 6

A(n)________ key field is a field that uniquely identifies the record.

A)primary
B)identity
C)foreign
D)entity

Question 7

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.

Question 8

Which of the following is NOT true when determining the field size?

A)Whenever you use a Text data type,you should determine the minimum number of text characters that can exist in the field.
B)Limiting the field size will limit errors in the data.
C)If you need more than 255 characters,use a Long Text data type.
D)You should use the number size that best suits your needs.

Question 9

________ indicates the maximum length of a data field.

A)Input mask
B)Format
C)Field size
D)Validation Rule

Question 10

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.

Question 11

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.

Question 12

A ________ is a character such as a tab or comma that separates the fields.

A)cell address
B)delimiter
C)named range
D)range address

Question 13

Which of the following is NOT true about tables?

A)The upper pane of Design view has four columns: Field Name,Data Type,Length,and Description.
B)Datasheet view shows the values of the data within the table.
C)Design view shows the structure of the table with the fields and their definitions.
D)The Field Properties pane in Design view gives more information on how the data is stored,entered,and processed.

Question 14

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

Question 15

Access allows you to import a smaller portion of a worksheet,known as a ________,into a table.

A)cell address
B)delimiter
C)named range
D)range address

Question 16

________ give more information on how the data is stored,entered,and processed.

A)Field names
B)Description
C)Data types
D)Field properties

Question 17

Which of the following is NOT true regarding input masks?

A)An input mask provides the punctuation so you do not have to type it.
B)An input mask defines a consistent template.
C)Access has a wizard that creates automatic masks for Social Security numbers,zip codes,passwords,extensions,dates,and times.
D)Input masks do not affect how data is stored.

Question 18

Which of the following is NOT true when changing the data type in an existing field?

A)You can change the size of a field in Datasheet view and Design view.
B)If you decide that a field length needs to be longer,you can change the field without concern.
C)If you make a field length shorter and there were data that needed the longer length,you may truncate those values.
D)Access will always warn you that data may be lost if you change the length to a smaller size.

Question 19

Data stored as a(n)________ file cannot be imported into a table in Access.

A)Excel
B)Adobe PDF
C)Access
D)Notepad

Question 20

Which of the following is NOT true when dealing with international data?

A)Not all cultures around the world break names into first and last.
B)Design the database in such a way that other naming practices can fit into the database.
C)Designing database fields to accommodate all of the different cultures in the world is challenging.
D)Because businesses today are global,designing a database sensitive to all global cultures is imperative.

Question 21

Which of the following is NOT true regarding table formatting?

A)In a table design,you can define a Format field property that customizes how data is displayed and printed in tables,queries,reports,and forms.
B)The Format property tells Access how data is to be displayed.
C)You can define your own custom formats for Currency and Number fields.
D)Formatting does not affect the way the data is stored.

Question 22

Which of the following is NOT true regarding primary keys?

A)The primary key field is the field that identifies each record in a table.
B)When you define a primary key for a table,the field can be left blank until you have the opportunity to enter the data.
C)A common way of defining a primary key is to use a field specifically designed to identify the entity.
D)A numeric key is often assigned an AutoNumber data type that Access will fill as the data is entered.

Question 23

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

A)one-to-many
B)one-to-one
C)many-to-many
D)This doesn't apply to any relationship type.

Question 24

Which of the following is NOT a step in creating a many-to-many relationship?

A)Create a junction table.
B)The junction table is on the many side of both relationships.
C)Populate the junction table after the relationships have been created.
D)Only add the keys to the junction table.

Question 25

Which of the following is NOT a step in creating a one-to-many relationship?

A)Make sure the two tables have a field in common.
B)Form the relationship in the Relationships window.
C)Populate the foreign key by adding data to the foreign key in the many side table.
D)Use the foreign key from the one side,and add it as a primary key in the many side table.

Question 26

Which of the following is NOT true regarding redundancy?

A)Redundancy occurs when data is repeated several times in a database.
B)When you normalize a database,you eliminate redundancy.
C)Foreign keys are redundant,but no other data about the entity is repeated.
D)Normalization is the process of minimizing duplicate data.

Question 27

Which of the following is NOT true regarding normalization?

A)When you normalize a database,you will have larger tables,each representing a different thing.
B)If you know the primary key of an entity in a normalized database,each of the attributes will have just one value.
C)There will be no redundant data in the tables.
D)Normalization is the process of minimizing duplicate data.

Question 28

Which of the following is NOT true regarding keys?

A)Each table should have a primary key to uniquely identify each of the records in the table.
B)A foreign key is a value in a table that is the primary key of another table.
C)The primary and foreign keys form the common field between tables that allow you to form a relationship between the two tables.
D)To define a foreign key,select the foreign key field and then click the Key button on the Ribbon.

Question 29

Two fields needed to uniquely identify a record are called a ________ key.

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

Question 30

________ is an example of the General Date format.

A)11/9/2015 10:10:10 PM
B)Wednesday,November 9,2015
C)9-Nov-15 10:10:10 PM
D)Wednesday,November 9,2015 10:10 PM

Question 31

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

A)one-to-many
B)one-to-one
C)many-to-many
D)This doesn't apply to any relationship type.

Question 32

A university identifies a class by subject area and course number.The university has classes Math 101,Math 102,and MIS 101.It takes both subject and course number to identify a single course.The combination of the two fields is called a ________ key.

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

Question 33

The ________ format displays at least one digit after the decimal point.

A)Scientific
B)Fixed
C)Standard
D)Percent

Question 34

________ is the process of minimizing the duplication of information in a relational database through effective database design.

A)Formatting
B)Defining keys
C)Establishing relationships
D)Normalization

Question 35

A ________ relationship is a relationship between two tables where one record in the first table corresponds to many records in the second table.

A)one-to-many
B)one-to-one
C)many-to-many
D)This doesn't apply to any relationship type.

Question 36

4.5E + 13 is an example of the ________ format.

A)Scientific
B)Fixed
C)Standard
D)Percent

Question 37

Sometimes your data will have a unique identifier that is already a part of your data.When that is true,you can use the field as a ________ key.

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

Question 38

________ is an example of the Long Date format.

A)11/9/2015 10:10:10 PM
B)Wednesday,November 9,2015
C)9-Nov-15 10:10:10 PM
D)Wednesday,November 9,2015 10:10 PM

Question 39

Which of the following is NOT true regarding a one-to-many relationship?

A)A one-to-many relationship is a relationship between two tables where one record in the first table corresponds to many records in the second table.
B)One-to-many is called the cardinality of the relationship.
C)Access uses the tilde and infinity symbols to indicate a one-to-many relationship.
D)Cardinality indicates the number of instances of one entity that relates to one instance of another entity.

Question 40

Which of the following is NOT true regarding foreign keys?

A)The AutoNumber data type is typically used for foreign key fields.
B)A foreign key is a field in a table that stores a value that is the primary key in another table.
C)It is called foreign because it identifies a record in another table.
D)Foreign keys do not need to be unique in the table.

Question 41

The Long Text data type is used to store textual or character information.

Question 42

Design view shows the structure of the table with the fields and their definitions.

Question 43

A defined range is a group of cells that have been given a name that can then be used within a formula or function.

Question 44

A primary key field is a field that uniquely identifies the record.

Question 45

Datasheet view shows the values of the data within the table.

Question 46

The Navigation Pane in Design view gives more information on how the data is stored,entered,and processed.

Question 47

A primary key is a value in a table that is the foreign key of another table.

Question 48

A delimiter is a character such as a tab or comma that separates the fields.

Question 49

The field size indicates the maximum length of a data field.

Question 50

When you open a table in Design view,you can type data directly into the table.

Question 51

The lower pane of Design view has three columns: Field Name,Data Type,and Description.

Question 52

The Format property tells Access how data is to be displayed.

Question 53

The AutoNumber data type is used for keys.

Question 54

When you delete records from a table and realize you made a mistake,you can undo the deletion by clicking Undo in the Quick Access toolbar.

Question 55

The Byte field size is used for integers that range from -32,768 to +32,767.

Question 56

The Single field size is used for large numbers with up to seven significant digits.

Question 57

________ is a database concept that ensures that relationships between tables remain consistent.

A)A junction table
B)Normalization
C)Referential integrity
D)Redundancy

Question 58

An input mask defines a consistent template and provides the punctuation,so you do not have to type it.

Question 59

Input masks do not affect how data is stored.

Question 60

When defining keys,the combination of two fields is called a natural primary key.

Question 61

________ view shows the structure of the table with the fields and their definitions.

Question 62

A many-to-many relationship is a relationship between tables in which one record in one table has many matching records in a second table,and one record in the related table has many matching records in the first table.

Question 63

________ view shows the values of the data within the table.

Question 64

A(n)________ is an association between tables based on common fields.

Question 65

A(n)________ is a person,place,item,or event that you want to keep data about.

Question 66

Redundancy occurs when data is repeated several times in a database.

Question 67

Access allows you to import a smaller portion of a worksheet,known as a(n)________,into a table.

Question 68

Excel ________ are frequently imported as field names.

Question 69

________ define the kind of data that can be entered into a field,such as numbers,text,or dates.

Question 70

A(n)________ is a character such as a tab or comma that separates the fields.

Question 71

Normalization is the process of minimizing the duplication of information in a relational database through effective database design.

Question 72

Redundancy is a database concept that ensures that relationships between tables remain consistent.

Question 73

The ________ data type is used for keys.

Question 74

________ fields can store up to 1 gigabyte of characters,of which you can display 65,535 characters in a control on a form or report.

Question 75

If you select Cascade Update Related Fields when you define a relationship,then when the primary key of a record in the one side table changes,Access automatically changes the foreign keys in all related records.

Question 76

A(n)________ is information about the entity.

Question 77

A junction table breaks down the many-to-many relationship into two one-to-many relationships.

Question 78

________ fields have an upper limit of 255 characters.

Question 79

If your data has a unique identifier that is a natural part of your data,you can use the field as a natural primary key.

Question 80

A(n)________ means that when you open the item,you open it in its original application such as Excel.