Queries can retrieve information from _____ tables
multiple
200
What two objects can you create reports from?
tables and queries
300
How does a relational database work?
Lists objects related to one another
300
What is the most important object in Access?
tables
300
Does a form let you see the entire record at one time?(T/F)
true
300
What connects two tables in a query?
join line
300
What tool guides you through the process of creating complex reports?
Report Wizard
400
Why do you use a real database?
to handle non-numerical data like names and descriptions
400
What are tables composed of?
rows and columns
400
What are two ways to add a new record to a form?
Records group on the Home tab and record navigation bar
400
query results will be displayed in the query's _________ view.
Datasheet
400
How many fields can you sort in report wizard?
4
500
What is the difference in relational databases in Access and Excel?
In Access you can enter, search and analyze data easier than Excel because you can handle more than one table at a time.
500
What are three ways to navigate through records in a table?
arrow keys, scroll and navigation bar
500
What is one way forms make the data entry process easier?
A. database keeps itself working smoothly
B. designers can control how users are able to interact with the database.
C. They can set restrictions
D. All of the above
500
A sort that includes more than one sorted field is called a what?
multi-level sort
500
When you're formatting your report, how can you add text to a header and footer?