Microsoft Access 2010 Introduction Training Course

Our Microsoft Access 2010 Introduction course will equip you with the skills to create your own databases to manage your information more effectively. This is a two-day course suitable for new or inexperienced Microsoft Access 2010 users who need to build a relational Access database.

Microsoft Access 2010 Introduction Training Course Content - Duration 2 days

Module 1 – Overview of Relational Databases
What is a database?
What is a relational database?

Module 2 - Screen Layout
Overview of Ribbon and the Office Button
Understanding tabs, groups and commands
Using contextual tabs
Customize Ribbon
Add custom tabs and groups
Export a customized ribbon
Backstage View

Module 3 – Access Objects
Tables, Forms, Queries, Reports, Macros and
Modules

Module 4 - Tables
Creating a table in design view
Table structure: Field names and sizes
Data types
Field properties
Inserting fields
Look-up Lists
Indexes
Setting a Primary Key

Module 5 – Editing Data
Selecting fields and records
Adding and deleting records
Useful shortcut keys
Finding data
Find and replace

Module 6 – Relating Tables
Overview: Why relate tables?
Types or relationship
One-to-one
One-to-many
Linking fields
The relationship window
Referential Integrity

Module 7 - Filters
Filtering in tables, Filter by selection
Exporting filtered data

Module 8 - Queries
Creating select queries
The query grid
Query criteria: Wild cards, comparison and logical operators
Summarising data in queries
Aggregate functions
Calculations in queries
Querying multiple tables
Join properties

Module 9 – Forms
Using an existing form
The form screen
Record navigation, Adding records
Creating a form using AutoForm
The form wizard, Mainform and Subform
Designing a form: labels and control sources
Selecting and moving, Resizing controls
Formatting controls, Using the toolbox
Conditional Formatting

Module 10 - Reports
Creating a report using the report wizard
Report bands, Designing reports
Creating and formatting controls
Grouping in reports, Calculating totals
Viewing a report in print preview
Printing reports

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk

Premier's London Training Centre
42 New Broad Street, EC2

How to find us

Premier's most popular courses:

Excel VBA Training
Microsoft Project Training
Prince2 Practitioner
Excel Advanced Training
Sharepoint Designer
Visio Flowcharting