 |
Queries |
 |
| |
|
|
group records in a query |
|
summarise and total fields |
|
formulas in queries |
|
date range queries |
|
format calculated fields |
|
modify existing queries |
|
append / update queries |
|
'create table' queries |
|
building expressions |
|
functions using expression builder |
|
apply advanced filters |
|
building related queries |
 |
|
 |
|
Reports |
|
|
|
|
|
change design & format of report |
|
change orientation |
|
consolidate format commands |
|
create professional reports |
|
page headers & footers |
|
report headers & footers |
| |
|
Tables |
|
|
|
|
|
correctly relating tables |
|
linking tables |
|
change field position |
|
more data properties |
|
freezing / unfreezing columns |
|
spellcheck and proofreading |
| |
|
|
|
Printing
in Access |
|
| |
|
|
|
how to print |
|
selecting your printer |
|
setting default printer |
|
specifying amount of copies |
|
print preview |
|
printing reports |
|
|
|
|
Forms |
|
| |
|
|
|
filtering with forms |
|
lookup fields |
|
combo boxes |
|
lists |
|
tabs |
|
command buttons |
|
calculations on forms |
|
spacing fields evenly |
|
formatting controls |
|
|
|
|
Databases |
|
| |
|
|
|
set a database password |
|
sort multiple database fields |
|
reverse & remove a sort |
|
understand events |
|
referential integrity |
|
cascade settings |
|
import data |
|
import excel files |
|
create lookup data |
|
more on relationships |
|
|
|
|
Word
PowerPoint
Excel
Access
Outlook
