Microsoft Access - some training topics

planning
purpose, needs
users
tasks
structure

interface
ribbons, tabs
Quick Access toolbar
buttons
Layout View
Switchboards
tabbed or overlapping display format

tables
fields, properties
Lookup Wizards
primary, foreign keys
index
sorting
relationships
lookups
default values
required fields
memo fields
orphan records
junction tables
restructuring
joining
query joins
joining unrelated tables
joining tables having no common fields
relating data

data
records
sort, filter
validate
subdatasheets

queries
filtering, criteria
calculations on record groups
flexible queries
Select Queries
query views
Query Design Grid
adding tables
retrieve records based on input criteria
action queries
union queries
subqueries
unmatched, duplicate
Find Duplicates Wizard
crosstab queries
parameter queries
calculated fields
aggregate queries

forms
viewing and adding data
AutoForms
Form Wizard
Quick Form
view styles
data types
constraining, masks
formats
field value lists
restricting data entry
text, combo boxes
Tab Control, Tab Pages
command buttons
parent and sub forms
data summaries
conditional display
controls
filters
graphic user interfaces
exporting
sending via email
ActiveX controls

reports
Report Wizard
Report Design
labels, fields
grouping, sorting
formatting, layout, appearance
lines, images
option buttons, checkboxes
stacked layout
headers, footers
organising information
Keep Together
calculated fields
controls
columns
Running Summaries
expressions
charts
Chart Wizard
PivotTables, PivotCharts
sub reports
as PDF
mailing labels

navigation
design, test user interface
navigation buttons
boxes, labels

importing
text file data
XML data
data from emails
linking
errors
unmatched data

working with other Office programs
analysing in Excel
merging data with Word document

exporting
text files
Excel
Outlook address books
mail merge

macros
conditions for restricting records
validating data
automate data entry
AutoKeys, AutoExec

splitting
Database Splitter
relinking

security
passwords
digital signatures
Trust Centre

sharing
SharePoint lists
import data, export table
SharePoint sites
move, publish database
hyperlinking

maintaining
object dependencies
documenting
analysing performance

printing
Quick Print
preview

Visual Basic

SQL

options
Need training in an Access topic or function that's not listed here?

Just ask.