Your Office Microsoft 2010 Vol 1, 2e (Kinser)
Microsoft Access 2010, Workshop 2: Gathering Data into a Database
1) In a database, data about a person, place, item or event is called a(n) ______.
A) row
B) entity
C) field
D) attribute
Answer: B
Diff: 1
Ref: Database Design
2) Information about an entity is called a(n) ______.
A) field
B) attribute
C) table
D) row
Answer: B
Diff: 1
Ref: Database Design
3) An association between tables based on common fields is called a(n) ______.
A) attribute
B) relationship
C) liaison
D) association
Answer: B
Diff: 1
Ref: Database Design
4) Fields such as names or addresses should be split into their ______parts.
A) different
B) component
C) individual
D) separate
Answer: B
Diff: 1
Ref: Database Design
5) The three columns in the upper pane of a Table Design view are ______.
A) Field Name, Data Type, and Description
B) Field Name, Data Type, and Information
C) Data Type, Description, and Information
D) Field Name, Description, and Information
Answer: A
Diff: 1
Ref: Database Design
6) The characteristic that defines the kind of data that can be entered into a field, such as numbers, text, or dates are ______.
A) data types
B) field types
C) content types
D) information types
Answer: A
Diff: 1
Ref: Database Design
7) The two most common data types are ______.
A) Number and Memo
B) Number and Text
C) Data and Text
D) Memo and Date
Answer: B
Diff: 1
Ref: Database Design
8) By default, Access orders tables by the ______.
A) secondary key
B) foreign key
C) primary key
D) composite key
Answer: C
Diff: 1
Ref: Importing Data from Other Sources
9) A set of cells that can be used within a formula or function are a(n) ______.
A) export range
B) import range
C) named range
D) called range
Answer: C
Diff: 1
Ref: Importing Data from Other Sources
10) The comma or tab are typical ______characters.
A) normal
B) spacing
C) delimiter
D) special
Answer: C
Diff: 1
Ref: Importing Data from Other Sources
11) The first field in a table is the ______, which must be a unique entry.
A) export key
B) primary key
C) import key
D) composite key
Answer: B
Diff: 1
Ref: Importing Data from Other Sources
12) When you import an existing table into Access, Access creates a table using the ______headings for field names.
A) column
B) row
C) table
D) worksheet
Answer: A
Diff: 2
Ref: Importing Data from Other Sources
13) The two methods of entering data directly into Access are typing the data into the table or ______.
A) importing data from a table
B) using a query to add data
C) copy and paste data into a datasheet
D) entering the data in a form
Answer: D
Diff: 2
Ref: Manual Data Entry
14) To type data into the table without using a form, you use the ______view.
A) Datasheet
B) Spreadsheet
C) Design
D) Worksheet
Answer: A
Diff: 1
Ref: Manual Data Entry
15) To stop editing a record and revert it back to what it was before editing, you press ______.
A) CTRL+ESC
B) ESC
C) Shift+ESC
D) TAB
Answer: B
Diff: 1
Ref: Manual Data Entry
16) If the Undo button is dimmed, you CANNOT ______the change you made.
A) Redo
B) Undo
C) Enter
D) Delete
Answer: B
Diff: 1
Ref: Manual Data Entry
17) When working with tables, if you ______a record or records, you CANNOT Undo the change.
A) enter
B) move
C) delete
D) add
Answer: C
Diff: 1
Ref: Manual Data Entry
18) Record changes are saved automatically, but ______changes are not saved until you save.
A) form
B) field
C) design
D) multiple
Answer: C
Diff: 1
Ref: Manual Data Entry
19) When you delete an individual field from a table, the deletion is ______.
A) permanent
B) invariable
C) temporary
D) constant
Answer: A
Diff: 1
Ref: Manual Data Entry
20) A field that CANNOT be blank and and must be unique is called a ______.
A) primary key
B) natural key
C) foreign key
D) composite key
Answer: A
Diff: 1
Ref: Understanding Tables and Keys
21) The characteristic that determines the kind of data that can be entered into a field is called a(n) ______.
A) data field
B) data type
C) entity
D) relationship
Answer: B
Diff: 1
Ref: Creating a Table in Design View
22) The ______data type is a check box where an empty box represents no and a checked box represents yes.
A) Attachment
B) Memo
C) Yes/No
D) Number
Answer: C
Diff: 1
Ref: Creating a Table in Design View
23) The maximum length of a data field is the ______.
A) information size
B) field length
C) data size
D) field size
Answer: D
Diff: 1
Ref: Creating a Table in Design View
24) If you need to use more than 255 characters in a text field, you should use the ______data type.
A) Lookup
B) Memo
C) Attachment
D) Date/Time
Answer: B
Diff: 1
Ref: Creating a Table in Design View
25) In a numeric data type, the Field size property defines the ______or value.
A) maximum length
B) property
C) calculated value
D) total value
Answer: A
Diff: 1
Ref: Creating a Table in Design View
26) If you need to use a ______data type, you do NOT have to select it, since it is the default data type.
A) number
B) date/time
C) text
D) memo
Answer: C
Diff: 1
Ref: Creating a Table in Design View
27) Using an ______, Access gives you a way to consistently enter data.
A) input table
B) input form
C) input record
D) input mask
Answer: D
Diff: 1
Ref: Input Masks
28) Though it does not affect the way data is stored in Access, a ______tells Access how the data is to be displayed.
A) label
B) preset
C) format
D) design
Answer: C
Diff: 2
Ref: Formatting
29) Access stores dates as a(n) ______.
A) long integer
B) decimal
C) floating-point number
D) integer
Answer: C
Diff: 1
Ref: Formatting
30) A ______is the primary key of one table stored in a second table to allow a relation to be created.
A) foreign key
B) composite key
C) unique key
D) natural key
Answer: A
Diff: 1
Ref: Understanding and Designating Keys
31) A ______key is used when two fields are needed to uniquely identify a record.
A) composite
B) natural
C) foreign
D) primary
Answer: A
Diff: 1
Ref: Understanding and Designating Keys
32) When data has a unique identifier included as part of the data, this is called a ______key.
A) primary
B) natural
C) composite
D) normal
Answer: B
Diff: 1
Ref: Understanding and Designating Keys
33) When you add relationships to tables, you can work with two or more ______in the same query, report, or form.
A) records
B) databases
C) fields
D) tables
Answer: D
Diff: 1
Ref: Understanding and Designating Keys
34) ______are created by joining the tables in a relational database together.
A) Relationships
B) Reports
C) Forms
D) Queries
Answer: A
Diff: 2
Ref: Understanding and Designating Keys
35) When you ______the tables in a database, there will be no redundancy in the tables.
A) systemize
B) normalize
C) relate
D) format
Answer: B
Diff: 2
Ref: Understanding Basic Principles of Normalization
36) A(n) ______relationship has one record in the first table that corresponds to many records in the second table.
A) cardinal
B) many-to-many
C) one-to-one
D) one-to-many
Answer: D
Diff: 2
Ref: Understanding Relationships
37) If you need to form a many-to-many relationship between two tables, you will need to create two one-to-many relationships called ______to represent the many-to-many relationship.
A) junction tables
B) related tables
C) cardinal tables
D) one-to-one relationships
Answer: A
Diff: 2
Ref: Create a Many-to-Many Relationship
38) A set of rules that Access uses to make sure that the relationships you are forming between the records in your tables make sense are called ______.
A) table integrity
B) referential integrity
C) cascade rules
D) relationship rules
Answer: B
Diff: 2
Ref: Understanding Referential Integrity
39) When referential integrity is enforced, you CANNOT ______a record from the one side table if matching records exist in the many side table.
A) add
B) change
C) move
D) delete
Answer: D
Diff: 1
Ref: Understanding Referential Integrity
40) ______makes changes and replicates the changes through all related tables so that referential integrity is maintained.
A) Torrent update
B) Flow update
C) Cascade update
D) Waterfall update
Answer: C
Diff: 2
Ref: Understanding Referential Integrity
41) A shirt is an example of an item, or attribute, in a clothing store database, while an entity is information about the shirt, such as the color or style.
Answer: FALSE
Diff: 3
Ref: Database Design
42) To allow for creating reports based on city or zip code, you should split address fields into their component parts.
Answer: TRUE
Diff: 3
Ref: Database Design
43) The Text data types give users the ability to calculate values.
Answer: FALSE
Diff: 1
Ref: Database Design
44) When cutting and pasting columns from Excel to Access, they must be the exactly the same.
Answer: TRUE
Diff: 1
Ref: Importing Data from Other Sources
45) To reference part of a worksheet in formulas or graphics by cell addresses or range addresses, you have to use a named range.
Answer: FALSE
Diff: 3
Ref: Importing Data from Other Sources
46) Delimited text has a special character such as a tab or a comma separating field entries.
Answer: TRUE
Diff: 2
Ref: Importing Data from Other Sources
47) When a table is open in Design view, you can type data directly into a table or form.
Answer: FALSE
Diff: 1
Ref: Manual Data Entry
48) Design changes are not saved until you save, but data changes are automatically saved.
Answer: TRUE
Diff: 1
Ref: Importing Data from Other Sources
49) When you delete individual fields from a table, these are permanent deletions that cannot be undone.
Answer: TRUE
Diff: 1
Ref: Manual Data Entry
50) You can add primary key data later after defining a primary key in a table.
Answer: FALSE
Diff: 2
Ref: Understanding Tables and Keys
51) Data types define the kinds of data that can be entered into a field.
Answer: TRUE
Diff: 1
Ref: Creating a Table in Design View
52) There is an upper limit of 155 characters for a text field.
Answer: FALSE
Diff: 1
Ref: Creating a Table in Design View
53) Access has a wizard that creates automatic masks for items such as zip codes, passwords, dates, and times.
Answer: TRUE
Diff: 1
Ref: Input Masks
54) Formats change the way data is stored in a database.
Answer: FALSE
Diff: 1
Ref: Formatting
55) The foreign key uniquely identifies each of the records in a table.
Answer: FALSE
Diff: 1
Ref: Understanding and Designating Keys
56) When two fields are needed to uniquely identify a record, use a composite key.
Answer: TRUE
Diff: 1
Ref: Understanding and Designating Keys
57) When table data has a unique identifier that is already a part of the data, it is called a natural primary key.
Answer: TRUE
Diff: 1
Ref: Understanding and Designating Keys
58) The relationships in a relational database are created by joining the tables together and relating fields.
Answer: TRUE
Diff: 1
Ref: Understanding Basic Principles of Normalization
59) Normalization is the process of cascading updates throughout a database.
Answer: FALSE
Diff: 1
Ref: Understanding Basic Principles of Normalization
60) Redundancy occurs when data is repeated several times in a database.
Answer: TRUE
Diff: 1
Ref: Understanding Basic Principles of Normalization
61) A relationship represents an entity in a database, while a field represents the data that connects the two tables.
Answer: FALSE
Diff: 2
Ref: Understanding Relationships
62) Cardinality represents the relationship between two tables when one record in the first tables corresponds to many records in the second table.
Answer: FALSE
Diff: 1
Ref: Understanding Relationships
63) You should use cascade delete to maintain your records and prevent redundancies.
Answer: FALSE
Diff: 2
Ref: Understanding Referential Integrity
64) A person, place, item, or event that you want to preserve data about is called a(n) ______.
Answer: entity
Diff: 1
Ref: Database Design
65) Information about an entity is called a(n) ______.
Answer: attribute
Diff: 1
Ref: Database Design
66) The ______pane in Design view gives information on how data is stored, entered, and processed.
Answer: Field Properties
Diff: 1
Ref: Database Design
67) A(n) ______is a set of cells that can be referred to by a name rather than by the cell references.
Answer: named range
Diff: 2
Ref: Importing Data from Other Sources
68) When you open a table in ______view, you can type data directly into the table.
Answer: Datasheet
Diff: 1
Ref: Manual Data Entry
69) The field called the ______that uniquely identifies a record in a table must be a field that will not change.
Answer: primary key
Diff: 1
Ref: Understanding Tables and Keys
70) The ______data type can store up to 1 gigabyte of characters and should be used when the text data type will not hold enough text.
Answer: Memo
Diff: 1
Ref: Creating a Table in Design View
71) A(n) ______defines a consistent template and provides the punctuation.
Answer: input mask
Diff: 1
Ref: Input Masks
72) In table design, the ______field property allows you to customize how data is displayed and printed in tables, queries, reports, and forms.
Answer: Format
Diff: 1
Ref: Formatting
73) Primary and foreign keys form a common field between tables that makes it possible to form a(n) ______between the two tables.
Answer: relationship
Diff: 1
Ref: Understanding and Designating Keys
74) When two fields are required to uniquely identify a record, they are called a(n) ______key.
Answer: composite
Diff: 1
Ref: Understanding and Designating Keys
75) A(n) ______allows you to work with two or more tables in the same query, report, or form.
Answer: relationship
Diff: 1
Ref: Understanding and Designating Keys
76) When a database is ______, the result is several smaller tables, each representing a different thing.
Answer: normalized
Diff: 1
Ref: Understanding Basic Principles of Normalization
77) ______occurs when data is repeated several times in a database.
Answer: Redundancy
Diff: 1
Ref: Understanding Basic Principles of Normalization
78) In Access, the relationship information is stored in the ______window.
Answer: Relationships
Diff: 1
Ref: Understanding Relationships
79) When you have a relationship between tables in which one record in one table has many matching records in a second table, and one record in the second table has many matching records in the first table, you have a(n) ______relationship.
Answer: many-to-many
Diff: 2
Ref: Understanding Relationships
80) A relationship between tables where a record in the first table has only one matching record in the second table is called a(n) ______relationship.
Answer: one-to-one
Diff: 1
Ref: Understanding Relationships
81) Before you can create a relationship between two tables, they have to have a(n) ______in common.
Answer: field
Diff: 1
Ref: Create a One-to-Many Relationship
82) If you are not using the same foreign key in two different tables to create a many-to-many relationship, you must use a(n) ______table to create the relationship.
Answer: junction
Diff: 2
Ref: Create a Many-to-Many Relationship
83) When you create a junction table to form a many-to-many relationship, the junction table is on the ______side of the two relationships.
Answer: many
Diff: 2
Ref: Create a Many-to-Many Relationship
84) Rules that Access uses to ensure that the relationships you form between records in your tables make sense are called ______.
Answer: referential integrity
Diff: 2
Ref: Understanding Referential Integrity
1
Copyright © 2013 Pearson Education, Inc.