Microsoft Access (Database) (CSIS 154) – Spring 2022

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

• Data Analyst
• SQL Server Data Engineer
• Database Architect
• Freelancer – Create databases adaptable to the need of an individual or group and get paid based on hours spent
• Marketing jobs (databases for marketing goods and/or services)
• Education as a trainer/instructor in a primary school, secondary/high school, private firms etc.
• Start your own Computer Business and Computer Training for Ms-Access with little income/investment.

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