Deck 2: Building a Database and Defining Table Relationships

Question 1

 The Address Quick Start selection adds a group of relationships related to an address including Address,City,State,etc._________________________

Answer 1

  False
fields

Question 2

 The ____ property allows the database designer to explain the purpose of a field or how a field is used. 

A) Data type
B) Field size 
C) Required
D) Description

Answer 2

  D

Question 3

 The Data Type Gallery,which allows the entry of groups of fields using the Quick Start selection,is only available in Datasheet view. _________________________ 

Answer 3

  True

Question 4

 When text is used as the Default Value for a field property,it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message. _________________________ 

Question 5

 The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane. _________________________ 

Question 6

 The Currency data type is accurate up to 4 digits on the right side of the decimal point._________________________

Question 7

 All fields in a database should be contained in one table. _________________________ 

Question 8

 Access does not allow data to be imported from sources other than another Access database. _________________________ 

Question 9

 Access automatically assigns the Number data type to all new fields. _________________________ 

Question 10

 Access does not require a field description for every field included in a table. _________________________ 

Question 11

 A primary key that consists of two or more fields is called a(n) redundant key._________________________

Question 12

 In the Database Design grid,press the Enter key to move from one property to the next property._________________________

Question 13

 In order to define table relationships,each table being joined must contain a common field._________________________ 

Question 14

 Access does not require a table to have a(n) primary key._________________________

Question 15

 Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database. _________________________ 

Question 16

 Relationship integrity is a set of rules used by Access to maintain consistency between related tables when data in either table is updated._________________________

Question 17

 A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut._________________________

Question 18

 Field names in a table may only be changed in Design view. _________________________ 

Question 19

 ____ is the default name for a new table in an Access database. 

A) My table
B) Table1 
C) ADB Table
D) TableA

Question 20

 The field name displayed in database objects,including forms and reports,is determined by the Caption property._________________________

Question 21

 The data type that allows both sequential and random numbering is the ____ data type. 

A) Number
B) Currency 
C) AutoNumber
D) Long Date

Question 22

 The default character length for the Short Text data type is ____ characters. 

A) 55
B) 255 
C) 64
D) 15

Question 23

 Which symbols would be used to create a custom date format that would display July 4,2016 as 7/04/16? 

A) mm/dd/yyyy
B) m/ddd/yy 
C) mmm/d/yyyy
D) m/dd/yy

Question 24

 Which data type allows the designer to define the Field Size property? 

A) Long Text
B) Hyperlink 
C) Memo
D) AutoNumber

Question 25

 Which data type would be the best logical data type for a field named PaidDate? 

A) Currency
B) Number 
C) Memo
D) Date/Time

Question 26

 Changing the order of fields in a database table is an example of changing a table's ____. 

A) purpose
B) structure 
C) data
D) value

Question 27

 When choosing field names,it is best to choose names that ____. 

A) include both numbers and letters in the name 
B) use only uppercase characters 
C) describe the content or purpose of the field 
D) use only lowercase letters and no spaces

Question 28

 Which data type allows both positive and negative numbers as field values? 

A) Number
B) Date/Time 
C) AutoNumber
D) Short Text

Question 29

 A field in an Access database table that has no value is determined by Access to have a ____ value. 

A) custom
B) zero 
C) null
D) number

Question 30

 A database management system is a useful tool only if it meets which of the following criteria? 

A) produces reports
B) contains simple records 
C) meets the needs of its users
D) meets the needs of the designer

Question 31

 A field used to connect one table logically with another table is called a ____ field. 

A) common
B) primary 
C) composite
D) data

Question 32

 The ____ property specifies the number of decimal places displayed to the right of the decimal point. 

A) Decimal Places
B) Input Mask 
C) Default Value
D) Format

Question 33

 The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition. 

A) AutoNumber
B) Short Text 
C) Yes/No
D) Long Text

Question 34

 The common field between two tables in the Relationship window is indicated by a(n) ____. 

A) key icon
B) field name 
C) join line
D) infinity symbol

Question 35

 Which of the following is the most logical data type to use if a field will contain long comments or explanations? 

A) Hyperlink
B) Short Text 
C) Memo
D) Long Text

Question 36

 Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid? 

A) Yes/No
B) Memo 
C) Text
D) AutoNumber

Question 37

 Formatting Date/Time fields changes only the way data is displayed,not the field ____. 

A) values
B) letters 
C) numbers
D) mask

Question 38

 A database system determines how to store,display,and process field values based on which of the following? 

A) field names
B) field properties 
C) field captions
D) field size

Question 39

 Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail? 

A) there is no relationship between tables 
B) the Excel and Access caption property values to do not match 
C) the data was entered incorrectly 
D) the Access field names and the Excel worksheet column headings do not match

Question 40

 A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____. 

A) July 4, 2016
B) 07/04/16 
C) 7/4/2016
D) Jul/04/16

Question 41

 The "one" table in a one-to-many relationship is the ____________________ table.

Question 42

 By choosing the Definition Only option in the Import Objects dialog box,the ____ of a table is imported,but not the ____. 

A) data, structure
B) data type, structure 
C) structure, data
D) structure, data type

Question 43

 A relationship between Access tables that is a relationship between one record in the first table and zero,one,or many records in the second table,and at least one record in the second table matches at most one record in the first table,is defined as a ____ relationship. 

A) One-to-One
B) One-to-Many 
C) One-to-Most
D) Many-to-One

Question 44

 The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

Question 45

 To begin importing data from an Excel spreadsheet,click on the ____ tab on the ribbon. 

A) Create
B) Database Tools 
C) External Data
D) Home

Question 46

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency.Participant and payment information is stored in an Excel spreadsheet as children are registered for activities.An Access database contains information about children (participants),parents,employees,as well as activity sessions and schedules.The database contains the following tables:
∙ Participant Information
∙ Parent Information
∙ Employees
∙ Activities
 After printing a report of parent information for camper pick-up monitors,Santana decides some of the field names displayed on the report are hard to read.  For example,she prefers the field MotherMobilePhone to be displayed as Mother Cell on the report.  Which field property should be changed to modify the field name display on the report? 

A) Input Mask
B) Default Value 
C) Format
D) Caption

Question 47

 A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n) ____________________ in the second table.

Question 48

 A value set in the Field Properties pane that appears in a field automatically is the ____ for the field. 

A) entered value
B) changed value 
C) default value
D) permanent value

Question 49

 The way field values are stored,displayed,and processed in an Access database is determined by the ____________________.

Question 50

 In a single table,all ____________________ must be unique within that table.

Question 51

 It is important that data being imported from a text file into Access are separated by a character,such as a comma,which defines the text file as a(n) ____ text file. 

A) imported
B) readable 
C) delimited
D) external

Question 52

 Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

Question 53

 Field value maximum storage size is defined by the Field Size property for the data types including Short Text,Number,and ____________________ only.

Question 54

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency.Participant and payment information is stored in an Excel spreadsheet as children are registered for activities.An Access database contains information about children (participants),parents,employees,as well as activity sessions and schedules.The database contains the following tables:
∙ Participant Information
∙ Parent Information
∙ Employees
∙ Activities
 Leah and Santana have been requested to print a daily report of scheduled activities.  Their supervisor needs to know if each participant has paid for the activity.  The ParticipantPD field will be included in the report.  Which data type will allow the report to display a true/false condition for the ParticipantPD field? 

A) Short Text
B) Number 
C) Yes/No
D) Currency

Question 55

 ____________________ is the process that allows data to be copied to an Access database table from a source without having to open the source file.

Question 56

 One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

Question 57

 ____________________ view allows the database designer to enter both the field names and define the field properties.

Question 58

 Field name display in database objects such as datasheets,forms,and reports is determined by the ____________________ property.

Question 59

 The default Field Size for the Short Text data type is ____________________ characters.

Question 60

 The ____________________ data type is not subject to round-off error when calculated,unlike the Number data type with decimal values.

Question 61

Identify the letter of the choice that best matches the phrase or definition.
a.Cascade Update Related Fields Option
b.Cascade Delete Related Records Option
c.Composite key
d.data redundancy
e.Data Type gallery
f.Design
g.orphaned record
h.propagate
i.Quick Start selection
j.referential integrity
 The Access database view that allows users to define or modify a table structure or field properties in a table.

Question 62

Identify the letter of the choice that best matches the phrase or definition.
a.Cascade Update Related Fields Option
b.Cascade Delete Related Records Option
c.Composite key
d.data redundancy
e.Data Type gallery
f.Design
g.orphaned record
h.propagate
i.Quick Start selection
j.referential integrity
 An Access feature available from the FIELDS tab that allows the user to add a group of related fields to a table at the same time.

Question 63

Identify the letter of the choice that best matches the phrase or definition.
a.Cascade Update Related Fields Option
b.Cascade Delete Related Records Option
c.Composite key
d.data redundancy
e.Data Type gallery
f.Design
g.orphaned record
h.propagate
i.Quick Start selection
j.referential integrity
 The process that occurs when the field Description (Optional) property is changed in Design View and the Property Update Options tool is used to update the entire database everywhere the field is used,including forms and reports.

Question 64

Identify the letter of the choice that best matches the phrase or definition.
a.Cascade Update Related Fields Option
b.Cascade Delete Related Records Option
c.Composite key
d.data redundancy
e.Data Type gallery
f.Design
g.orphaned record
h.propagate
i.Quick Start selection
j.referential integrity
 A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

Question 65

 Explain how a one-to-many relationship is created using an Access database with two or more tables.  Why is it useful to create a relationship between tables?

Question 66

 ____________________ values are never allowed by Access in the primary key field.

Question 67

Identify the letter of the choice that best matches the phrase or definition.
a.Cascade Update Related Fields Option
b.Cascade Delete Related Records Option
c.Composite key
d.data redundancy
e.Data Type gallery
f.Design
g.orphaned record
h.propagate
i.Quick Start selection
j.referential integrity
 A record in a table that is related to a primary table but has no matching record established with the primary table.

Question 68

 Discuss at least three advantages of including a primary key in a table.

Question 69

Identify the letter of the choice that best matches the phrase or definition.
a.Cascade Update Related Fields Option
b.Cascade Delete Related Records Option
c.Composite key
d.data redundancy
e.Data Type gallery
f.Design
g.orphaned record
h.propagate
i.Quick Start selection
j.referential integrity
 The Access option that permits a change in the value of the primary key in a table and changes the appropriate foreign key values in the related table.

Question 70

Identify the letter of the choice that best matches the phrase or definition.
a.Cascade Update Related Fields Option
b.Cascade Delete Related Records Option
c.Composite key
d.data redundancy
e.Data Type gallery
f.Design
g.orphaned record
h.propagate
i.Quick Start selection
j.referential integrity
 A group of fields added all at once using the Data Type gallery.

Question 71

Identify the letter of the choice that best matches the phrase or definition.
a.Cascade Update Related Fields Option
b.Cascade Delete Related Records Option
c.Composite key
d.data redundancy
e.Data Type gallery
f.Design
g.orphaned record
h.propagate
i.Quick Start selection
j.referential integrity
 The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.

Question 72

 List six guidelines for designing databases.

Question 73

 The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

Question 74

Identify the letter of the choice that best matches the phrase or definition.
a.Cascade Update Related Fields Option
b.Cascade Delete Related Records Option
c.Composite key
d.data redundancy
e.Data Type gallery
f.Design
g.orphaned record
h.propagate
i.Quick Start selection
j.referential integrity
 A primary key that consists of two or more fields in a table.

Question 75

Identify the letter of the choice that best matches the phrase or definition.
a.Cascade Update Related Fields Option
b.Cascade Delete Related Records Option
c.Composite key
d.data redundancy
e.Data Type gallery
f.Design
g.orphaned record
h.propagate
i.Quick Start selection
j.referential integrity
 The term used when the same data is stored in more than one place which can cause inconsistencies in the database.