Data
Structure
Surprise
Views
Commands
100
One type of file that can be exported from Access tables and queries.
What is Excel, Text, or XML?
100
A line item in Access that contains information about a given person, product, or event.
What is a record?
100
The name of the "key" symbol that appears next to a field in Design View.
What is the Primary Key?
100
View that shows a report as it will appear when printed.
What is Print Preview?
100
Used to order the records in the answer to a query in a particular way.
What is Sort?
200
Use these to enclose text enter as a parameter in a parameter query.
What are brackets?
200
Click this tab to view the buttons to import data into or export data out of Access.
What is the External Data tab?
200
Symbol used to designate a wild card is being used.
What is the * (star or asterisk) symbol?
200
View that is used to input field names, data types, and descriptions
What is Design View?
200
Used to create a query that satisfies two criteria.
What is AND?
300
In order to display unique values only in your query, you must click this button and click Yes next to Unique Values.
What is Property Sheet?
300
Click this tab to make queries, forms, and reports.
What is the Create tab?
300
To combine criteria with OR, structure criteria in this way in the Design grid.
What is on separate rows?
300
This view displays a single record at a time
What is Form View?
300
A field that is created using values from existing fields and mathematical operators to add, subtract, divide, etc.
What is a calculated field?
400
This type of query is useful for summarizing data by category or group.
What is a Crosstab Query?
400
Click this tab to view and edit Relationships.
What is Database Tools?
400
Question that is asked of Access or any other database management system.
What is a query?
400
View that allows you to see the results of a query line-by-line.
What is the Datasheet View?
400
An Access tool that helps you create complex expressions.
What is the Expression Builder?
500
These three items can make up criteria for a query.
What are letters, numbers, and comparison operators?
500
This contains a list of all the objects in the database.
What is the Navigation Pane?
500
By un-checking this box on the design grid, you can still use the field(s), but they will not appear in the query results
What is the Show Box?
500
View that allows you to change the positioning of items on a Form or Report.
What is Layout View?
500
Line that links two tables via matching fields.
What is a join?
M
e
n
u