Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
24 Cards in this Set
- Front
- Back
|
in Access, the columns in a table are called records.
|
False
|
|
|
A unique identifier also is called a primary key.
|
True
|
|
|
Replication is the storing of a piece of data in more than one place.
|
False
|
|
|
Database Design Language (DBDL) is a programming language.
|
False
|
|
|
In Access, table names can be up to 128 characters in length.
|
False
|
|
|
In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.
|
True
|
|
|
The maximum number of characters allowed in a field whose data type is Text is 1024.
|
False
|
|
|
Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Text.
|
True
|
|
|
The Monetary data type is used for fields that contain only monetary data.
|
False
|
|
|
The URL Address data type can store text that can be used as a hyperlink address.
|
False
|
|
|
File names can be a maximum of 255 characters including the file extension.
|
True
|
|
|
A folder is a specific location on a storage medium.
|
True
|
|
|
To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.
|
False
|
|
|
In Datasheet view, a table is represented as a collection of rows and columns called a datasheet.
|
True
|
|
|
One way to undo changes to a field is to click the Undo button on the Table Tools tab.
|
False
|
|
|
Access is a ____.
|
database management system
|
|
|
In Access, a(n) ____ consists of a collection of tables, each of which contains information on a specific subject.
|
database
|
|
|
A(n) ____ contains information about a given person, product, or event.
|
record
|
|
|
____ words are words that have a special meaning to Access and cannot be used for the names of fields or tables.
|
Reserved
|
|
|
In Access, table and field names can be up to ____ characters in length.
|
64
|
|
|
A field whose data type is ____ can contain any characters
|
Text
|
|
|
A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.
|
Memo
|
|
|
A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.
|
AutoNumber
|
|
|
A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.
|
Attachment
|
