How can we help?

You can also find more resources in our Help Center.

40 terms

True/False - Access

STUDY
PLAY
An Access database can have a maximum of one table
False
Datasheet View is used to precisely determine the characteristics of each field
False
You cannot modify the size of a field in Design View
False
A database is like a container because it can hold several types of objects, including tables, forms, reports, and queries
True
The Show Margins command can be used to set precise column widths
False
The page orientation can be changed with the Print Preview command
True
Portrait orientation causes a table to print horizontally on a page
False
Tables are composed of records
True
Text, Number, and Currency are examples of data types
True
You can enter data into a table in Design View
False
Filters are a temporary way to view records that meet specific criteria
True
To select an entire record, click anywhere in the record
False
An input mask can automatically enter parentheses around the area code of a phone number
True
Changing the structure of a table will never result in lost data
False
The table template is used to automate data entry in a table
False
A pencil icon in the row selector indicates that a record is being edited
True
Once you are in Datasheet View, you cannot go back to the Table Design View
False
To use Filter by Form you must first click on the field that contains the desired value
True
The Table Template provides a variety of sample fields to use in a table
True
Using validation rules, you can set a specific range of values allowed in the field
True
Forms can be used to enter data in tables
True
The main benefit of forms is that they allow you to view several records simultaneously
False
The navigation buttons at the bottom of a form can be used to move between records
True
Forms do not display currency symbols ($) and other formatting characters
False
You must first select a table before creating a simple form from the ribbon
True
The Report Wizard lets you choose the fields you wish to include in a report
True
The design of a report cannot be changed once the report has been saved
False
The Report Wizard lets you choose Portrait or Landscape orientation
True
Reports can be used to enter data
False
An object can be copied and then pasted to a different database
True
Criteria determine the records selected by a query
True
The Query Design grid is where you define a query
True
You can add fields to the Query Design grid by double clicking the desired fields on the field list(s) above the Query Design grid
True
You can add all fields to the Query Design grid by double clicking any field in the field list
False
Changing data in the recordset has no impact on the underlying data in the table(s) on which the query is based
False
You must type criteria in the same case (upper or lower) as the data in the tables you are querying or Access will not select the desired records
False
If a field has been entered into the Query Design grid, you cannot prevent the field from appearing in the recordset
False
The two types of compound criteria are AND and OR
True
You cannot use wildcards for numeric values
False
Access can sort on more than one field at a time
True