What is Basic Microsoft Access about?
This course explains how a database works and which components it is comprised of. Microsoft Access is an easy-to-use information management tool used to create customisable database applications. It assists with the 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.
This course was a gift from my mother and I am so grateful for the opportunity. I loved every minute of it.
Rewarding course. It made a difference to my life. Thank you.
- Email for notifications and communication
- Internet connection
- PDF viewer (e.g ADOBE Acrobat)
- Microsoft Access
- A web browser
What other related courses are offered?
We provide a variety of courses, from computer studies to leadership and softskills courses.
The following are our most popular courses:
Although this class was a challenge, I really enjoyed it. I also enjoyed the fact that everything was online.
Job Market Prospects
Software developers, data architects and power users all use Microsoft Access to develop application software.
What other people are saying:
How long does it take to complete?
How much does it cost?
Unit 1 - Introduction
1.1 Identifying the elements of the Access interface
1.2 The different types of databases in Access
1.3 Exploring the database components
1.4 Exploring different databases
1.5 How to create an Access database
1.6 Using the Help function
Unit 2 - Tables
2.1 Database fields, records and columns
2.2 Creating tables
2.3 Set field properties
2.4 Manipulate the table design
2.5 Manipulate the table data
2.6 Delete a table
Unit 3 - Relationships
3.1 Set primary and foreign keys
3.2 Create table relationships
3.3 Edit relationships
3.4 Explore sub-data sheets
Unit 5 - Forms
5.1 Use auto form wizard, create a form manually, and modifying a form
Unit 6 - Reports
6.1 Create an auto report, use report wizard, imitations on reports and how to print
Unit 4 - Queries
4.1 Create select queries
4.2 Extend queries with criteria and run a query
4.3 Use calculated fields in a query
4.4 Apply record groupings
It takes between 4 days and 2 weeks, depending on your speed.
only $1 + 36c
(The 36c is the administration fee)
Microsoft Word Basic
Microsoft Excel Basic
Microsoft PowerPoint Beginner
Microsoft Word Intermediate
Microsoft Excel Intermediate
Microsoft PowerPoint Advanced