Course Description

Course Overview

The Microsoft Access 2019 course is designed to provide students with the skills necessary to create and manage databases using Microsoft Access. This course covers various topics, including database design, data entry and manipulation, querying, forms, reports, and database integration. It aims to equip students with the knowledge required to effectively organize and analyze data using Access.

Prerequisites

To enroll in the Microsoft Access 2019 course, students should have basic computer literacy and familiarity with the Windows operating system. No prior experience with Microsoft Access is required, although a basic understanding of databases and data management concepts will be beneficial.

Methodology

The course will be delivered through a combination of instructor-led demonstrations, hands-on exercises, and practice sessions. Students will have access to study materials, including manuals and online resources, to support their learning. Practical exercises and projects will provide students with the opportunity to apply their knowledge and develop their Access skills.

Course Outline

• Introduction to Microsoft Access
• Overview of Access interface and features
• Navigating and customizing the Access window
• Creating and saving databases
• Database Design and Data Entry
• Planning and designing a database structure
• Creating tables and defining field properties
• Importing and linking data into Access
• Querying and Data Manipulation
• Creating queries to retrieve and filter data
• Sorting and grouping query results
• Updating, deleting, and appending data
• Forms and User Interface
• Designing and customizing data entry forms
• Creating form controls and applying validation rules
• Utilizing form navigation and layout options
• Report Generation and Printing
• Designing and customizing reports
• Adding grouping, sorting, and calculations to reports
• Printing and exporting reports to different formats
• Database Integration and Advanced Features
• Importing and exporting data between Access and other applications
• Utilizing Access with Excel, Word, and Outlook
• Implementing advanced features such as macros and database relationships

Outcome

Upon completion of the Microsoft Access 2019 course, students will be able to:

• Navigate and utilize the Access 2019 interface effectively.
• Design and create well-structured databases.
• Perform data entry, manipulation, and querying tasks.
• Design and customize forms for data entry and validation.
• Generate and customize reports for data analysis and presentation.
• Integrate Access with other Microsoft Office applications.

Labs

The course includes practical lab sessions and exercises to reinforce the theoretical knowledge and skills learned. The labs will cover the following topics:

• Creating and managing databases
• Designing and populating tables with data
• Creating queries to retrieve and manipulate data
• Designing and customizing data entry forms
• Generating and customizing reports
• Integrating Access with other Microsoft Office applications

These labs will provide students with hands-on experience in using Microsoft Access 2019, designing databases, querying and manipulating data, creating forms and reports, and integrating Access with other applications. By completing these labs, students will develop practical skills that are essential for utilizing Access effectively in various personal and professional scenarios.