Deck 3: Building a Database and Defining Table Relationships

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

External data are data that are imported from a source other than the current database without having to open the source file. _________________________

Question 8

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

Question 9

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

Question 10

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

Question 11

In the accompanying figure, the default value property for the State field is "CT". _________________________

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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 21

In the accompanying figure, the highlighted record entries illustrate a database design with ____.

A) extremely long character widths
B) data redundancy
C) a composite primary key
D) no field properties

Question 22

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 23

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 24

The accompanying figure illustrates the ____ view which allows the user to modify a table structure.

A) Datasheet
B) Relationship
C) Design
D) Grid

Question 25

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

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

Question 26

In the accompanying figure, the field size is set to ____.

A) Short text
B) InvoiceNum
C) General
D) 5

Question 27

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 28

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

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

Question 29

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

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

Question 30

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

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

Question 31

In the accompanying figure, the top portion of the table window indicated by the red bracket is the ____.

A) Field Property grid
B) Table Design grid
C) General grid
D) Primary grid

Question 32

What is the maximum character length of a field name?

A) 64
B) 255
C) 48
D) 240

Question 33

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

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

Question 34

In the accompanying figure, the ____ is indicated by the red brackets.

A) Design view
B) Field Properties pane
C) Datasheet view
D) Relationship pane

Question 35

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 36

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

Question 37

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 38

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 39

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

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

Question 40

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 41

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 42

In the accompanying figure, once the selected field is moved it will appear above which field in Design view?

A) InvoicePaid
B) InvoiceDate
C) InvoiceAmt
D) InvoiceNum

Question 43

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 44

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 45

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 46

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 47

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 48

In the accompanying figure, the primary key for the Vist table is the ____ field.

A) PatientID
B) VisitDate
C) Reason
D) VisitID

Question 49

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 50

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 51

In the accompanying figure, the ____ field has been selected to be moved in the Design view.

A) InvoiceNum
B) InvoiceAmt
C) InvoiceDate
D) InvoicePaid

Question 52

What is the default setting for the Field Size property for a field with the Number data type?

A) 2
B) Auto
C) Long Integer
D) 15

Question 53

In the accompanying figure, what is the name of the table being edited?

A) Invoices
B) InvoicePaid
C) Chatham
D) Billing

Question 54

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 55

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

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

Question 56

In the accompanying figure, which button on the ribbon should be used to add a table to the Relationship window?

A) Show Table
B) Edit Relationships
C) Direct Relationships
D) Relationship Report

Question 57

In the accompanying figure, fields inserted into the table using the Address Quick Start fields will be inserted prior to the ____ field.

A) Phone
B) Email
C) Fax
D) PatientID

Question 58

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 59

Which table in the Chatham database is illustrated in the accompanying figure?

A) Patient
B) Billing
C) Invoices
D) Payment

Question 60

Predefined display formats for fields with the Date/Time data type may be chosen from the ____ field property.

A) Input Mask
B) Format
C) Default Value
D) Text Align

Question 61

Case-Based Critical Thinking Questions Case 2-2
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 62

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

Question 63

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 64

Case-Based Critical Thinking Questions Case 2-3
Syed and Marino Li own a small furniture consignment shop in Atlanta, GA. Syed is designing a database that will allow them to keep track of item information and seller information.  Each item is assigned to one seller; however, each seller may be assigned multiple items in the database. The database will contain the following information: item identification number, item description, seller code, condition of item, retail price of item, item quantity, date item received, condition of item, date the item is sold, the final sale price of the item, seller name, seller address, and seller contact information.  Using appropriate database design guidelines, answer the following questions.
Based on the information to be included in the database, which of the following possible field names would be the best common field to include in two or more tables?

A) ItemID
B) SellerLName
C) SellerCode
D) ItemPrice

Question 65

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

Question 66

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

Question 67

Case-Based Critical Thinking Questions Case 2-1
Akae plans to develop a database for his small DJ business that will include his music catalog, artists, clients, purchases, equipment, and vendors. Akae has identified that the following information will be included in the database:
∙ artist
∙ song and year
∙ client name
∙ client address
∙ client contact information
∙ vendor
∙ purchases
∙ equipment
∙ equipment inventory and rental
Given the information Akae would like to include in his database, how many tables would be optimal if similar information is grouped into tables?

A) 5
B) 4
C) 3
D) 2

Question 68

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 69

Case-Based Critical Thinking Questions Case 2-2
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 70

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

Question 71

Case-Based Critical Thinking Questions Case 2-1
Akae plans to develop a database for his small DJ business that will include his music catalog, artists, clients, purchases, equipment, and vendors. Akae has identified that the following information will be included in the database:
∙ artist
∙ song and year
∙ client name
∙ client address
∙ client contact information
∙ vendor
∙ purchases
∙ equipment
∙ equipment inventory and rental
Client contact information should include several fields.  Which of the following field choices would allow client contact data to be separated into the smallest useful parts and provide Akae with the most options for contacting a client?

A) phone number, address
B) mobile number, home number, email address
C) mobile number, home number, primary email address, secondary email address
D) mobile number, primary email address

Question 72

Case-Based Critical Thinking Questions Case 2-2
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
Several participants registered for activities late as other participants cancelled.  These participants need to be added to the Participants table.  What is the most expedient way to add these participants and their paid status to the Participants table?

A) type the information for each participant in the Participants table in datasheet view
B) import the data from the Excel spreadsheet into the Participants table
C) type the ParticipantID in the Participants table and link to the Excel spreadsheet
D) drag the Excel spreadsheet over the Participants table and the table will be updated

Question 73

Case-Based Critical Thinking Questions Case 2-2
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

Each parks and recreation employee must keep a copy of parent contact information for all campers with them at all times.  Using the figure above, which two tables must have a relationship established to allow Leah to print a report of all campers and the their parents' contact information?

A) Activities and Parents
B) Participants and Parents
C) Activities and Parents
D) Employees and Activities

Question 74

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(n) ____ relationship.

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

Question 75

____________________ 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 76

Case-Based Critical Thinking Questions Case 2-1
Akae plans to develop a database for his small DJ business that will include his music catalog, artists, clients, purchases, equipment, and vendors. Akae has identified that the following information will be included in the database:
∙ artist
∙ song and year
∙ client name
∙ client address
∙ client contact information
∙ vendor
∙ purchases
∙ equipment
∙ equipment inventory and rental
As Akae designs his database, which information group's fields might be added to a table quickly with the Quick Start selection?

A) client contact information
B) purchases
C) song and year
D) client address

Question 77

Case-Based Critical Thinking Questions Case 2-2
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

Considering the table in the figure above, which data type is best suited for the ActivityStartTime and the ActivityEndTime fields?

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

Question 78

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

Question 79

Case-Based Critical Thinking Questions Case 2-3
Syed and Marino Li own a small furniture consignment shop in Atlanta, GA. Syed is designing a database that will allow them to keep track of item information and seller information.  Each item is assigned to one seller; however, each seller may be assigned multiple items in the database. The database will contain the following information: item identification number, item description, seller code, condition of item, retail price of item, item quantity, date item received, condition of item, date the item is sold, the final sale price of the item, seller name, seller address, and seller contact information.  Using appropriate database design guidelines, answer the following questions.
Based on the information to be included in the database, what is the best way to avoid data redundancy in the database?

A) store data for each field in only one table (excluding the common field)
B) store data for each field in multiple tables (excluding the common field)
C) create a composite primary key (including the common field)
D) change field properties for all fields to require data input

Question 80

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