Access 2007 Level 1

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 feel at ease performing tasks such as arranging, sizing and switching between Windows.
• Experience of sorting and filtering data in Excel would be advantageous but is not a necessity.
• Previous use of a mouse is assumed on this course.
  

Objectives

Delegates will be able to :

• Create, Save and Open existing databases on their systems.
• Understand the principles around Database design and why it is important to plan and prepare a database before entering any information.
• Explain the advantages of using different data types within a database to change the way data can be input.
• Create a form (on the pc) for users to enter data more easily.
• Access information from a database by creating and saving queries within a database.
• Produce accurate, informative and well presented formal reports for presentational purposes.

Follow on Courses

• Access 2007 Level 2
• Access 2007 Level 3

Training Options

• Bespoke course (a 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
• Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
• Scheduled public course at one of our training venues

Whats Included

• 12 Months telephone and email support
• Comprehensive colour course manual and exercises
• Use of a Modern Training suite with 19 inch flat screen monitors
• 1 delegate per computer
• Relaxed refreshment area at our training room
• Lunch (When at our training venue)
• Refreshments (When at our training venue)

Course Content
Database theory

• Explanation of the components that make up a database
• Fields and columns
• Records
• What is a relational database?
• Creating a database using the Database Wizards

Tables

• Creating a single table database
• Using the different data types and field properties to manage data entry
• Adding an input mask using the wizard
• The importance of the 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
• Extracting information from a database using queries
• Creating a query from a single table
• Adding criteria to filter data from a table
• Sorting the results of a query
• Hiding fields in a query
• Producing totals using a query
• Producing calculations using a query
• Where is the data in a query stored?
• Saving and running queries

Forms

• Creating a form using the wizard
• Viewing and changing data in a database using forms
• Modifying a form: changing the colours and layout
• Creating columned or tabular forms - best practice for each

Reports

• Extracting information and presenting it in a readable format
• Creating reports from your database using the Report Wizard
• Portrait and landscape layout
• Editing the layout of a report once created
• Printing reports

Relationships

• Creating 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
• Creating a form that refers to a query based on 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