|
ADVANCED FORMS:
- Add buttons to
forms to run macros
- Add drop-down look-up
fields to forms
- Change Properties of fields
- Place Calculations in Headers and Footers
-
Work with Layout View to design a form
- Add
Controls to a form
- List Boxes
- Combo
Boxes
- Option Groups
CALCULATIONS (EXPRESSIONS):
Learn different ways
to calculate numbers and summarize data.
-
Calculate Numbers in Tables & Queries
- Add
Calculated Fields (Expressions) in Forms
& Reports
- Summary
Query or Table
EXTERNAL DATA
Import data from Excel, Outlook, or another
Access database. Collect data from e-mail
programs, create e-mail surveys, etc. Attach
file(s) to Access, send XPS Attachments, save
objects as web files, insert hyperlinks.
ADVANCED QUERIES:
-
Multiple Tables (with or
without Joins)
-
Parameters (basic parameters,
multiple parameters, date ranges,
wildcards, etc.)
- Find Duplicates Query
(locate
duplicate records)
- Find Unmatched Query
(locate records in one table that have no
matching record in another table)
-
Append Query (add records from one
table to another)
-
Delete Query (delete records meeting
one or more criteria)
-
Update Query (update records based
on one or more criteria)
-
Cross-Tab Query
- Use
Access Functions in Queries
- Add
Queries in Forms, Reports, and
Macros
ADVANCED REPORTS, PIVOT REPORTS, & PIVOT TABLES:
- Create Mailing
Labels for a Word Mail Merge
- Create Pivot
Tables
-
Create Pivot Charts
- Save
Forms as Reports
SECURITY:
-
Trusted Locations
-
Encrypt /Decrypt (Password
Protect) Database
-
Compile an AACBE Secured
Copy of a Database to
Distribute to Others
MANAGE A DATABASE:
-
Backup
-
Compress
-
Repair
-
Split
-
Use Linked Table Manager
|
