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: £150 plus VAT
 

Access 2003 Level2
Excel 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: £150 plus VAT
 

Access 2003 Level3

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.
 

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: £150 plus VAT

 

Access Level1
 

Delivery Method - Tutor Led
Access Level1 Learn the basic skills necessary to begin using Access 2000. They will design and create databases, tables, queries, forms, and reports.

Pre-requisites
Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example, students should be familiar with terms such as computer memory, data files, and program files. Students should also be familiar with the components that make up the PC, including input, output, and storage devices. Students should also be fairly comfortable working in a Windows environment. No prior knowledge of databases or Access is assumed.

Performance-based objectives
Upon successful completion of this course, students will be able to:

  1. Understand database concepts and terminology in Access 2000.

  2. Design and create tables.

  3. Enter and manipulate data in tables.

  4. Use Access queries to select and analyze information in a table.

  5. Create data forms for viewing and inputting data.

  6. Create reports that summarize and group data.

  7. Perform database maintenance procedures.


    8. Course Length: 1day
    Price: £150 plus VAT

Access Level2

Delivery Method = Tutor Led

Access Level2 - 28 July Students will learn how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports. Additionally, students learn how to create data access pages to share data over an intranet or the Internet.

Prerequisites:
Students are required to have a basic understanding of Access 2000 equivalent to the Level 1 course.

Benefits:
Students will learn how to take the guesswork out of creating databases by using data-normalization techniques. They will learn how to take advantage of relational database efficiency to maintain data. In addition, students will be able to save time by controlling data entry and automating tasks. Students will also benefit by becoming familiar with Access features that will enable them to customize forms and reports, and to share data over an intranet or the Internet by creating and using data access pages.

Performance-based objectives
Upon successful completion of this course, students will be able to:

  1. Normalize sample tables by identifying design problems.

  2. Establish relationships between tables by analyzing table relationships and enforcing referential integrity.

  3. Customize table designs by setting field properties to maintain data integrity, by creating a lookup list, and by creating indexes.

  4. Design select queries by using multiple tables to calculate, group, average, and concatenate values and to show top values.

  5. Customize form designs by creating calculated fields, combo boxes, and unbound controls.

  6. Interact with data through a browser by creating and using data access pages.

  7. Customize report designs by grouping, sorting, and summarizing data, and by adding subreports.

  8. Creating a chart in a form or report


    9. Course Length: 1day
    Price: £150 plus VAT