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

London IT Training (LIT) Logo

Office 365 Advanced Training (MO-500)

Microsoft Office 365 has changed the way of using Microsoft Office products. The added features and tools, integrated with Microsoft 365 makes the life of the Microsoft Office users in many ways.

by London IT Training (LIT)
Computeraid Ltd Logo

Microsoft Access

Microsoft Access training is offered by Computeraid Ltd. We can provide training at our facilities, work with satellite centres, deliver training at a client’s training room, provide laptops at a client’s site, set up training centres or deliver online.

by Computeraid Ltd [Claim Listing ]
NILC Training Logo

Microsoft Visio Introduction Training Course

The Introduction to Microsoft Visio training course is designed for students new to working with Microsoft Visio in Windows. Students will learn to create objects of their own, using the drawing tools, as well as being able to automate the charting using external data.

by NILC Training [Claim Listing ]
Eident Logo

Microsoft Visio

Microsoft Visio course is offered by Eident. Eident deliver scheduled and on-demand IT skills training courses

by Eident [Claim Listing ]
West College Scotland Logo

Mastering Microsoft Word (Beginner)

You may already be using Word 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. This course will give you the confidence to explore the many facets of the world's most widely used word processor.

by West College Scotland [Claim Listing ]

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