 |
Our course is loaded
with general information on each of these topics, covering the basics and
providing more advanced information for individuals already familiar with
this subject. The course is supported
with numerous tips, examples, and interactive questions to help you
understand this subject and includes a
special "Bookmark" feature so you can learn at your own pace.
TOPICS COVERED
Unit 1: Creating Multiple Table Queries
Creating Select Queries
Sorting a Query on Multiple Fields
Developing AND Queries
Developing OR Queries
Creating Calculated Fields
Building Summary Queries
Creating Crosstab Queries
Modifying Crosstab Queries
Practice
Unit 2: Developing Forms and Subforms
Understanding the Form/Subform Relationship
Creating Forms with Subforms Using the Form Wizard
Creating Subforms Using Queries
Modifying Subforms
Adding Combo Boxes
Adding Option Groups
Adding Command Buttons
Adding Records with a Form/Subform
Practice
Unit 3: Building Complex Reports
Using the Database Wizard
Importing Data
Creating a Report from a Parameter Query
Enhancing Reports
Adding Lines and Rectangles
Using Format Painter and AutoFormats
Inserting an Image
Securing the Database
Practice
Unit 4: Sharing Access Information with Other Office Programs
Examining Access Objects
Examining Relationships Between Tables
Importing Data from Excel
Linking Data with Excel
Creating Hyperlinks
Analyzing Data with Excel
Copying Data to Word
Exporting Data
Practice
Unit 5: Creating Data Access Pages
Understanding the World Wide Web
Using Hyperlink Fields
Creating Pages for Interactive Reporting
Creating Pages for Data Entry
Creating Pages for Data Analysis
Working in Page Design View
Inserting Hyperlinks to Other Pages
Publishing Web Pages to Web Servers
Practice
This self-paced Program is available from any browser, and is accessible
for one full year from date of purchase.
|
Item |
Course |
|
Individual Course Cost |
$30.00 |
| |
 |
Credencia e-Learning courses are designed to
function under the following minimum computer standards. Please be sure
that your computer meets these minimum standards:
- Internet Explorer version 5.5 or higher
- Windows Media Player version 6.4 or higher
- A minimum connection speed of a 56K modem is required,
but higher speed connections are better for viewing.
- Your computer must have the ability to play audio,
with speakers or headset attached
Depending on the speed of your modem connection, the download time may take a few minutes to view the presentation.
|
|
