Supercharge your skills on MS Access Database
      PCWorkshops

      MS Access Database Advanced Course

      5.0 excellent 4 opinions
      PCWorkshops
      In London

      Price on request
      Prefer to call the centre directly?
      77843... More
      Want to speak to an Advisor about this course?

      Important information

      Typology Short course
      Level Advanced
      Location London
      Duration 2 Days
      Start Different dates available
      • Short course
      • Advanced
      • London
      • Duration:
        2 Days
      • Start:
        Different dates available
      Description

      Become fully proficient with MS Access Database by taking PCWorkshops advanced course and become the Access database expert.

      Facilities (1)
      Where and when
      Starts Location
      Different dates available
      London
      8 Duncannon Street, WC2N 4JF, London, England
      See map
      Starts Different dates available
      Location
      London
      8 Duncannon Street, WC2N 4JF, London, England
      See map

      To take into account

      · What are the objectives of this course?

      This course will help you to structure, import, manage and query your data effectively. Advanced forms. Macro buttons linking forms and Menu systems. Power Queries

      · Who is it intended for?

      Candidates who have gone through PCWorkshops Beginners and Intermediate course or have experience in Access database

      · Requirements

      Experience in MS Access database

      · What marks this course apart?

      Private 1-to-1

      Questions & Answers

      Ask a question and other users will answer you

      Opinions

      5.0
      excellent
      Course rating
      100%
      Recommended
      5.0
      excellent
      Centre rating

      Reviews on this course

      S
      Samuel Musini
      5.0 08/02/2018
      What I would highlight: Sarah teaches very well. She could explain lots of concepts in different ways and that was really impressive.
      What could be improved: nothing
      Would you recommend this course?: Yes
      Did this opinion help you? Yes (0)
      O
      Olga Makhlonora
      5.0 17/09/2016
      What I would highlight: Thanks to Sarah I am more confident with my access skills and can now do advance stuff that even some of my team members still cannot do.
      What could be improved: -
      Would you recommend this course?: Yes
      Did this opinion help you? Yes (0)
      V
      Vanessa Le Grand
      5.0 10/08/2016
      What I would highlight: Lots of exercises and the day was just packed with lots of learning - worth the money!
      What could be improved: .
      Would you recommend this course?: Yes
      Did this opinion help you? Yes (0)
      S
      Sarah Harrison
      5.0 18/06/2016
      What I would highlight: Sarah is an excellent teacher! She made the lesson very fun and it taught me a lot.
      What could be improved: .
      Would you recommend this course?: Yes
      Did this opinion help you? Yes (0)
      Reviews gathered by Emagister & iAgora

      Achievements for this centre

      2018

      How do you get the CUM LAUDE seal?

      All courses are up to date

      The average rating is higher than 3.7

      More than 50 reviews in the last 12 months

      This centre has featured on Emagister for 2 years

      What you'll learn on the course

      Access
      Database Design
      Database
      SQL
      Database training
      Reports
      Data Types
      Forms
      Queries
      Access
      Access
      Access Macros
      Access Macros
      Access Macros

      Teachers and trainers (1)

      Mary Smith
      Mary Smith
      Tutor

      How Mary Smith teaches: I am consultative, flexible and understanding. I appreciate the trust given to me. What Mary Smith teaches: Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder. Java Coding Basics.

      Course programme

      Course Outline

      Advanced Data Management

      • Database design: planning the database and its purpose
      • Referential Integrity
      • Creating tables, datatypes, primary keys
      • Table Relationships
      • Importing data, and the planning of data migration
      • An Introduction to SQL

      Queries

      • Brief Query revision

      Forms Tasks

      • Using Subforms
      • Creating a Navigation Form
      • Restricting Form Entries - controlling input
      • Exporting a Form
      • Other Form Tasks

      Creating reports

      Access Macros

      SQL and Microsoft Access

      • Understanding SQL
      • Using the SELECT Statement
      • Using Subqueries
      • Using SQL Joins