Our range of one-day IT user courses are designed to give delegates the skills they need to increase productivity, and develop their role within the company. These include generic skills, such as word processing and spreadsheets, as well as more specialised skills for employees in specific roles, such as web design and project management.

Access 2003 Level1

Excel Level1Most 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
 

Access 2003 Level2

Access Level1As 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
 

Access 2003 Level3

Access Level1Your 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.
 

Course Objective: You will create complex Access databases using forms, reports, and macros.

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