Access 2003 Level 2

Objectives

Delegates will be able to:

Identify the many different ways of extracting information from a database using a variety of queries.
Understand the principles around Database design and why it is important to plan and prepare a database before entering any information.
Create forms and reports without having to rely on the wizards.
Use queries to make en masse changes to data.
Follow on Courses

Access Level 3
Related Courses

Access Level 1 ()
Access Level 3 ()
Training Options

Scheduled public courses at one of our training venues
Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
For further information please contact us on 0191 377 8377
What's Included

1 delegate per computer
Telephone and email support
Relaxed refreshment area at our training venues
Lunch and refreshments when training is delivered at our training venue
Comprehensive course manual and exercises
Course Content

Database theory
Database Normalisation - How to design your tables in an efficient manner to avoid data replication, and ensure good database design.
What is a relational database?
Tables
Importing data, from Excel, Access and text files
Linking data from Outlook or Exchange.
Converting an Access database to a previous version.
Customising input masks using your own code, not using the wizard
How to use lookups when designing your fields in a table
Format using format codes, how to ensure consistent data entry.
Indexes, speeding up your database (pros and cons).
Multiple primary keys, setting more than one field as a primary key
Queries
Multiple table queries
Selecting all fields
Parameter queries, supplying the criteria for a query when you run the query
Cross tab query. How to display your data in a succinct format.
Make table query. Make a table from the results of a query.
Update query. Update values in a table using a queryAppend query. Add the results of a query to a table.
Delete query. Delete all the records in a table that are displayed by the query
Relationships in a query and the different types of relationships
Adding and deleting relationships
Printing the relationship
Forms
Creating and modifying forms
Tab order. Changing the order boxes on a form are selected when the tab key is pressed
Adding information into the form header and footer area, e.g. date
Adding information into the page header and footer area, e.g. page number
Adding text to your form i.e. labels and text boxes
Description of the form toolbox
Adding combo and boxes to a form.
Adding option boxes and yes/no boxes to a form
Adding pictures or charts to a form
Using tabs on a form to group information or sub forms.
Sub Forms and multiple sub forms
Changing a forms properties using the property sheet.
Changing the format properties
Command Buttons using the wizard. Adding a close button, next record etc
Reports
Creating reports from scratch
Modifying a report
Grouping. Grouping information together on a report, e.g. grouping sales data by company.
Data Access Pages
Using a data access page to view, store or manipulate data in a database
Creating data access pages in design mode
Pivot Table reports in Data Access Page mode
The "New" Database Window
Creating new Groups and editing others
Customising its reactions to your actions