Which of the following is the default name that Access assigns to new blank tables?
Table1
It is possible to change row height by ____________ the border of a row.
WRONG- NOT double-clicking
What must be unique about each field in a table?
name
Which of the following is a special text format applied to a Long Text data type that allows you to store formatted text?
Rich Text
When you first create an object, Access assigns a generic name, such as Table1 or Form1.
true
What is another name for a single unit of data?
field
What must you create for each of the different pieces of information you want to keep in your table?
field
What is a collection of related records called?
table
What are data records displayed in?
datasheet
To add a new field between existing fields, put your pointer on the field name of the column _____________ where you wish to insert a new field.
to the right of
To change the name of a field in a datasheet, _____________ the field name.
double-click
Which tab are Access's features for formatting text found?
Home
Which of the following functions are helpful in limiting the number of records that display in your datasheet?
Filter
The Navigation pane displays your objects by categories and groups.
true
Each field in a table must have a unique name.
true
Which of the following tabs provides information about your database and additional functions to help you manage the database?
Database Tools
Which of the following helps you easily scan the records and fields in your database?
alternate row colors
In Access, it is not possible to delete fields after you have added data to the field.
false
It is not possible to change the order of fields in an Access table.
false
Which of the following determines the default alignment of each field?
field type
To best organize a database, what must you understand?
hierarchy of data
You can sort a datasheet by one field, or a set of adjacent fields, in ascending or descending order.
true
Which of the following allows you to enter, modify, delete, or view data records?
WRONG- NOT Design view
Descending order is the lowest to highest for a number field or A to Z for a text field.
false
Which of the following is a field that contains a unique value for each record?
primary key
A template provides you with a complete, ready-to-use database application.
true
Which of the following describes a pre-designed database?
template
It is strongly recommended that you identify a(n) ___________ in each table as the primary key.
field
Which of the following tabs provides functionality for linking to other applications and data files?
External Data
It is necessary to save a database file before closing it.
false
Which of the following should you use if you are going to make several changes at once to the datasheet layout?
Datasheet Formatting dialog box
Which of the following is an organized collection of integrated and related tables?
database
Which of the following data types would you use to display a spreadsheet object in a field?
OLE Object
The Datasheet Formatting dialog box enables you to make several changes at once to the layout of a datasheet.
true
Form objects are used to find data in a database.
false
Once a filter has been applied to datasheet records, it is not possible to return them to their original unfiltered state.
false
When a new table is created in Datasheet view, what field does Access automatically include?
ID
Access automatically assigns a generic file name to your database, such as Database1.accdb.
true
If you have several users of your database, you must be certain that all users have ___________ the database before you perform a backup procedure.
closed
Which of the following tabs must you use to create all the objects you use in a database?
WRONG- NOT Database Tools
Which of the following is used to find data in a database?
query
The Navigation pane shows each object in your database.
true
To delete a record from a table, first click in the _______________ of the _____________.
Record Selector cell, record
A primary key is a field that contains a unique value for each record.
true
Compound filter criteria combine more than one search value using the AND and OR logical operators.
true
Access ____________ determines a data type for the field based on the contents that you enter.
WRONG- NOT sometimes
Which of the following data types is used to store the results of a calculation?
Calculated
Which of the following data types is used for storing text longer than 255 characters?
Long Text
Which of the following data types is used to instruct Access to insert a unique, sequential number each time a new record is added?
AutoNumber
Access is a relational database management system.
true