Access Introduction

Course

Inhouse

£ 535 + VAT

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Inhouse

  • Duration

    1 Day

  • Start date

    Different dates available

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.

Facilities

Location

Start date

Inhouse

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Access
  • Database
  • Database training
  • Design
  • Tables
  • Reports
  • Queries
  • Data
  • Access Environment
  • Database Templates
  • Blank Database
  • Access Options

Course programme

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

Additional information

£450 for one-to-one training£550 for groups of up to 6 people£650 for groups of up to 12 people

Access Introduction

£ 535 + VAT