MS Access Introduction

by Jarrold Training Claim Listing

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.

£394.98

Contact the Institutes

Fill this form

Advertisement

Jarrold Training Logo

img Duration

2 Days

Course Details

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
  • London Branch

    Knowledge Train 20 Old Bailey, London

Check out more MS Access courses in UK

London IT Training (LIT) Logo

Office 365 Intermediate Training (MS-600)

As you work in Office 365, you will find it easier to test your documents with others, no matter wherever you are working.

by London IT Training (LIT)
Acuity Training Ltd Logo

Microsoft Excel Training

Master the basics of Microsoft Excel on our 1-day Excel Introduction training course. Our friendly, certified Excel trainers will have you confidently using Excel in no time. A complete beginners’ Excel course that covers all of the basics.

by Acuity Training Ltd [Claim Listing ]
Oregen Computer Training Logo

Microsoft Word

This one day course is a comprehensive fast paced introduction to Word and covers all the features need to layout standard business documents in a professional way. Designed for the student who is already using Word or has attended the Introductory course and would like to expand their knowledge.

by Oregen Computer Training [Claim Listing ]
West College Scotland Logo

Mastering Microsoft Excel (Beginner)

You may already be using Excel but at a fairly basic level. It was assumed you already knew how it works so you've never had any training to structure your tacit knowledge.

by West College Scotland [Claim Listing ]
Elliott Training UK Logo

Microsoft Powerpoint – Full Course

On successful completion of the course, delegates will be able to quickly create high-impact, dynamic presentations, while integrating workflow.  

by Elliott Training UK [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy