Duration 1 Day

Who should attend?

Anyone who needs to create databases and needs to gain an understanding of the basics of database design, and existing users who wish to improve their knowledge and understanding of Access databases by creating areas in the database to input data and learning how to search for specific information, organise data and grouping information together.

Learning Outcomes

  • Design and create a database
  • Understand table design and structure
  • Import and link to external data sources
  • Create and modify Forms
  • Create simple Filters
  • Create Queries
  • Create powerful Reports

Course Content

  • Introduction to Databases
  • Database Terminology
  • Introduction to the Access Environment
  • Table Design
  • Indexing Fields
  • Adding & Editing Data
  • Changing the Table Layout
  • Importing & Linking Data
  • Find & Replace
  • Forms
  • Types of Forms
  • The Form Wizard
  • Designing Forms
  • Calculations on Forms
  • Filters
  • Queries
  • Designing new queries
  • Formula and Criteria Creation
  • Calculations in Queries
  • Reports
  • Using the Report Wizard
  • Calculated and statistical fields