- Course Code: EC402
- Duration: 10 weeks x 2 hours
- Study mode: Part Time
- Price: £350.00
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?
Introduction to MS ACCESS and Database Design
An introduction to Relational Databases and Database Design (Schema)
Introduction to ACCESS Tables and Data Types
Access Tables and Data Types, Naming Schemes, Primary Keys, Foreign Keys
Further ACCESS Tables
Referential Integrity, Data Integrity, Relationships, Lookups
Introduction To ACCESS Queries
SELECT, INSERT, DELETE, UPDATE, MAKE TABLE
Further ACCESS Queries (Aggregate and Parameter)
SUM, AVG, MIN, MAX, FIRST, LAST, GROUP BY, COUNT
Introduction to Access Reports
Data Representation in reports and formatting
Further ACCESS Reports
Grouping and Sorting Data
Introduction to ACCESS Forms and Interface Design
Data entry forms, Bound and Unbound
Further ACCESS Forms and Introducing Macros
Dialogues, Switchboards, Sub forms, Form Buttons and Actions
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