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

NILC Training Logo

Microsoft Outlook Introduction Training Course

This Microsoft Outlook training class introduces the interface and gets students up and running quickly working with messages, calendars, and contacts.

by NILC Training [Claim Listing ]
Eident Logo

Microsoft Access

Microsoft Access course is offered by Eident. Eident deliver scheduled and on-demand IT skills training courses

by Eident [Claim Listing ]
London IT Training (LIT) Logo

Analysis & Dashboard Training (77-727)

Analysis and Dashboard Training comprehends the Data Analysis on Microsoft Excel and Dashboard Reporting. This course will deliver the lessons to develop dynamic, effective, interactive, and appropriate Dashboards in Microsoft Excel.

by London IT Training (LIT)
Cosensa Logo

Microsoft Excel 2016 - Intermediate

This course is ideal for individuals who wish to explore intermediate excel skills, enhancing their current knowledge of this spreadsheet tool by understanding how to use the applications more complex features.

by Cosensa [Claim Listing ]
Acuity Training Logo

Microsoft Access Training (Introduction / Intermediate Course)

Master the fundamentals of Microsoft Access the quick way on this 2-day introductory Access training course. Microsoft Access is a very popular database programme. It allows data to be analysed and sorted, specific information to be searched for, and the results to be used to produce reports, list...

by Acuity Training

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