Access 2007 / 2010 Level 1
Course Type
Scheduled:
| Date |
Location |
Duration |
Cost |
26 Jul 2012 (Thu)
27 Jul 2012 (Fri) | Washington | 2 | £ 295 |
04 Sep 2012 (Tue)
05 Sep 2012 (Wed) | Washington | 2 | £ 295 |
06 Nov 2012 (Tue)
07 Nov 2012 (Wed) | Washington | 2 | £ 295 |
| All prices exclude VAT |
|
Private
:
| This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice. |
Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.
You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.
We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.
Please contact us to discuss this further on 0191 377 8377.
Course Overview
This course enables delegates to progress from the one level databases associated with holding data in Microsoft 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.
- Experience of sorting and filtering data in Microsoft Excel would be advantageous but is not a necessity.
Objectives
Other courses in this series: 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
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
Microsoft and Microsoft Access are Registered Trademarks
Building and Managing databases with Access, introduction courses to Microsoft Access. Courses in North East England, Washington, Durham, Newcastle. Relational database management. Build and manage your relational database. Access training London, Access courses London, Access training courses Durham, microsoft Access Gateshead, Microsoft Database courses Gateshead, Access courses Leeds. Business to business Access courses Liverpool.
Accessibility: 
Enquire Online 
Special Offers 
| Join us on Facebook or
| 
FAQs
