Show:
lesson 1
lesson2
lesson 3
lesson 4
lesson 5
100
is a tool used to organize, store, retrieve, and communicate groups of related information.
What is a database ?
100
Table structure information must be accurate in order to ensure the table works properly
What is Accuracy ?
100
to enhance the appearance of the table.
Add cell special effects _________________?
100
The use of a form can increase productivity for data entry ,Forms allow the user to filter data within the form.
What is a form ?
100
a page break in the report.
The dotted lines on the report indicate _____________?
200
A method of extracting specific data from a table.
What is a Query ?
200
you and assigns it a field name of "ID" and the AutoNumber data type.
When you create a new table in Datasheet view, Access automatically creates a primary key for ___________________________?
200
the cells, columns, and rows in a table can be modified
The default size of _____________________ ?
200
that perform various task
Forms often contain controls _______________?
200
layout view
A report opens in ?
300
database
open a ___________ using recent command
300
A primary key consist of one or more fields that uniquely indentify each recordthat you store in a stable.
What is a primary key ?
300
field
Each field in a table has properties that are dependent upon the data type of ?
300
how other users interact with the data in the database
Forms also allow you to control __________?
300
print preview
The finished report will be displayed _________?
400
using open from File Tab
How do you open exsiting database?
400
contians valeus that correspond to values in the primary key of another table.
What is a foreign key ?
400
left most positon on the data sheet.
The fields that you freeze move to the ?
400
of a database through the use of a human data-input
Direct input of data in the appropriate date fields _____________________?
400
report
A theme may be applied too, what type of form ?
500
quick Acess toolbar, group,tab, contextual command tab,navigation pane, field sepreator,font list arrow,font list arrow, field seprator.
What are the parts of the Access Ribbon?
500
orgainze the table for data entry
Fields in a table can be moved to better ____________ ?
500
stores multiple values per record
You can create a lookup field that __________ ?
500
included in the form when the Form Tool ,is selected and the form opens in Layout view.
All fields in the table are automatically _______________ ?
500
Desgin ribbion
Themes command on the Report Layout Tools is located in what ribbion ?