About Microsoft Access Introduction • 1
Microsoft Access Database
Microsoft Access is a desktop application that can be configured to meet most business needs. It has many benefits over Excel functionality but needs to configured correctly to get the best results. The course will cover the basic operations of an Access database program and the advantages of using a relational database over and Excel spreadsheet. The course is informal but structured, and you will be encouraged to ask questions throughout.
Is this course for you?
You want to learn the basic functionality of an Access database including creating and editing new tables, relationships, forms, queries and reports and inputting and editing data. The course will provide a thorough understanding of detailed elements plus best practice techniques.
A typical Access course
There are usually between 3 and 6 delegates on the course, all from different companies. Some delegates have used Access before but have had no formal training. Others have not used Access but want to understand the differences, advantages and disadvantages between Access and Excel. We’ll have a 15 minute break in the morning and afternoon and approximately 45 minutes for lunch. Database(s) created on the course will be sent to you on completion for your reference.
- Lunch and Refreshments – Lunch at Caffe Dallucci (Whiteley only)
- Microsoft Training Manual
- Post course training downloads
- Certificate on completion
- Post course support relating to course content
Microsoft Word and Excel discounted courses
Microsoft Access resources
Microsoft Access shortcuts
Aim & Objectives
- To create and edit a simple Microsoft Access database.
By the end of this level you will be able to:
Examine the Microsoft Access database application
Manage data in an Access database
Create and edit tables and relationships
Create various types of Query to interrogate data
Design forms for different uses
Create and modify reports and link them to Queries
Access Database (Get to know Access)
Understand Relational Databases – Examine the Access Environment – Open the Database Environment – Examine Access Tables
Data (Input and edit data using Forms)
Examine an Access Form – Add and Delete Records – Sort Records – Display Recordsets – Update Records – Run a Report
Table Relationships (Critical to your database)
Identify Table Relationships – Identify Primary and Foreign Keys in the Relationships Window – Work with Subdatasheets
Queries (Interrogate your data with questions)
Create a Select Query – Add Criteria to a Query – Add a Calculated Field to a Query – Perform a Calculation on a Record Grouping
Forms (Input and view your data)
Examine Form Design Guidelines – Create a Form using AutoForm – Create a Form using the Form Wizard – Modify the Design of a Form
Reports (Output from your Query)
Create an AutoReport – Create a Report by using the Wizard – Examine a Report in Design View – Add a Calculated Field to a Report – Modify the Format Properties of a Control – AutoFormat a Report – Adjust the Width of a Report
Your trainer has almost 20 years experience providing training and consultancy of Microsoft Access databases.