Access – introduction

A one-day workshop

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports.

Objectives

Learning objectives

This course will help participants:

  • Plan and create a database
  • Sort and filter records
  • Use field data types
  • Work with tables
  • Create and manage a query
  • Create and work with forms, and use the form wizard
  • View, create and print reports

Audience

Who should attend?

This workshop offers useful shortcuts and is therefore also suitable for those who are self-taught.

  • No previous Access experience required.
  • Designed for Office 365 versions: 2016, 2013 and 2010

Format

Format

A very practical, interactive one-day session for a maximum group size of 12. Comprehensive materials provided.

1 Access introduced

  • Planning a database
  • Creating a blank database
  • Opening an existing database
  • Security warnings
  • The navigation pane
  • Previewing database components
  • Closing an Access database

2 Tables introduced

  • Viewing and navigating table data
  • Navigating using keyboard shortcuts
  • Editing table data
  • Adding records to tables
  • Selecting and deleting records
  • Finding and replacing data
  • Filtering tables
  • Summing table data

3 Queries introduced

  • Opening a query in datasheet view
  • Opening a query in design view
  • Adding fields to a query
  • Sorting query results
  • Modifying datasheet view
  • Saving and closing queries

4 Forms introduced

  • Working with form data
  • Sorting records
  • Filtering records
  • Working in design and layout views
  • Changing object attributes

5 Reports introduced

  • Opening and viewing reports
  • Viewing a report in design view
  • Previewing and printing report data
  • Creating reports with auto report
  • Creating reports with the report wizard
  • Changing field attributes

6 Creating a new database

  • Creating database tables
  • Creating table fields
  • Selecting field data types

7 Table relationships

  • Introducing relationships
  • Establishing table relationships
  • The one-to-many relationship type
  • Establishing referential integrity

8 Creating queries

  • Streamline query criteria using wildcards
  • Creating summary queries
  • Creating queries based on criteria
  • Running date queries
  • Formatting field properties
  • Building queries from multiple tables
  • Summing in queries

9 Creating forms

  • Creating a new form
  • Inserting form fields
  • Working with the property sheet
  • The command button wizard
  • The command button wizard
  • Programming without typing
  • Creating forms with embedded sub forms
  • Creating forms with the sub form wizard
  • Creating forms with the form wizard

10 Creating reports

  • What are report bands?
  • Managing report controls
  • Basing reports on multiple tables
  • Basing reports on queries
  • Sorting and grouping records

Any questions? Please just give us a call on 01582 463463 – we’re here to help!