What is a tool used to organize, store, retrieve, and communicate groups of related information.
A Database
100
What are the steps in planning a Database
Determine what information to store in the database
Determine a logical arrangement of tables
Gather all information that will be a part of the database
Decide which information to store in each table
Discuss the database with all users
100
What is the default Font and Size for Access
Calibri, 11
100
What does a form allow a user to do?
Filter data within the form
100
What does a report allow a user to do?
present data in an easy-to-read, professional looking format.
200
What are two ways to open Access
1.Start button programs or 2. Double click the Access Icon on the desktop
200
How long can a field Name be
64 Characters long
200
Can you change the default Font? What can you change?
No, only the Size and width
200
What is the purpose of design view
to provide full access to all of the modifications you can make to the form.
200
What is the quickest and easiest way to create a report?
Use the report tool
300
In what view does a Database open in
Datasheet View
300
How many Data Types are there
9
300
What view can field properties be viewed in?
Table Design View
300
What does a form allow a user to do?
to enter data into various formats of a data entry screen
300
What view will the report open in
Layout view
400
what is another means of viewing information from a table & displaying the information one record at a time.
Form
400
What view must a table be in in order to change data
Datasheet view
400
What can smart tags be used for?
be used to schedule meetings, add contacts to instant messaging, and enable a slew of other conveniences all from within an Access database.
400
What is the design view of a form devoted to?
is devoted to working with the detailed structure of a form.
400
How can a Theme be applied to a report?
The Theme command
500
What is a Report
a means of presenting data from either a table or a query.
500
Name 3 Data Types
Text, Memo, Date/Time, AutoNumber, Number, currency, yes/no, attachment and hyperlink
500
What are the Relationship terms?
One-to-one, One-to-Many, Many-to-Many
500
What can the use of a form do?
increase productivity for data entry.
500
What is a report?
consists of information that is pulled from tables or queries, as well as information that is stored with the report design, such as labels, headings, and graphics.