Access 2007 Level 1
| Date |
Location |
Duration |
Cost |
14 Apr 2010 (Wed)
15 Apr 2010 (Thu) | Washington | 2 | £ 295 |
Course Overview
This course enables delegates to progress from the one level databases associated with holding data in excel, to multiple table relational databases, covering all the basics including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.
Prerequisites
- Delegates should have some working knowledge of Windows or should have completed the Introduction to Windows course. Delegates should be able to arrange, size and switch between windows. Previous use of a mouse is assumed on this course.
- Experience of sorting and filtering data in Excel would be advantageous but is not a necessity.
Objectives
Follow on Courses
Training Options
- Scheduled public courses at one of our training venues - Durham, Newcastle or Washington
- 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 room
- Lunch and refreshments when training is delivered at our training venue
- Comprehensive course manual and exercises
Course Content
Database theory
Explanation of the components that make up a database
What is field/column
What is a record
What is a relational database?
Creating a database using the database wizards.
Tables
How to create a single table database.
Using the different data types and field properties to manage data entry
Adding an input mask using the wizard
Why have a Primary key.
Entering data into the new table
Sorting the data in this table
Deleting records from the table
Editing Records in the table
Queries
Queries in a database- advantages of using queries.
How to extract information from your database using queries.
Creating a query from single table
Adding criteria to filter data from a table
How to sort the results of a query.
How to hide fields in a query.
How to produce totals using a query.
How to produce calculations using queries.
Where is the data in a query stored?
Saving and running queries.
Forms
How to create a form using the wizard.
View/change data in your database using forms.
How to modify a form: change the colours and change the layout.
Creating column or tabular forms – best practice for each.
Reports
How to extract information and present it in a readable format
Creating reports from your database using the report Wizard
Portrait or Landscape layout
Editing the layout of a Report once created
Printing Reports
Relationships
How to create a multi-table database, (Relational database)
Creating links between tables.
Linking Primary Keys to Foreign Keys
Working with referential integrity and preventing data in one table being deleted when it has links to data in another table.
Viewing and editing related data in a sub datasheet.
Creating a query that extracts data from more than one table at once
How to create a form that refers to a query based two or more tables.
Generating a report based on more than one table
Database normalisation
Designing tables in an efficient form to minimise data replication and ensure good database design
Print
Enquire Now