Access level 1

Course

In Coventry

Price on request

Description

  • Type

    Course

  • Location

    Coventry

  • Class hours

    7h

  • Start date

    Different dates available

Students will learn the basic skills necessary to begin using Access, including designing and creating databases, tables, queries, forms, and reports.

Facilities

Location

Start date

Coventry (West Midlands)
See map
127-129 New Union Street, CV1 2NT

Start date

Different dates availableEnrolment now open

About this course

Computers for Beginners or equivalent knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Access
  • Database
  • Database performance
  • Creating Tables
  • Organizing Records
  • Queries
  • SQL
  • SQL Database
  • Monitoring
  • Report Writing

Course programme

Unit 1: Getting Started

  • Database concepts
  • Exploring the Access environment

Unit 2: Databases and tables

  • Planning and designing databases
  • Exploring tables
  • Creating tables

Unit 3: Fields and records

  • Changing the design of a table
  • Finding and editing records
  • Organizing records

Unit 4: Data entry rules

  • Setting field properties
  • Working with input masks
  • Setting validation rules

Unit 5: Basic queries

  • Creating and using queries
  • Modifying query results and queries
  • Performing operations in queries

Unit 6: Using forms

  • Creating forms
  • Using Design view
  • Sorting and filtering records

Unit 7:Working with reports

  • Creating reports
  • Modifying and printing reports

Access level 1

Price on request