For new users of Access who have little-to-no experience
with relational databases, this course will provide skills
necessary to create a database and enter, find, and report on
the data it contains
PREREQUISITES:
Proficiency in Windows operating systems
Click for
detailed outline:
Lesson 1: An Overview of Access 2003
Lesson 2: Managing Data
Lesson 3: Establishing Table Relationships
Lesson 4: Querying the Database
Lesson 5: Designing Forms
Lesson 6: Producing Reports
Access 2003 -
Level 2
$195
1 day (8 hours)
For those who have the basic skills using Access and want to
learn how to enhance database designs by using the principals of
table relationships & referential integrity, integrate data with
other applications, modify a table design to control data entry,
find data with filters & queries, customize forms & reports, and
create data access pages
PREREQUISITES: Access
2003 - Level 1 or equivalent knowledge
Click for
detailed outline:
Lesson 1: Planning a Database
Lesson 2: Building the Structure of the Database
Lesson 3: Controlling Data Entry
Lesson 4: Finding and Joining Data
Lesson 5: Creating Flexible Queries
Lesson 6: Improving Your Forms
Lesson 7: Customizing Your Reports
Lesson 8: Expanding the Reach of Your Data
Access 2003 -
Level 3
$195
1 day (8 hours)
For those who want to expand their knowledge and abilities
with Access into some of the more specialized and advanced
capabilities, such as working with improperly structured data
(normalization), perform summary operations on data, create
macros to automate tasks, enhance forms & reports, and use
Access in other Microsoft Office applications
PREREQUISITES:
Access 2003 - Level 2 or equivalent knowledge
Click for
detailed outline:
Lesson 1: Structuring Existing Data
Lesson 2: Writing Advanced Queries
Lesson 3: Simplifying Tasks with Macros
Lesson 4: Adding Interaction and Automation with
Macros
Lesson 5: Making Forms More Effective
Lesson 6: Making Reports More Effective
Lesson 7: Maintaining an Access Database
Access 2003 -
Level 4
$195
1 day (8 hours)
For those who are ready to go beyond the user level to the
administrator level, this course goes into how to create and
implement switchboard forms, develop data access pages that
include advanced controls, protect that information using
security protocols, and make your data more accessible and
portable
PREREQUISITES:
Access 2003 - Level 3 or equivalent knowledge
Click for
detailed outline:
Lesson 1: Making Your Data Available on the Web
Lesson 2: Developing a Data Access Page in Design
View
Lesson 3: Integrating Access into Your Business
Lesson 4: Automating a Business Process with VBA
Lesson 5: Creating a Switchboard and Setting the
Startup Options
