Access 2 Data

25 July 2022
4.7 (114 reviews)
39 test answers

Unlock all answers in this set

Unlock answers (35)
question
All fields in a database should be contained in one table. _________________________
answer
False
question
Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database. _________________________
answer
True
question
Access automatically assigns the Number data type to all new fields. _________________________
answer
False
question
Access does not require a field description for every field included in a table. _________________________
answer
True
question
The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view. _________________________
answer
True
question
Field names in a table may only be changed in Design view. _________________________
answer
False
question
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
True
question
In order to define table relationships, each table being joined must contain a common field. _________________________
answer
True
question
Relationship integrity is a set of rules used by Access to maintain consistency between related tables when data in either table is updated. _________________________
answer
False
question
A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut. _________________________
answer
True
question
Access does not require a table to have a(n) primary key. _________________________
answer
True
question
In the Database Design grid, press the Enter key to move from one property to the next property. _________________________
answer
False
question
The field name displayed in database objects, including forms and reports, is determined by the Caption property. _________________________
answer
True
question
The Currency data type is accurate up to 4 digits on the right side of the decimal point. _________________________
answer
True
question
A primary key that consists of two or more fields is called a(n) redundant key. _________________________
answer
False
question
____ is the default name for a new table in an Access database.
answer
Table1
question
A field used to connect one table logically with another table is called a ____ field.
answer
common
question
A database system determines how to store, display, and process field values based on which of the following?
answer
field properties
question
When choosing field names, it is best to choose names that ____.
answer
describe the content or purpose of the field
question
Which data type would be the best logical data type for a field named PaidDate?
answer
Date/Time
question
The default character length for the Short Text data type is ____ characters.
answer
255
question
The data type that allows both sequential and random numbering is the ____ data type.
answer
AutoNumber
question
The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.
answer
Yes/No
question
Which of the following is the most logical data type to use if a field will contain long comments or explanations?
answer
Long Text
question
Which data type allows the designer to define the Field Size property?
answer
AutoNumber
question
A field in an Access database table that has no value is determined by Access to have a ____ value.
answer
null
question
Formatting Date/Time fields changes only the way data is displayed, not the field ____.
answer
values
question
The common field between two tables in the Relationship window is indicated by a(n) ____.
answer
join line
question
To begin importing data from an Excel spreadsheet, click on the ____ tab on the ribbon.
answer
External Data
question
A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.
answer
default value
question
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.
answer
delimited
question
The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.
answer
Single
question
Field value maximum storage size is defined by the Field Size property for the data types including Short Text, Number, and ____________________ only.
answer
AutoNumber
question
The ____________________ data type is not subject to round-off error when calculated, unlike the Number data type with decimal values.
answer
Currency
question
The way field values are stored, displayed, and processed in an Access database is determined by the ____________________.
answer
field properties
question
____________________ view allows the database designer to enter both the field names and define the field properties.
answer
Design
question
The default Field Size for the Short Text data type is ____________________ characters.
answer
255
question
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.
answer
foreign key
question
The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.
answer
infinity symbol ampersand infinity