START
 

Access Introduction

G Com Solutions
Course summary
Length: 1 day
Location: Nationwide
Next available date: Variable depending on group number - Nationwide

Access Introduction

In-house computer training courses

GCom Solutions  - On-Site Computer Training Courses in the UK - One-to-one and group training

This course is designed for beginners and covers: getting started; creating the site navigation; adding a hero image; working with columns; and using device preview.

Suitability - Who should attend?

No particular experience of using Access is required. However, familiarity with carrying out basic computing tasks, such as saving or copying a file, is assumed.

Outcome / Qualification etc.

A G Com Solutions Certificate of Attendance is issued on course completion.

Training Course Content

This course is designed for beginners and covers: access basics; working with tables; working with data; working with queries; creating queries; creating forms; and creating reports.

Access Basics

Understanding Databases, Using Database Templates, Open An Existing Database, The Access Environment, A Look At Tables, A Look At Forms, A Look At Queries, A Look At Reports, Creating A Blank Database, Setting Access Options, Using HelpOn Your Own

Working With Tables

Creating A Table Using Application Parts, Entering Data Into A Table, Adding New Fields To A Table, Creating A Table From Scratch, Setting A Primary Key, Changing Column Width And Row Height, Rearranging Fields, Inserting And Deleting Fields, Changing Field Properties, Designing In Datasheet View

Working With Data

Editing Data, Formatting Table Data, Importing Excel Data Into An Existing Table, Importing A Text File Into A New Table, Selecting And Deleting Records, Sorting Records, Finding And Replacing Data, Filtering Data By Selection, Filtering Data By Form, Using Common Filters, Hiding/Unhiding Columns, Freezing Columns, Rearranging Columns, Displaying Column Totals In A Datasheet

Working With Queries

Working In Query Design View, Creating A Query In Design View, Adding Fields To A Query, Removing Fields From A Query, Saving A Query, Running A Query, Adding Criteria To A Query, Specifying Multiple Criteria, Sorting Data In A Query, Moving Columns In A Query, Using The Query Wizard

Creating Queries

Creating Forms

Using The Form Wizard, Entering Data Into A Form, A Look At Design View, Adding A Field To A Form, Changing Control Properties, Using Layout View, Finding Records In A Form

Creating Reports

Creating A Basic Report, Applying A Theme To A Report, Using The Report Wizard, Report View And Layout View, Modifying Report Setup, Printing Reports, Using The Label Wizard

Expenses

£450 for one-to-one training

£550 for groups of up to 6 people

£650 for groups of up to 12 people

Provider: G Com Solutions

G Com Computer Training Solutions

G COM Solutions Limited - On-Site Computer Training Courses

Whether you need IT training as an IT specialist or as one of the many people who need computer training to improve their skills for career advancement, G Com Solutions courses can help you. Perhaps you need software training to get into...


Read more and show all courses with Provider: G Com Solutions

Request information - obligation free

Fill out your details to find out more about Access Introduction.

  Contact the provider

  Get more information

  Register your interest

Errors
Optional
Optional
Optional

Contact information for G Com Solutions

G Com Solutions


Kemp House, City Road
EC1V 2NX London

 Show phone number
gcomsolutions.co.uk
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Request information

Find out more about this Access Introduction course - simply fill out your details:

 
Find more courses here

 
Have your say:

apprenticeships