Microsoft Access Training Course – Intermediate

Great Training & Great Prices

Microsoft Access Training Course – Intermediate

Category:
Microsoft /
Free
1 Reviews
Microsoft Access Logo

Free

6 Students
Duration: 1 day
Certificate of Completion

Microsoft Access

Microsoft Access – Beyond the basics

Your training and experience using Microsoft Access has given you basic database management skills such as creating tables, designing forms and reports and building queries. You now feel that you want to expand your knowledge of relational database design and learn how to write advanced queries, structure existing data, share data across applications and customise reports.

1 Day Intermediate Microsoft Access     £220.00  Face to Face or Online   Discounts are available for 2nd & 3rd delegates and Group bookings.

Course Content

  • Design a relational database
  • Join tables
  • Organise a database for efficiency
  • Share data across applications
  • Use advanced reporting
  • Q&A
  • FREE Detailed Course Training Manual in PDF format (one per course) Normal cost £50.00
  • Money Back Guarantee
  • Small Class Sizes (Max 6 Delegates)
  • Refreshments (at in2)
  • Training Course Certificate
  • Email Support
  • Automatic enrolment into our customer discount reward scheme

Who is the target audience?

  • This Intermediate Microsot Access Training Course is intended for people interested in extending their knowledge of Microsoft Access
  • This course is aimed at anyone who has been using Microsoft Access for a while or who have attended out Introduction Microsoft Access Training Course

Course Guidelines

  • Understanding Relational Database Design
  • Create a Table
  • Create Table Relationships

  • Create Query Joins
  • Join Tables That Have No Common Fields
  • Relate Data within a Table
  • Work with Subdatasheets
  • Create Subqueries

  • Understanding what is Data Normalization
  • Create a Junction Table
  • Improve Table Structure

  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

  • Organise Report Information
  • Format Reports
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

About Instructors

Reviews

Average Rating

5
Free
1 Ratings

Detailed Rating

Stars 5
1
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0

  • Mark Hatton

    5 out of 5

    Kepston
    “The instructor was very engaging and kept the content nice and easily explained. I had a basic knowledge of Access before the course, but I now know how to create a more indepth, efficent database. Really enjoyed the day”. – Mark

Add a review

This site uses Akismet to reduce spam. Learn how your comment data is processed.