Microsoft Access Developer (Level 3) 2003 2007 2010 2013 2016 & 365

Base2 Training Limited

Training

In Newcastle Upon Tyne

£ 495 VAT exempt

The best Access courses

See all

See all

Description

  • Type

    Training

  • Level

    Advanced

  • Location

    Newcastle upon tyne

  • Duration

    2 Days

  • Start date

    Different dates available

Microsoft Access Developer (Level 3) comprises of 2 days training wherein participants will learn how to be able to produce a database which could be used by people with no Microsoft Access knowledge.

Important information

Documents

  • Course content

Facilities

Location

Start date

Newcastle Upon Tyne (Tyne and Wear)
See map
The Quadrus Centre, Woodstock Way, Boldon, NE35 9PF

Start date

Different dates availableEnrolment now open

About this course

To enable participants to produce a database.

This course is suitable for participants who are familiar with the topics covered in Microsoft Access Intermediate (Level 2) course.

Some experience in using/creating a database would be beneficial.

Certificate of participation can be obtained if required.

On receiving your request we will contact you to explain course content, including course dates and payment options.

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

  • Microsoft Access
  • Access
  • Database
  • Database training
  • Menu System
  • Database Utilities
  • Macros
  • Modules
  • Dynamic Queries
  • Database Splitter

Teachers and trainers (1)

Chris Edmondson

Chris Edmondson

IT Trainer

Course programme

Microsoft Access Developer

1 Introduction
· Basic Concepts
· The Training Database Project.

2 Tables
· Normalising the Data
· Naming Conventions
· Relationships between Tables

3 Forms
· Using the Form Wizard
· Setting Form Properties
· Setting Control Properties
· Importing Microsoft Excel data
· Creating a Main Form/Sub Form

4 Creating a Menu System
· Designing a Menu Form
· Writing a Macro for the Menu
· Returning to the Menu
· The Startup dialog box

5 Database Utilities
· Compact and Repair
· Database Splitter
· Linked Table Manager
· Converting a Database

6 Security
· What is a Workgroup
· Users and Groups
· Permissions
· Activate the Logon Procedure

7 Queries and Reports
· Multi-Table Queries
· Using the Report Wizard
· Working in Design View
· Adding Reports to the Menu

8 Macros
· Basic Features
· The AutoExec Macro
· The AutoKeys Macro

9 Modules
· Some Definitions
· Creating a Function Procedure

10 Events
· When Events Occur
· Creating an Event Procedure

11 Expressions
· About Expressions
· Generating Custom Codes

12 Dynamic Queries
· Develop the Query
· Link to a Main Form/Sub Form
· Automate with simple VB code

13 Action Queries
· Make Table / Append / Update/ Delete Queries

14 Other Features
· Calculations in Queries

See related categories

Microsoft Access Developer (Level 3) 2003 2007 2010 2013 2016 & 365

£ 495 VAT exempt

The best Access courses

See all

See all