Ewch i’r prif gynnwys

Microsoft Access 2013: Working With Information in Your Database

Mae'r cynnwys hwn ar gael yn Saesneg yn unig.

This one-day session offers training on extracting subsets of information from a single table or from a set of related tables held in a database.

This session only covers one stage of database use: extracting information from existing tables. If you are looking for a comprehensive Microsoft Access training course, our three-day Microsoft Access: Comprehensive course may be more appropriate for you.

About the course

This one-day course follows on from the Microsoft Access: Designing and Creating Your Database course. You will learn:

  • how information stored in a table, or a set of related tables, can be filtered
  • how queries can be constructed and used to extract relevant records of information
  • how to summarise information held in database tables.

The course covers:

  • designing and creating filters and queries to extract subsets of data and summary information from one or more tables
  • performing calculations and automated updates to information.

Prerequisites

  • You must be familiar with the Microsoft Access interface and have an understanding of how information is stored in tables.
  • To get the most out of this course you should also have practical experience of creating related database tables.
  • It is advisable to attend the Microsoft Access: Designing and Creating Your Database course prior to booking onto this course.

Cost

£125 (plus VAT) for non-profit making organisations eg other universities, charities, and government bodies, including Cardiff and Vale University Health Board.

£150 (plus VAT) for commercial organisations.

Contact

To book onto a course, please send your contact information and details of the course you would like to take to: