Most organizations
maintain and manage large amounts of information. One of the most
efficient and powerful information management computer applications is
the relational database. Information can be stored, linked, and managed
using a single relational database application and its associated tools.
In this course, you will be introduced to the concept of the relational
database by using the Microsoft® Office Access 2003 relational database
application and its information management tools.
Course Objective: You will be introduced to the features of the Access 2003 application.
Target Student: This course is designed for students who wish to learn the basic operations of the Access 2003 database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications.
Course Content
Lesson 1: An Overview of Access 2003
Learn to: Understand Relational Databases, Examine the Access
Environment, Open the Database Environment, Examine an Access Table
Lesson 2: Managing Data
Learn to : Examine an Access Form, Add and Delete Records, Sort Records,
Display Recordsets, Update Records, Run a Report
Lesson 3: Establishing Table Relationships
Learn to: Identify Table Relationships, Identify Primary and Foreign Keys in the Relationships Window, Work with Subdatasheets
Lesson 4: Querying the Database
Learn to: Create a Select Query, Add Criteria to a Query, Add a
Calculated Field to a Query, Perform a Calculation on a Record Grouping
Lesson 5: Designing Forms
Learn to: Examine Form Design Guidelines, Create a Form Using AutoForm,
Create a Form Using the Form Wizard, Modify the Design of a Form
Lesson 6: Producing Reports
Learn to: Create an AutoReport, Create a Report by Using the Wizard, Examine a Report in Design View, Add a Calculated Field to a Report, Modify the Format Properties of a Control, AutoFormat a Report, Adjust the Width of a Report
Course Length: 1day
Price: £155 plus VAT
As
you begin this course, you should have the basic skills you need to work
with a Microsoft® Office Access 2003 databases. This includes working
with Access tables, relationships, queries, forms, and reports. But thus
far you have been focusing on essential database user skills only. In
this course you will consider how to design and create a new Access
database, how to customize database components, and how to share Access
data with other applications. Course
Objective:
You will design and create a new Access database; improve queries,
forms, and reports; and integrate Microsoft® Office Access 2003 with
other applications.
Target Student: Microsoft® Access 2003: Level 2 is designed for
the student who wishes to learn intermediate-level operations of the
Microsoft® Access program. The Level 2 course is for the individual
whose job responsibilities include creating new databases, tables, and
relationships, as well as working with and revising intermediate-level
queries, forms, and reports. It also introduces the student to
integrating Access data with other applications such as Microsoft® Word
or Excel. This course is also designed for students pursuing the
Microsoft Office Specialist Certification for Access 2003, and it is a
prerequisite to taking more advanced courses in Access 2003.
Course Content
Lesson 1: Planning a Database
Learn to: Design a Relational Database, Identify Database Purpose,
Review Existing Data, Determine Fields, Group Fields into Tables,
Normalize the Data, Designate Primary and Foreign Keys
Lesson 2: Building the Structure of a Database
Learn to: Create a New Database, Create a Table Using a Wizard, Create Tables in Design View, Create Relationships between Tables
Lesson 3: Controlling Data Entry
Learn to: Restrict Data Entry with Field Properties, Create an Input
Mask, Create a Lookup Field
Lesson 4: Finding and Joining Data
Learn to: Find Data with Filters, Create Query Joins, Join Unrelated
Tables, Relate Data Within a Table
Lesson 5: Creating Flexible Queries
Learn to: Set Select Query Properties, Create Parameter Queries, Create
Action Queries
Lesson 6: Improving Your Forms
Learn to: Enhance the Appearance of a Form, Restrict Data Entry in
Forms, Add Command Buttons, Create a Subform
Lesson 7: Customizing Your Reports
Learn to: Organize Report Information, Set Report Control Properties,
Control Report Pagination, Summarize Information, Add a Subreport to an
Existing Report, Create Mailing Labels
Lesson 8: Expanding the Reach of Your Data
Learn to: Publish Access Data as a Word Document, Analyze Access Data in Excel, Export Data to a Text File, Merge Access Data with a Word Document
Course Length: 1day
Price: £155 plus VAT
Your training in and use
of Microsoft® Office Access 2003 has provided you with a solid
foundation in the basic and intermediate skills for working in
Microsoft® Office Access 2003. You're now ready to extend your knowledge
into some of the more specialized and advanced capabilities.
Target Student: This course is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft® Office Access 2003 database program. The Level 3 course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft® Office Specialist Certification for Microsoft® Office Access 2003, and it is a prerequisite to taking more advanced courses in Microsoft® Office Access 2003.
Course Content
Lesson 1: Structuring Existing Data
Learn to: Import Data, Analyze Tables, Create a Junction Table, Improve Table Structure
Lesson 2: Writing Advanced Queries
Learn to:
Create Unmatched and Duplicates Queries, Group and Summarize Records
Using the Criteria Field, Summarize Data with a Crosstab Query, Create a
PivotTable and a PivotChart, Display a Graphical Summary on a Form
Lesson 3: Simplifying Tasks with Macros
Learn to: Create a Macro, Attach a Macro to a Command Button, Restrict
Records Using a Where Condition
Lesson 4: Adding Interaction and Automation with Macros
Learn to: Require Data Entry with a Macro, Display a Message Box with a
Macro, Automate Data Entry
Lesson 5: Making Forms More Effective
Learn to: Change the Display of Data Conditionally, Display a Calendar
on a Form, Organize Information with Tab Pages
Lesson 6: Making Reports More Effective
Learn to: Cancel Printing of a Blank Report, Include a Chart in a
Report, Arrange Data in Columns, Create a Report Snapshot
Lesson 7: Maintaining an Access Database
Learn to: Link Tables to External Data Sources, Back Up a Database, Compact and Repair a Database, Protect a Database with a Password, Determine Object Dependency, Document a Database, Analyze the Performance of a Database
Course Length: 1day
Price: £155 plus VAT