Latest Advice on Coronavirus (COVID-19)

An important message for parents of Blackburn College students.

Data Management for Small Businesses (Microsoft Access Training)

Course Information

  • Course Code: EC402
  • Duration: 10 weeks x 2 hours
  • Price: £350.00
  • Times: 18:00-20:00
  • Delivery Type: PT

Start Dates

  • Monday, 02 November 2020

Book Now Print

Overview

This course is suitable for someone new to MS Access or with some experience.  It will take the attendee through the various aspects and Functionality of MS Access including a brief introduction to Database Design.

What will I study?

 

 

Week No

Topic

Content

1

Introduction to MS ACCESS and Database Design

An introduction to Relational Databases and Database Design (Schema)

2

Introduction to ACCESS Tables and Data Types

Access Tables and Data Types, Naming Schemes, Primary Keys, Foreign Keys

3

Further ACCESS Tables

Referential Integrity, Data Integrity, Relationships, Lookups

4

Introduction To ACCESS Queries

SELECT, INSERT, DELETE, UPDATE, MAKE TABLE

5

Further ACCESS Queries (Aggregate and Parameter)

SUM, AVG, MIN, MAX, FIRST, LAST, GROUP BY, COUNT

6

Introduction to Access Reports

Data Representation in reports and formatting

7

Further ACCESS Reports

Grouping and Sorting Data

8

Introduction to ACCESS Forms and Interface Design

Data entry forms, Bound and Unbound

9

Further ACCESS Forms and Introducing Macros

Dialogues, Switchboards, Sub forms, Form Buttons and Actions

10

Bringing it all together with a finished application

Rounding off the various aspects of the MS ACCESS application students have built upon each week.

Entry Requirements

Good basic use of computers/navigating screens in Microsoft.  This course is suitable for someone new to MS Access or with some experience.  

What can I do next?

You'll find further courses here which may be of interest:  https://www.blackburn.ac.uk/courses/?ageGroup=Adults&page=1

For more information

For more information about this course, contact our specialist team on 01254 29 25 00 or email business@blackburn.ac.uk

Book Now Print