Queries
The _____ pulls data from fields that you choose
Query Wizard
A database can best be described as a(n)
organized collection of related data.
If you want your report to look the same even on computers with different versions of Microsoft Access, you should
save it as a PDF.
Which type of data field is often used to store record IDs?
AutoNumber
To widen a column so it displays all the data, hover the mouse pointer over the right border until the pointer changes to a _____ and then double-click.
left-and-right pointing arrow with a vertical line in the middle
A query extracts data from one or more
tables
Microsoft Access uses an object called a _____ to enter and organize data.
table
An Access report is based on related
tables or queries.
To delete a record from a table, locate the record, click the gray record selector bar, click the Delete arrow on the Home tab, and then click the _____ option in the drop-down list.
Delete Record
By default, every other row in a datasheet
has a different background color.
Where is the Query Wizard button located?
in the Queries group on the Create tab
When you open an Access database, what do you see?
the Navigation pane
Because an Access report is linked to the objects used to create it,
it automatically updates whenever changes are made to the data in those objects.
To alphabetize records by last name from A to Z, click the _____ button.
Ascending
You can change the background color of every second row by clicking the _____ on the Home tab and then selecting a different color.
Alternate Row Color arrow in the Text Formatting group
To select data that meets a set of criteria, you should use a
query
To create a query that displays records for only those people who live in a specific zip code, enter that zip code in the _____ cell for the Zip field on the query design grid.
Criteria
On which tab will you find the Report button?
Create
To return sorted data to its original order, click the _____ button.
Remove Sort
Once you create a query in Access, you can run it
over and over again.
Click the _____ button in the Results group on the Query Tools Design tab to display the query results in a datasheet.
Run
Access allows you to enter data in a table or a
form
To see what your report will look like when printed, begin by clicking the
View arrow in the Views group on the Home tab.
Suppose that you have a customer table containing a field called State. If you click the first record in the State column and then click the Align Left button in the Text Formatting group on the Home tab, what record(s) will the formatting be applied to?
all the records in the State column
Why would you use a query?
to pull data from one or more tables