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

Stoke on Trent College Logo

Intermediate Microsoft Excel

Intermediate Microsoft Excel course is offered by Intermediate Microsoft Excel.Find a courses that match your interests. A variety of courses ranging from full, part - time and online offerings for you to choose from.

by Stoke on Trent College [Claim Listing ]
European Centre of Technology Logo

MS Excel Foundation

This course provides a solid foundation of Microsoft Excel skills, to improve user efficiency in Excel, especially for those who are self-taught or unfamiliar with the Programme.

by European Centre of Technology [Claim Listing ]
Dynamic Business Services Ltd Logo

Microsoft Word

This one day course takes you thought the basics of using this feature full program as well as teaching you about word processing.

by Dynamic Business Services Ltd [Claim Listing ]
Acuity Training Logo

Microsoft Word Training

Learn how to produce stunning documents quickly with Microsoft Word's powerful tools.

by Acuity Training
  • Price
  • Start Date
  • Duration
Dynamic Business Services Ltd Logo

Microsoft Word

This one day course takes you thought the basics of using this feature full program as well as teaching you about word processing.

by Dynamic Business Services Ltd [Claim Listing ]

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