General Introduction and Course Description
The Microsoft Access (Ms-Access) application is one of the many applications in the Microsoft Office package.
According to Wikipedia, It is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
Ms-Access is used in offices, businesses, schools, and organizations to create simple and complex and creative databases for storing, analysing, communicating, and manipulating information in such a way that is presentable and suitable to a group of people or audience.
Watch the Course Introduction video:
Course Objectives
In this Access course, we will utilize a practical or hands-on approach to show how you can create simple databases with pre-formatted tables, forms, reports, and queries. You will learn the skills of creating and working with tables, working with forms, editing texts, formatting texts, creating, and working with reports and queries.
Pre-Requirements and Target Audience
The course is designed for both beginners who do not have any prior background in Ms-Access, and for intermediate level people who also wish to extend their practical/hand-on skills and knowledge.
To achieve or fully take advantage of this course, you need to have some prior knowledge Windows operating system environments (starting a computer an using the desktop environments). You can follow the course “Microsoft Windows Operating System Basics – CSIS 113” for this basic knowledge.
it is important you have a laptop or desktop computer with the Ms-Access application installed, preferably, a laptop with Windows 10 and with Office365.
Job Opportunities – The course also enables you to find jobs in the following areas
Course Modules / Structure
The Course is divided into 5 Modules:
Week 1 – Module 1: Introduction to Ms-Access (Database) Environment
Week 2 – Module 2: Database, Datasheet, Tables and Properties
Week 3 – Module 3: Working with Tables: Records, Layouts and Formatting
Week 4 – Module 4: Working with Forms and Reports
Week 4 – Module 5: Final Component and Assessment Leading to Award of a Certification (This final module included topics like Working with Queries + Quizzes)
Finding the Course (Modules) Contents
For each module, a number of videos are made available. These guide you step-by-step through the course. If you have issues with the course materials, please contact the instructor using the Instructor contact information below.
Modules Assessment
Each module also presents a quiz that you can take to test your own knowledge. This quiz takes a practical approach requiring you to practice and create an Access database or document using what you have learnt. The quiz should be submitted (as Access document) to the instructor’s email (see below) and this will be assessed by the instructor to provide you with feedback and grading.
Final Assessment and Certification (Module 5 + Final Quiz)
To be able to complete the full course and obtain a certificate of completion, you will be required to take Module 5 and do a FINAL ASSESSMENT which you are required to pass. You are required to score 70% and above for the FINAL ASSESSMENT to be eligible for the certification.
Instructor’s Contact
Instructor Name: Dr. Fredrick Ezeh
Email Contact: fred@osiriuniversity.org