Microsoft Access

MICROSOFT ACCESS

  • PURPOSE

  • COURSE CONTENT

  • DELIVERY

  • ACCREDITATION

This course explains how a database works and goes on to explore its components. Microsoft Access is an easy-to-use information management tool employed
to create customisable database applications. It assists with storage of information for reference, reporting and analysis. It can help manage related data more
efficiently than Microsoft Excel or other spreadsheet applications.
The course covers how to create table relationships and set primary and foreign keys, create queries and apply record groupings

  • Unit 1: Introduction
    1. Identifying elements of the Access interface
    2. Different types of databases in Access
    3. Exploring database components
    4. Exploring different databases
    5. How to create an Access database
    6. Using the Help function

  • Unit 2: Tables
    1. Database fields, records and columns
    2.  Creating tables
    3. Setting field properties
    4. Manipulating table design
    5. Manipulating table data
    6. Deleting a table
  • Unit 3: Relationships
    1. Setting primary and foreign keys
    2. Creating table relationships
    3. Editing relationships
    4. Exploring sub data sheets
  • Unit 4: Queries
    1. Creating select queries
    2. Extending queries with criteria and running a
      query
    3. Using calculated fields in a query
    4. Applying record groupings
  • Unit 5: Forms
    1. Using auto form wizard, creating a form
      manually and modifying a form
  • Unit 6: Reports
    1. Creating an auto report, using report wizard,
      imitations on reports and how to print
  •  

Duration: 1 Day

Delivery: Classroom/Online

 

5 Day Courses: Participants will receive a SpecCon Holdings certificate upon completion of all courses.

1 Day Courses: Participants will receive a SpecCon Holdings certificate upon completion of this course.

Other Microsoft Office Courses