Introduction to Microsoft Access Courseware (ACC101)
The Introduction to Access course provides a comprehensive foundation for students looking to learn about the Access database management system. This course covers the basics of Access, including its user interface, fundamentals, tables, queries, forms, and reports. Students will also gain insights into databases, Access terms, and relational databases. By the end of this course, students will have a solid understanding of Access and be prepared to use it effectively for managing and organizing data in various applications.
Access Version: This course primarily targets Access 2019; however, it can be used to teach Access 365 as well as earlier versions of Access. We draw attention to features that are not supported in earlier versions of Access, and point out alternative options, when available.
This is the updated version of 55279AC from the retired Microsoft Courseware Marketplace.
Benefits
- Comprehensive Coverage: This course offers a thorough introduction to Access, covering all key aspects of the software, from user interface to tables, queries, forms, and reports.
- Hands-on Learning: Through practical exercises, students will gain firsthand experience using Access, allowing them to build confidence in their skills and understanding of the software.
- Database Knowledge: In addition to learning about Access, students will also gain insights into databases, relational databases, and related terms, providing a well-rounded understanding of database management systems.
- Real-world Applications: The course prepares students to use Access effectively for managing and organizing data in various real-world applications, enhancing their overall data management capabilities.
- Experienced Authors: The course material is developed by experienced authors who have in-depth knowledge and expertise in Microsoft Access, ensuring that students receive accurate and valuable information.
Outline
- Quick Overview of the Access User Interface
- Access Ribbon
- Quick Access Toolbar
- Object Navigation Pane
- Access Work Surface
- Object Overview
- Process Overview
- Getting Around the Access Environment (Exercise)
- Create a Database Using a Wizard
- Fundamentals
- Questions to Ask Before You Start
- Asking Questions (Exercise)
- Approaches to Database Design
- Gather Information
- A Few Words about Naming Conventions
- Gathering Information (Exercise)
- Normalization
- Table Relationships
- Normalizing Data (Exercise)
- Tables and Their Views
- Definition and Purpose
- Datasheet View
- Working with Tables in Datasheet View (Exercise)
- Design View
- Tables
- Creating an Access Database
- Creating a New Database (Exercise)
- Data Types
- Determining Data Types (Exercise)
- Create a Table in Design View
- Creating a Table in Design View (Exercise)
- Queries
- Queries
- Select Queries
- Select Queries with Criteria
- Logical Operators
- Group and Total with Queries
- Creating Select Queries (Exercise)
- Forms
- Forms
- Alter a Form
- Adding Data Records in Form View (Exercise)
- Form Record Navigation
- Layout View and Design View
- One-Click Forms
- Form Wizard
- Creating a Form with the Form Wizard (Exercise)
- Reports
- Reports
- Report Wizard
- Creating a Report with the Report Wizard (Exercise)
- Databases and Access Terms
- Database Defined
- Databases vs. Spreadsheets
- Access vs. Excel
- Relational Database Defined
- Understanding Relational Databases (Exercise)
- Relational Database Management System (RDBMS) Defined
- Access is an RDBMS
- Creating a Relationship
- Benefits and Limitations of Access
Required Prerequisites
- Familiarity with using a personal computer, mouse, and keyboard.
- Comfortable in the Windows environment.
- Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
License
Length: 2
days | $40.00 per copy
What is Included?
- Student Manual
- Student Class Files