Deck 2: Access Module : Building a Database and Defining Table Relationships

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

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

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

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

Question 19

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

Question 20

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

Question 21

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 22

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 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 allows both positive and negative numbers as field values?

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

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

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 28

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 29

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 30

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 31

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 32

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 33

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

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

Question 34

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

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 data type would be the best logical data type for a field named PaidDate?

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

Question 40

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

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

Question 41

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

Question 42

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

Question 43

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 44

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

Question 45

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

Question 46

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 47

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

Question 48

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

Question 49

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

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

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

Question 53

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

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

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 56

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 57

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

Question 58

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 59

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

Question 60

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

Question 62

List six guidelines for designing databases.

Question 63

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

Question 64

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 65

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

Question 66

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