Microsoft Access 2007 Training Course Beginners
Level: Beginner
Date: 28th March 2012
Duration: 1 Day
Venue: Cambourne (Near Cambridge) Computer Tutoring Venue
Price: £200.00 + VAT Includes:
- 1 Day's Interactive Training
- 1 Months Post Training Support
- Comprehensive Manual
- Lunch
In this hands-on course, you will learn the basic operations of the Microsoft Access Database program. You will explore how it can help you to manage your day-to-day responsibilities as well as learning about the advantages that using a relational database program can bring to your business processes. The course will include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database.
Microsoft Access 2007 Training Course (Beginners) Outline -
- Exploring the Access Environment
- Examine Database Concepts
- Explore the User Interface
- Explore the Ribbon
- Customize the Access Environment
- Obtain Help
- Use an Existing Access Database
- Designing a Database
- Describe the Relational Database Design Process
- Define Database Purpose
- Review Existing Data
- Determine Fields
- Group Fields into Tables
- Normalize Data
- Designate Primary and Foreign Keys
- Determine Table Relationships
- Building a Database
- Create a New Database
- Create a Table
- Manage Tables
- Create a Table Relationship
- Managing Data in a Table
- Modify Table Data
- Sort Records
- Work with Subdatasheets
- Querying a Database
- Filter Records
- Create a Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
- Designing Forms
- View Data Using an Access Form
- Create a Form
- Create a Form Using the Form Wizard
- Modify the Design of a Form
- Generating Reports
- View an Access Report
- Create a Report
- Create a Report Using the Report Wizard
- Add a Custom Calculated Field to a Report
- Format the Controls in a Report
- Apply an AutoFormat to a Report
- Prepare a Report for Print
Course Duration: 1 Day
Why use Access instead of Excel? What benefits are there? If you're looking for a course to get to grips with the basics of a database then this is the one for you!
You may also be interested in:
Microsoft Access 2007 Training Course- Intermediate
Microsoft Access 2007 Training Course- Advanced
Microsoft Access 2007 Level 4 Training Course- Advanced
To see more details as to our Training Venues click one of the links below: Cambridge | Birmingham | Milton Keynes | Norwich | Peterborough Luton | Ipswich | Brentwood | Northampton | Leicester |