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

Olas Logo

Microsoft Visio

Microsoft Visio course is offered by Olas. Olas uses a variety of delivery methodologies and believe a blended learning approach leads to the participants retaining the knowledge learnt through the learning event.

by Olas [Claim Listing ]
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 ]
Act Training and Testing Logo

MS Word (Level 1)

Students will learn the basic skills necessary to begin using Word. Students will learn how to create and edit documents, use character and paragraph formatting and use page layout features.

by Act Training and Testing [Claim Listing ]
Acudemy Logo

Excel – Introduction (Level 1)

This course is for those who are interested in learning how to create spreadsheets. Whether you prefer Mac or PC is not important because this course will be equally suitable for both.

by Acudemy
Infero Training Logo

Microsoft Access Programming With VBA

In Access VBA you will learn how to extend the functionality of Access using a programming language called Visual Basic for Applications (VBA). With VBA you can create code which will allow you to automate the functionality of your database.

by Infero Training [Claim Listing ]

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