Access

At KITT Consultancy we can provide training courses in Microsoft Access. This is a database system that provides programming and functionality of a database for all purposes. It can be purchased within the MS Office suite or sold separately.

The programme stores data on the Access Jet Database Engine which can use data directly from other applications and databases. It allows a user to manage large amounts of information, so if you are managing your company’s information or need to examine large amounts of data, Microsoft Access can help you manage this task quickly. It is a great programme to learn, and we can provide on-site courses in Bedfordshire, Buckinghamshire & Hertfordshire.

Courses Provided

0
0
0
0

Duration 1 day

£195

Group Booking Calculator

Course Microsoft Access 2013 Level 1 – Introduction
Duration 1 day
Original Price Per Delegate 195
Number of Delegates
Discounted Price Per Delegate 195
Total Cost 195
Total Saving 0

COURSE OBJECTIVES:

At the end of this course, delegates will learn an understanding of the design techniques involved in building relational databases, creating tables, forms, queries and reports.

  • Understand databse concepts and objects
  • Create, edit and maintain tables
  • Create queries
  • Create forms
  • Create reports
  • Create relational tables, forms, queries and reports

WHO SHOULD ATTEND:

People who intend to design databases from scratch or improve existing Microsoft Access databases. Also conversion of databases made in other applications and spreadsheet (flat file) databases.

EXPERIENCE NEEDED:

This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.

COURSE CONTENTS:

1.  Introduction to databases

2.  Tables

3.  Working with tables

4.  Queries

5.  Introduction to reports

Duration 1 day

£195

Group Booking Calculator

Course Microsoft Access 2013 Level 2 – Intermediate
Duration 1 day
Original Price Per Delegate 195
Number of Delegates
Discounted Price Per Delegate 195
Total Cost 195
Total Saving 0

COURSE OBJECTIVES:

At the end of this course, delegates will build on some existing database design and/or user experience that may have been gained from the Introduction course.

  • Database concepts
  • Normalisation
  • Different types of queries
  • Designing forms
  • Customising reports

WHO SHOULD ATTEND:

People who intend to design databases at intermediate level or improve existing Microsoft Access databases.

EXPERIENCE NEEDED:

This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.

COURSE CONTENTS:

1.  Managing relational databases

2.  Action queries

3.  Customising forms

4.  Reports

Duration 1 day

£250

Group Booking Calculator

Course Microsoft Access 2013 Level 3 – Advanced
Duration 1 day
Original Price Per Delegate 250
Number of Delegates
Discounted Price Per Delegate 250
Total Cost 250
Total Saving 0

COURSE OBJECTIVES:

At the end of this course, delegates will build on a reasonable level of database design experience that may have been gained from the Introduction and/or Intermediate course.

  • Backup the database
  • Restore the database
  • Work with different form objects
  • Optimise the database
  • E-mail database information

WHO SHOULD ATTEND:

People who intend to design databases at an advanced level or improve existing Access databases. Also advanced conversion of databases made in other applications and spreadsheet (flat file) databases.

EXPERIENCE NEEDED:

This course assumes a reasonable level of database design principles.

COURSE CONTENTS:

1.  Protecting desktop databases with backup and restore processes

2.  Advanced forms customising

3.  Optimising and administering access

4.  Introduction to e-mailing database Information

Duration 2 day

£450

Group Booking Calculator

Course Microsoft Access 2013 – Bespoke Training
Duration 2 days
Original Price Per Delegate 450
Number of Delegates
Discounted Price Per Delegate 450
Total Cost 450
Total Saving 0

COURSE OBJECTIVES:

At the end of this course, delegates will build upon a good level knowledge of database design experience that may have been gained from the Advance course.

  • Create events and order them
  • Create various type of reports with sub-reports
  • Make use of controls
  • Work with macros
  • Know how to integrate with SharePoint
  • Import and link data
  • Work with Data Access Objects (DAO)
  • Work with ActiveX Data Objects (ADO)
  • Understand how Microsoft Access works with the web

WHO SHOULD ATTEND:
People who intend to design databases at an advanced level or improve existing Access databases.  Potential database programmers and database support analysts committed to databases built on Microsoft Access architecture.

EXPERIENCE NEEDED:
This course assumes a reasonable level of database programming and/or VB or SQL programming principles and database design principles.

COURSE CONTENTS:

1. Events

2. Reports

3. Sub-reports

4. Controls

5. Macros

6. Integration with Windows SharePoint services

7. Importing and linking data

8. Sharing an MS Access database on a Network

9. Data Access Objects (DAO)

10. ActiveX Data Objects (ADO)

11. Working on the internet and web

Sun Mon Tue Wed Thu Fri Sat
1
Away
Away
Aug 29 – Sep 4 all-day
 
2
3
4
Busy
Busy
Sep 4 all-day
 
5
Busy 7:30 am
Busy
Sep 5 @ 7:30 am – 6:00 pm
 
6
Busy 7:00 am
Busy
Sep 6 @ 7:00 am – 6:00 pm
 
7
Busy 7:00 am
Busy
Sep 7 @ 7:00 am – 6:00 pm
 
8
Busy 10:00 am
Busy
Sep 8 @ 10:00 am – 11:00 am
 
9
10
11
Busy 7:30 am
Busy
Sep 11 @ 7:30 am – 6:00 pm
 
12
Busy 10:00 am
Busy
Sep 12 @ 10:00 am – 11:00 am
 
13
Busy 7:30 am
Busy
Sep 13 @ 7:30 am – 5:30 pm
 
Busy 3:30 pm
Busy
Sep 13 @ 3:30 pm – 4:30 pm
 
14
Busy 7:30 am
Busy
Sep 14 @ 7:30 am – 6:00 pm
 
15
Busy 7:30 am
Busy
Sep 15 @ 7:30 am – 6:00 pm
 
16
Busy 3:30 am
Busy
Sep 16 @ 3:30 am – 4:00 am
 
17
Busy 6:30 pm
Busy
Sep 17 @ 6:30 pm – 7:00 pm
 
18
Busy 8:30 am
Busy
Sep 18 @ 8:30 am – 5:00 pm
 
19
Busy 8:30 am
Busy
Sep 19 @ 8:30 am – 5:00 pm
 
20
Busy 7:00 am
Busy
Sep 20 @ 7:00 am – 6:00 pm
 
21
Busy 7:30 am
Busy
Sep 21 @ 7:30 am – 6:00 pm
 
22
Busy 7:00 am
Busy
Sep 22 @ 7:00 am – 6:00 pm
 
23
24
25
Busy 12:00 am
Busy
Sep 25 @ 12:00 am – Sep 29 @ 11:59 pm
 
26
27
28
Tentative 7:30 am
Tentative
Sep 28 @ 7:30 am – 6:00 pm
 
29
30

Use the calendar to see booking availability. Please advise us of any preferred dates (preferably 2 weeks notice) in the message if you have one.

Your Name (required)

Your Email (required)

Subject

Your Message

Contact KITT Consultancy today for a professional, no-obligation audit and see how we can help make your Microsoft Office applications work better for you.

prince2
mos
mcp
LPI
fsb
bcc
Logo12