If you're struggling with storing, retrieving or reporting on data in spreadsheets then Access could make your life easier.

You don't need to know anything about databases to attend this course. However, most people who attend already use Excel to a basic/intermediate level and this definitely makes learning Access more straightforward.

• Creating a Database - Planning your tables to store the data you need is an essential first step
• Creating Forms - For inputting and retrieving information inc. validation, search, sort and filter functionality
• Controls - Drop-downs and option buttons, just like on web forms for quicker and more accurate data entry
• Relating Tables - Efficient data storage with lookups built-in
• Queries - Stored questions you ask of your data, like how many people attended Access courses last year
• Reports - Summary calculations, headers, footers and flexible formatting for print or on-screen viewing
• Office Integration - Access links very nicely with Excel for analysis and Word for mail merge

Course Introduction

• Starting and exiting Access
• Using the ribbon interface
• The database window and navigation pane
• Accessing help

Creating a Database

• Different database components
• Database concepts & planning
• Designing & creating a database

Creating Tables

• Field names & data types
• Setting the field properties
• Building indexes
• Setting the primary key
• Saving a table
• Changing the table design
• Import from Excel

Datasheet View

• Using datasheet view
• Changing datasheet view

Creating Forms

• Creating a Form
• Using Form Wizard
• Working with records:
• Adding, finding, editing, deleting and sorting

Enhancing a Form

• Form views
• Selecting controls
• Moving controls
• Resizing controls
• Inserting controls
• Deleting controls
• Changing the tab order
• Changing the control label text
• Formatting controls

Adding Controls

• Adding calculations to forms
• Inserting text onto the form
• Adding rectangles & lines
• Inserting pictures
• Using Option groups
• Using Combo boxes
• Using List boxes

Relating Tables

• Relational concepts & rules
• Relating tables
• Setting referential integrity
• Using forms with linked tables
• Using a Combo box on a form to lookup data from another table

Select Queries

• Select the fields
• Setting the criteria
• Sorting the records
• Hiding fields
• Using queries with linked tables
• Using calculated fields in queries
• Creating a parameter query

Reports

• Using Report Wizard
• Creating a tabular report
• Report view
• Report filters and totals
• Print preview
• Printing a report

Enhancing a Report

• Report sections
• Applying enhancements
• Controls & calculations

Other Reports

• Grouping & summary reports
• Using reports with linked tables
• Using reports with queries
• Producing mailing labels
• Merging with Word
• Export to Excel
• Export to PDF and XPS

The course runs from 9:30am through to 4:30pm.

You will learn in a relaxed environment with a small group of people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.

Included with your course
We provide the following with online and training centre delivered courses.

• Course notes
• Certificate of attendance
• 90 days post course support

Online Delivery
A link to the online training platform will be sent before the course, simply click the link and follow the instructions.

• See Virtual / Remote training information for more details
• Contact us if you'd like to test the platform before the morning of the course
• You can be located anywhere in the world with an internet connection and your computer

Our Training Centres
For training courses run at one of our training centres we include.

• Free onsite parking
• Lunch and refreshments
• Notepad, pen and Polos

Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.

• Access Intermediate
• Access Advanced
• Visual Basic for Access