MS Access Introduction

If you have a spreadsheet with...

• Many lookups
• Data validation
• Chains of linked workbooks
• Multi-user editing requirement
• Navigation across many tabs
• Speed issues

Then Access may provide a better solution.

It is designed to store structured data and provides tools to input and extract the information safely as well. Once the data is there you can report on it directly or push it out to Excel for analysis.

Our Introduction course covers everything you need to know to get a database up and running and if you already know Excel then Access is even easier to learn.

What will I learn?

• 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