 |
Navigating
the MSAccess screen |
 |
 |
|
 |
layouts & toolbars |
|
introducing objects |
|
displaying the task pane |
| |
|
Forms |
|
| |
|
|
|
creating forms using wizard |
|
basing forms on queries |
|
basing forms on tables |
|
forms with linked sub-forms |
|
adjusting form's design |
|
bound vs unbound fields |
|
headers & footers |
|
adding graphics |
|
add/delete/resize form objects |
|
|
|
|
Queries |
|
| |
|
|
|
create query using design view |
|
create query using wizard |
|
basing queries on tables |
|
basing queries on queries |
|
sorting a query |
|
show / hide fields |
|
adding criteria |
|
parameter queries |
|
using dates in queries |
|
calculations in queries |
|
formatting fields in queries |
|
|
|
|
Reports |
|
|
|
|
|
create report using wizard |
|
create report based on query |
|
create multiple table reports |
|
design view |
|
layout view |
|
format fields |
|
align fields |
|
add a field to an existing report |
|
move/resize fields |
| |
|
Databases |
|
| |
|
|
|
create a database using wizard |
|
create a database manually |
|
create a database via template |
|
save a database |
|
open an existing database |
|
exit msaccess correctly |
|
|
|
|
|
|
Database
Specifics & Definitions |
|
| |
|
|
|
what is a record? |
|
what is a field? |
|
what is a data? |
|
what is a database? |
|
what is a table? |
|
what is a form? |
|
what is a report? |
|
what is a query? |
|
|
|
|
Tables |
|
|
|
|
|
create table using wizard |
|
create table using design view |
|
create table by entering data |
|
design view |
|
datasheet view |
|
import table |
|
save table |
|
add a new field |
|
delete a field |
|
rename a field |
|
field size |
|
format |
|
input mask |
|
caption |
|
default value |
|
validation |
|
lookup pane |
|
primary key |
| |
|
Printing
in Access |
|
| |
|
|
|
how to print |
|
selecting your printer |
|
setting default printer |
|
specifying amount of copies |
|
print preview |
|
printing reports |
|
|
|
|
MSAcess
Help |
|
|
|
|
|
maximising your search ability |
|
online help |
|
indexed help |
|
tutorial help |
|
office assistant |
| |
|
Tools |
|
|
|
|
|
find and replace records |
|
relationships explained |
|
sort data |
| |
|
Word
PowerPoint
Excel
Access
Outlook
