Microsoft Access Foundation

by Jemco IT Training Claim Listing

Delegates should have attended a Windows course or have been using Windows for a reasonable length of time. Some typing skill would be an advantage.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Jemco IT Training Logo

img Duration

2 Days

Course Details

Delegates should have attended a Windows course or have been using Windows for a reasonable length of time. Some typing skill would be an advantage.

On successful completion of the course delegates will be able to Create and Maintain Access Databases and Create Queries and Reports. To gain a good understanding of the capabilities of the program.

 

Course Content

Lesson 1: Overview Of Database Basics

  • Adding Data To A Database
  • Getting The Best View Of Your Data
  • Saving Time With Forms
  • Finding Information
  • Printing Existing Reports
  • Database Overview- Practice Exercise                                     

Lesson 2: Tables: Creating And Importing

  • Creating New Tables With The Table Wizard
  • Using Design View To Create A New Table
  • Getting External Data
  • Understanding Relationship
  • Tables/Relationships – Practice Exercise                                  

Lesson 3: Retrieving Information From Your Database

  • Creating And Saving A Query
  • Parameter Queries
  • Summarising Data In A Query
  • Changing The Query Type
  • Crosstab Query
  • Viewing A Crosstab Query In Design View
  • Finding Unmatched Records
  • Creating A Report From A Parameter Query
  • Some Commonly Used Query Criteria
  • Queries – Practice Exercise                                                      

Lesson 4: Designing Your Forms

  • The Form Design Window
  • Creating A New Form
  • Using Forms And Subforms
  • Using Command Buttons
  • Forms – Practice Exercise
  • Glasgow Branch

    Technology House, 9 Newton Pl, Glasgow

Check out more MS Access courses in UK

Elliott Training UK Logo

Microsoft Visio 2016 – Intermediate

In this course, you’ll learn intermediate skills using Microsoft Office Visio Professional, including creating organisational charts, network diagrams, customised charts and graphs, and cross-functional flowcharts.

by Elliott Training UK [Claim Listing ]
Training Wales Logo

Beginner's Excel

In this beginner’s course, you will learn the fundamentals and basic concepts of Microsoft Excel. This will allow you to

by Training Wales [Claim Listing ]
Storm Training & Solutions Logo

MS Access Training

Microsoft Access is a powerful database application which can help you to store and track just about any kind of information, such as inventory, contacts, or business processes.  

by Storm Training & Solutions [Claim Listing ]
Impact IT Training Logo

MCEAE Office 365

Microsoft office 365 certification demonstrates knowledge and skills in working with Microsoft Office 365 and validates ability to support end users and maintain systems and mobile devices that run Office 365.

by Impact IT Training [Claim Listing ]
Prospect IT Training Logo

Microsoft Excel Training

It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

by Prospect IT Training [Claim Listing ]

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