Skip to main content

Read our latest COVID-19 (coronavirus) updates.

PayReportApply
PayReportApply
Read aloud icon Read aloud Accessibility icon Accessibility
IT training

Microsoft Access 2016 (Basic)

  • Duration

    One day: 9.30am - 4.30pm

  • Description

    Microsoft Access is a database software application. It is a tool for storing information which can then be retrieved using reports and queries.

    All the information in the database is held in tables created by the user and forms are used to add information to the database in a more user friendly format. Queries are used to retrieve information from the database, which can then be displayed as a report. This course is an introduction to Access covering tables, forms, queries and reports.

  • Prerequisites

    A basic understanding of Microsoft Windows.

  • Agenda

    Exercise Details
    Exercise 1 Creating an Access database
    • Creating, naming and saving a database
    Exercise 2  Creating tables
    • Creating, naming and saving a table
    • Defining a primary key and indexing fields within a table
    Exercise 3  Amending the design of a table
    • Changing the properties for the fields in the table
    • Creating lookup fields
    Exercise 4  Creating Tables
    • Creating, naming and saving a table
    • Defining a primary key and indexing fields within a table
    Exercise 5 

    Creating relationships

    • Linking tables
    Exercise 6 

    Entering information into a table

    • Entering information into a table using Datasheet View
    Exercise 7 

    Creating forms

    • Creating simple forms
    • Using the Form Wizard
    Exercise 8

    Formatting a form

    • Formatting the appearance of a form using the available tools
    Exercise 9 

    Adding a form header and footer

    • Add a header and footer to your form
    • Insert pictures into your form
    ​Exercise 10 

    Modifying forms

    • Formatting the form
    • Creating headers and footers
    Exercise 11 Creating queries in design view
    • Creating, saving and executing queries based on one table
    Exercise 12  Creating queries in design view based on two tables
    • Creating, saving and executing queries based on two tables
    Exercise 13  Reports
    • Creating various types of reports using basic reports and the report wizard
    • Formatting the appearance of a report using the available tools
    Exercise 14  Finding information in a table
    • Locating specific records within a table
    Exercise 15  Creating Filters
    • Using a filter in a table’s datasheet view
    Exercise 16  Sorting information
    • Sorting the information in a table

  • Goals and objectives


    Goals

    1. To introduce the concept of a database.
    2. To introduce ways in which information can be displayed and obtained from a database.


    Objectives

    After completing this course you will be able to:

    1. open Microsoft Access
    2. create, open and save a database
    3. create tables within a database into which records can be entered
    4. edit the information within a table
    5. link multiple tables
    6. create and edit forms used to enter information
    7. create and execute queries to retrieve specific information
    8. create queries based on multiple tables
    9. create filters and sorts
    10. create reports based on tables or queries
    11. create formulae within Access to the summarise data in reports
    12. navigate between tables, forms, reports and queries using the Database Window
    13. save the database
    14. close Microsoft Access.

    You will complete all of these using Microsoft Access.

  • Costs

    External attendees: £110 plus VAT per candidate.

Read aloud icon Read aloud