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

Insight Logo

Microsoft Word Introductory

The course has been designed for first time or recent users of Microsoft Word and is suitable for people who wish to learn the basic skills. This Introductory course is delivered by one of our skilled trainers and is 100% hands-on, with exercises to reinforce the day’s learning.

by Insight [Claim Listing ]
Oregen Computer Training Logo

Microsoft Excel Training

This course is designed for students who have already attended the introductory course or who already have a good working knowledge of Excel basics.

by Oregen Computer Training [Claim Listing ]
London IT Training (LIT) Logo

Office 365 Beginner Training (MS-900)

The newest version of Office 365 is part of Microsoft 365, which also includes Windows 10 and default integrated security applications.

by London IT Training (LIT)
JPL IT Training Limited Logo

Virtual Basic Word Training Course

Our Virtual basic Word training course can be run in all versions of Microsoft.All of our courses are run as full day courses and so run from 9:30am to 4pm.

by JPL IT Training Limited [Claim Listing ]
Escalla Logo

MS Visio Course

During this hands-on session, you will learn how to create flowcharts and cross-functional flowcharts to visualize business processes, and how to create organization charts to display a hierarchy of personnel.

by Escalla [Claim Listing ]

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