Access Training for New Users

Course

Online

£ 1,898 VAT inc.

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    2 Days

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

This access course is suited for users who already have a good working knowledge of Access, during your access course you feel confident to be able to design and build relational databases that incorporate macro automation, manipulate data and have the skills to work with and run advanced queries coupled with the knowledge of being able to produce advanced forms and create reports

As many versions of Access are available when enquiring about this access course please let us know which version of Microsoft Access you are using, we are able to train on all versions – 2003 / 2007 / 2010 In addition we are able to provide 10 laptops with 2007/10 access preloaded to make setting up a training course much easier, we only charge a delivery and collection fee for their use.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

The current outline for the access training for advanced users course enables you to:

Have a complete understanding of the higher functions of Access
Learn to automate functions by creating simple and then very advanced macros
Understand advanced querying
Add SQL statements in your queries
Work with objects
Understand the fundamentals of database management
Protect valuable data sources

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
  • SQL
  • Database training
  • PivotTable
  • Modify
  • Working
  • Advanced
  • Forms
  • Designing
  • Automating

Course programme

Course Outline

During this access training course, you learn about:

PivotTables and PivotCharts
  • Create a PivotTable
  • Modify a PivotTable
  • Working with a PivotChart
Creating Advanced Forms
  • Designing a form based on joined tables
  • Automating data entry
  • Grouped control
  • How to improve the user interface
  • Designing subforms
Macros
  • Create and run macros
  • Attach macros to events of database objects
Creating Advanced Macros
  • Create macros to provide user interaction
  • Create macros requiring user decision
  • Use AutoKeys and AutoExec macros
Exploring Access SQL
  • How to identify different clauses in an SQL statement
  • Writing SQL statements
  • Attach an SQL statement to database objects
Integrating the Internet
  • Work with hyperlink fields
  • Work with data access pages
Managing Databases
  • Work with database utilities to optimise resources
  • Secure data by database replication
Security Fundamentals
  • Protect databases

Access Training for New Users

£ 1,898 VAT inc.