Key features and benefits
- Study at our World Class Campus
- Fantastic learning facilities
- We work with over 3,000 employers to help you find a job
- Rated "Good" by Ofsted in all areas - as of January 2022
-
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 1 - Introduction to MS ACCESS and Database Design
An introduction to Relational Databases and Database Design (Schema)
Week 2 - Introduction to ACCESS Tables and Data Types
Access Tables and Data Types, Naming Schemes, Primary Keys, Foreign Keys
Week 3 - Further ACCESS Tables
Referential Integrity, Data Integrity, Relationships, Lookups
Week 4 - Introduction To ACCESS Queries
SELECT, INSERT, DELETE, UPDATE, MAKE TABLE
Week 5 - Further ACCESS Queries (Aggregate and Parameter)
SUM, AVG, MIN, MAX, FIRST, LAST, GROUP BY, COUNT
Week 6 - Introduction to Access Reports
Data Representation in reports and formatting
Week 7 - Further ACCESS Reports
Grouping and Sorting Data
Week 8 - Introduction to ACCESS Forms and Interface Design
Data entry forms, Bound and Unbound
Week 9 - Further ACCESS Forms and Introducing Macros
Dialogues, Switchboards, Sub forms, Form Buttons and Actions
Week 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.
-
For more information
For more information about this course, contact our specialist team on 01254 29 25 00 or email business@blackburn.ac.uk.
A few years ago, I never would have thought that I would have done something like this
Thomas Greeney
