Access – introduction

Access – introduction – overview

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.

Full details below or download course outline.

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
Pre-requisites
  • No previous Access experience required.
  • Designed for Office 365 versions: 2016, 2013 and 2010
Course format

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

Expert trainer

Alan is a highly experienced and very popular IT skills trainer. After eighteen years as an employed IT trainer and training manager he went independent in 2013, specialising in Microsoft Office courses, primarily Excel, PowerPoint, Word, Outlook and Access, although he also delivers training in other programs when required. His clients come from all sectors and include such organisations as The Economist, Hyundai, Marston Group, MediaCom, London Borough of Harrow, Paragon Customer Communications, ICP Global Creative, Bywaters, etc, etc.

See what some of the participants have said about his workshops:

‘Fantastic. Well-paced and easy to follow.’
‘Great experience.’
‘Very personable, relatable, patient and able to present complicated processes in an understandable way.’
‘Friendly and good at checking people are up to speed.’
‘Very good and explained and answered all questions.’
‘Explains everything well.’
‘Excellent teacher and very intelligent.’
‘Very knowledgeable would love to have him again if there is another course – thank you.’
‘Alan explains things very clearly and addresses issues on questions before they are visible. Thank you very much!’

Access – introduction – course outline

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
  • Report properties sheet