Lesson One
Including: The
terminology used in an Access database, starting
the Access 2010 program,
opening an
existing sample database, opening a table,
query, form and report, entering a new record,
finding records, sorting records, printing a
report, closing a database
Lesson Two
Including:
planning and design, relationships, design view,
defining fields, data types and properties,
creating a new blank database, creating tables,
entering data using datasheet view, re-sizing
columns, using the lookup wizard
Lesson Three
Including:
defining relationships, creating a table using
the datasheet view, formatting the datasheet,
modifying the table design, using the input mask
wizard, creating a database using a template,
renaming an object
Lesson Four
Including:
editing data in form and datasheet views,
adding new records, using print preview,
changing page
orientation, printing a datasheet, enforcing
referential integrity in a relationship,
creating a relationship report, creating a form
using the form tool, working with controls in
form design, using themes, modifying properties
in a form
Lesson Five
Including:
Using advanced sort, using filter by form,
importing a table from an external database
using a junction
table to resolve a many to many relationship,
defining a composite (primary) key, adding a new
field to a form, using a calculated control on a
form, creating a multi-value field, creating an
attachment field, creating a form using the form
wizard, adding a calculated field to a table
Lesson Six
Including:
using query wizard, setting sort criteria, using
‘or’ and ‘and’ in queries, using expressions to
set criteria, creating different types of
queries, creating and naming a calculated field
in a query,
using aggregate
functions
Lesson Seven
Including:
adding a field with data validation in a table,
creating a form with subform, entering data
using a form/subform combination, creating a
split form, creating a basic report, using the
report wizard,
creating and
modifying the design of a report, using the
concatenate expression, inserting a logo to a
report, adding a subreport to an existing report
Lesson Eight
Including:
exporting an html document, understanding object
dependencies, importing an excel spreadsheet
into a table, exporting a spreadsheet, importing
a text file into a table, using the analyze
table function, using the analyze performance
function, using the database documenter
Lesson Nine
Including:
adding a chart to a form, modifying a chart in a
form, creating a pivot table,
creating a pivot
chart, changing the tab order in a form,
displaying the current date and time in a form,
applying conditional formatting to a field,
creating a navigation form, customising the
ribbon
Lesson Ten
Including:
deselecting the automatic switchboard option,
creating a macro, adding a control button to a
form, backing up a database, viewing database
properties, compacting and repairing a database,
encrypting a
database using a password, saving the database
as a previous version, splitting a database,
creating an application part
ACCESS 2010
