Deck 2: Building a Database and Defining Table Relationships

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

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

Question 16

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

Question 17

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

Question 18

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 19

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

Question 20

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

Question 21

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 22

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 23

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

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

Question 24

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

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 27

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 28

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 29

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

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 32

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

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

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

Question 35

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

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

Question 36

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

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

Question 37

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 38

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 39

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 40

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

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

Question 41

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

Question 42

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

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

Question 44

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 45

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

Question 46

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

Question 47

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

Question 48

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

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

Question 50

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 51

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

Question 52

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

Question 53

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

Question 54

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

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 58

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 59

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 60

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

Question 61

List six guidelines for designing databases.

Question 64

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

Question 67

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 72

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

Question 75

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