MS Access Intermediate Course

by PCWorkshops

This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it. Learn and explore various query techniques from where clauses, to aggregation, joins and more.

£580

Contact the Institutes

Fill this form

Advertisement

PCWorkshops Logo

img Duration

2 Days

Course Details

This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it. Learn and explore various query techniques from where clauses, to aggregation, joins and more. This private style tuition helps to maximise the value you get from the day.

Session 1: Database Concepts

  • Tables
  • Referential Integrity
  • Table Relationships

 

Session 2: MS Access Queries

  • Select Queries, selecting columns and using where clauses
  • Multiple table queries, joining tables using query design
  • In null, is not null
  • Wildcards
  • Totals

 

Session 3: MS Access Queries

  • Expression queries
  • Action queries:
  • Make Table Queries to create new queries from existing query or tables,
  • Queries to insert new records
  • Append queries,
  • Update queries,
  • Delete queries.

 

Session 4: MS Access Importing Data

  • Importing Data
  • Exporting Data
  • Linking Data

 

Session 5: MS Access Forms

  • Linking Data Creating Forms
  • Creating forms, Form wizards
  • Creating a Navigation Form

 

Session 6: MS Access Reports

  • Brief overview of Creating and viewing MS Access reports
  • WC2N Branch

    Golden Cross House, 8 Duncannon Street, WC2N, London
  • M2 Branch

    53 Fountain Street, M2, Manchester
  • MK9 Branch

    Exchange House, 494 Midsummer Boulevard, MK9 , Milton Keynes
  • City Centre Branch

    One Victoria Square, City Centre, Birmingham
  • Cosham Branch

    Ground Floor, Building 1000, Lakeside North Harbour, Western Road, Cosham, Portsmouth

Check out more MS Access courses in UK

Smartthink Training Ltd Logo

Microsoft Visio 2013 Essentials

Microsoft Visio 2013 Essentials is offered by Smartthink Training Ltd

by Smartthink Training Ltd [Claim Listing ]
PCWorkshops Logo

MS Word Advanced Course

This MS Word Advanced Course, Private 1-to-1, covers advanced MS Word tools. Ideal for delegates who create long documents, manuals and manuscripts. MS Word styles and formats, help making formatting documents consistent and easy to maintain.

by PCWorkshops
AJ Training Logo

Microsoft Office Training Course

Microsoft Office Editions, the easiest way to help more people use information to make a positive impact on business. The Office Editions offer great technologies and features while improving upon existing and familiar tools to facilitate effective and efficient collaboration and information sharin...

by AJ Training [Claim Listing ]
Best Practice Training Limited Logo

Microsoft PowerPoint Masterclass

The Microsoft PowerPoint Masterclass course helps the delegates to learn about tools and techniques to present data effectively to the audience. Microsoft PowerPoint can be used to present the data in text, graphical or animated forms by applying the available effects.

by Best Practice Training Limited [Claim Listing ]
SureSkills Logo

Microsoft PowerPoint Training

This PowerPoint Advanced course is intended to help all users get up to speed on many of the different features found in PowerPoint and to become familiar with its more advanced selection of features.

by SureSkills [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy