/

MS Access Database Intermediate Course - Data Analysis with Access Queries, Private 1-to-1

(4.8)17 reviews
Recent reviews of this course provider

Pivot tables in 45 minutes

Excellent course. My teacher Sarah was really good and took me through how to cr...more

See all reviews
Add to shortlist

https://www.hotcourses.com/courses-by-subject/MS-Access-Database-Intermediate-Course-Data-Analysis-with-Access-Queries-Private-1-to-1-courses/55333196/

Course description

MS Access Database Intermediate Course - Data Analysis with Access Queries, Private 1-to-1:

Course Aims (Access 2007, 2010, 2013, 2016 and Mac) This course is offered one-to-one, because we understand that indiovuals have varying skill levels and varying applications. This private style tuition helps to maximise the value you get from the day.

Bookings made via Hotcourses will be confirmed by PCWorkshops directly within 24Hours.

Who Should Attend

People who need to do creative and in-depth queries of datases.

Course Outline

Tables

  • Referential Integrity
  • Table Relationships

Queries

  1. Queries
  2. Wildcards
  3. Totals Queries
  4. Expression queries
  5. Action queries:
  • Make Table,
  • Inserting records
  • Append,
  • Update and
  • Delete Queries

Data

  • Importing Data
  • Exporting Data
  • Linking Data

Creating Forms

  • Creating forms, Form wizards
  • Creating a Navigation Form

Creating reports, On-screen and Paper / Pdf based. On screen queries via preprepared forms

Additional entry requirements

Access Beginners

Training for employers

This course has been specifically designed for companies training their employees.

Course info
Start Date: Wed 29th May 2019
START DATES
MAY 2019
Sun Mon Tue Wed Thu Fri Sat
JUNE 2019
Sun Mon Tue Wed Thu Fri Sat

Location:

Southend-On-Sea, SS1 1NE, Milton Keynes, MK9 2UB, London, WC2N 4JF, You study this on your computer

Time:

11:00am - 6:00pm, Any time

Duration:

1 day, By arrangement

Attendance:

Full time, Online

Qualification:

Qualification awarded by the course provider

Level:

Beginner IntermediateAdvanced

From: £250

Summary of all course reviews for PCWorkshops

17 reviews

(94%)
(6%)

Average student ranking

Reviews of other courses at PCWorkshops

pcworkshops

Pivot tables in 45 minutes
5 5
Hotcourses
December 2017

Excellent course. My teacher Sarah was really good and took me through how to create pivot tables step by step. She made it simple and straightforward. I can now create a pivot table with confidence. You also get a certificate of attendance. I would highly recommend this course to a friend. Sharmini Shanthakumar

Was this review helpful? Yes No
2 Hotcourses user(s) found the following review helpful.

pcworkshops

Java taster
5 5
Hotcourses
December 2017

Sarah is an excellent mentor . She taught me well in such a short span of time and gave sufficient material to get a feeling of programming in Java. Thanks!! Rahul

Was this review helpful? Yes No
3 Hotcourses user(s) found the following review helpful.
MORE REVIEWS

Please note reviews of Java Programming "Taster" Course, 1 Day are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course reviews

This course currently has no reviews.

Write a review

Course photos

  • MS Access Database Intermediate Course - Data Analysis with Access Queries, Private 1-to-1 by PCWorkshops on Hotcourses

Ask a question

Get course info