ADVANCED
Course length: 2 half-day sessions
Who should attend: Anyone responsible for the
setup of a database for others to use
Suggested Background: Access Introduction or equivalent
experience
This course will show
you how to export and import table data to and from other databases or
spreadsheets. You will also create
complex queries that will help manage your data flow and summarize your
information.
Upon completion of this course, you will
be able to:
Personalize a Database
Work with a switchboard manager
Change
the database startup
Export, Import and Link Data
Export to another database and Excel
spreadsheet
Import from another Access database
Import spreadsheet data
Import text
Link
to another Access database
Use Web Capability
Create a hyperlink
Create
a Data Access Pages
Select Data using Queries
Create a parameter query
Understand joins
Create
a multiple table query
Use Query Wizards to Build a Complex Query
Find and remove duplicate records
Find unmatched records
Create
a crosstab query
Modify Data with Action Queries
Create a Make Table query
Create a Delete query
Run an Append query
Create an Update query
Develop Custom Applications
Add Command Buttons to forms
Create Macros