Database Basics
Tables
Forms
Queries
Reports
100
records
What is a Database is divided into?
100
Column
Whats the vertical lines called in a table?
100
a database object that you can use to create a user interface for a database application.
What is a form?
100
Pull information from one or more tables based on a set of search conditions you define.
What do query allow you to do?
100
gives you the ability to present components of your database in an easy-to-read, printable format
What is a report used for?
200
Fields
What are records made up of?
200
Rows
What is the horizontal lines called in a table?
200
obtaining information in a specific format.
What are form used for?
200
a way of searching for and compiling data from one or more tables.
What are Queries?
200
click any cell in the field and click delete
How do you delete a field in a report?
300
Filing cabinet
A database program replaces what piece of office equipment?
300
Spread sheet
What is a database table similar to in appearance?
300
Create tab
What tab do you click to create a form?
300
Because queries can draw their information from multiple tables
Why are queries more powerful than simple search filters you might use to find data within a table?
300
shows you how your report will appear on a printed page
What is print preview?
400
Primary key
A field which has a unique value for each record can be used as a ___.
400
storing data in a data place.
What is a table used for?
400
4
How many layouts can you choose from for a form?
400
a one-table query
What is the simplest query possible?
400
creating reports using fields from multiple tables or queries
What is the report wizard feature used for?
500
50 characters
What is the default size of a text field in a table?
500
double click or right click
How do you change the name of a table in Access?
500
Form style
What feature allows you to give your forms a more attractive appearance?
500
Design view
What view should you use to modify an existing query?
500
select the design tab and locate the themes group
How do you change the theme of a report?
M
e
n
u