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

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

Answer 2

False
Table Design grid

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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 23

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 24

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 25

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

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

Question 26

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 27

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 28

What is the maximum character length of a field name?

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

Question 29

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 30

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

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

Question 31

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 32

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

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

Question 33

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 34

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

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

Question 35

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

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

Question 36

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 37

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

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

Question 38

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

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

Question 39

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 40

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

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

Question 41

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

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

Question 42

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 43

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 44

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 45

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

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

Question 46

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 47

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 48

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 49

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 50

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

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

Question 51

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 52

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 53

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 54

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 55

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 56

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 57

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 58

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

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

Question 59

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 60

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 61

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 62

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 63

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 64

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

Question 65

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 66

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

Question 67

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

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 70

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 71

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

Question 72

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 73

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

Question 74

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

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

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

Question 77

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 78

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 79

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

Question 80

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