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

Systematix Training Logo

Word (Introduction)

This course is intended to help all novice computer users get up to speed with Word quickly. We will cover different features of the interface, show users how to create a basic document, and introduce users to most important Word tools

by Systematix Training [Claim Listing ]
Stoke on Trent College Logo

Intermediate Microsoft Excel

Intermediate Microsoft Excel course is offered by Intermediate Microsoft Excel.Find a courses that match your interests. A variety of courses ranging from full, part - time and online offerings for you to choose from.

by Stoke on Trent College [Claim Listing ]
European Centre of Technology Logo

MS Excel Foundation

This course provides a solid foundation of Microsoft Excel skills, to improve user efficiency in Excel, especially for those who are self-taught or unfamiliar with the Programme.

by European Centre of Technology [Claim Listing ]
Jemco IT Training Logo

Microsoft Word Foundation

Microsoft Word Training Courses can be tailored to suit your individual needs, plus we can train on site at your premises.

by Jemco IT Training [Claim Listing ]
Indicia Training Logo

Access

This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.

by Indicia Training [Claim Listing ]

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