Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/24

Click to flip

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