Access 2007 Level 2
| Date |
Location |
Duration |
Cost |
18 Oct 2010 (Mon)
19 Oct 2010 (Tue) | Washington | 2 | £ 295 |
13 Dec 2010 (Mon)
14 Dec 2010 (Tue) | Washington | 2 | £ 295 |
01 Mar 2011 (Tue)
02 Mar 2011 (Wed) | Washington | 2 | £ 295 |
23 May 2011 (Mon)
24 May 2011 (Tue) | Washington | 2 | £ 295 |
30 Jun 2011 (Thu)
01 Jul 2011 (Fri) | Newcastle | 2 | £ 295 |
15 Aug 2011 (Mon)
16 Aug 2011 (Tue) | Washington | 2 | £ 295 |
Please contact us to discuss private course dates and locations |
Course Overview
This course is aimed at those who have used access from a self-taught basis or have been on the level one course, but now need to know about the more detailed aspects of access. This course will develop further the advantages of multiple table relational databases.
Prerequisites
- This course assumes knowledge of how to create a table, a form based on a table, a simple query and a report using the wizard.
- Delegates should have created a simple one-table database as a minimum, although some knowledge of relationships would be an advantage.
- Delegates should have attended Access 2007 Level 1 or have equivalent knowledge.
Objectives
Follow on Courses
Related Courses
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. Efficient table design to avoid data replication and ensure good database design
What is a relational database?
The benefits of multiple tables
Tables
Importing data, from Excel, Access and text files
Converting an Access 2007 database to a previous version.
Customising input masks using your input mask character code
How to use lookups when designing your fields in a table
Format using format codes
How to help ensure consistent data entry.
Indexes, speeding up your database (pros and cons).
Multiple primary keys, setting more than one field as a primary key.
Relationships between tables.
Adding and deleting relationships
Printing the relationship
Queries
Using more than one table to feed a query
Selecting all fields.
Changing the join type of the relationship between tables of a query
Parameter queries, supplying the criteria for a query when you run the query
Cross tab query. How to display your data in a tabular summary format
Action queries
Make table query. Make a table from the results of a query.
Update query. Update values in a table using a query
Append 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
Forms
Creating and modifying forms without the wizard
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 text to your form i.e. labels and text boxes
Description of the form toolbox
Adding drop list boxes or list boxes to a form.
Adding option boxes and yes/no boxes to a form
Adding pictures or charts to a form
Adding Buttons using the wizard. Adding a close button or a next record button
Sub forms
How to display related information on one screen using sub forms
Creating the sub form then inserting into a main form
Using tabs on a form to group information or sub forms.
Changing a forms properties using the property sheet.
Changing the format properties
Reports
Creating reports from scratch
Modifying a report's display properties
Grouping. Grouping information together on a report, e.g. grouping sales data by company
Adding new fields to carry out calculations on a report
Creating Sub Reports
Inserting Sub Reports into main (parent) reports
Print