Introduction to Microsoft Access 365 Training (ACC365.1)

Welcome to the Introduction to Microsoft Access 365 Training course, specially designed for companies looking to enhance their employees' proficiency in database management or for individuals seeking to improve their skills in Microsoft Access. This course caters to both groups and can significantly boost productivity by enabling efficient handling of data and databases within your organization.

Begin your journey with an engaging lesson on the Quick Overview Access Interface, where you’ll discover how to navigate the Access environment data ribbons, Quick Access Toolbar, and Object Navigation Pane. Through practical exercises, you’ll get comfortable with the Access Work Surface, allowing you to create a database using a wizard to apply your newfound skills immediately.

Next, you dive into the Fundamentals of database design, where you will learn the essential questions to address before initiating a project, alongside exercises to reinforce these concepts. Engage in activities designed to teach you effective approaches to database design, gathering information, and understanding naming conventions. Learn about normalization, table relationships, and practice normalizing data to ensure your database operates efficiently and logically.

The course will then guide you through Tables and Their Views, highlighting their definition and purpose, and providing exercises for working with tables in Datasheet View. You’ll also learn how to import a table of data and practice using Design View to customize your tables effectively.

In the Tables section, you’ll gain practical experience in creating an Access database and defining appropriate data types. The hands-on exercises included will enhance your capabilities in creating tables in Design View, ensuring you can handle data with precision.

Explore the powerful tool of Queries to extract information from your databases. This lesson covers the creation of select queries, use of selection criteria, logical operators, and grouping functionalities to analyze data effectively. Engage in exercises that reinforce the creation of select queries to solidify your understanding.

With the Forms lesson, you’ll learn how to alter forms, navigate records, and add data records in Form View. Gain insights into Layout View and Design View, and create forms effortlessly with the Form Wizard and one-click methods, enhancing how data is inputted and displayed.

Build and analyze reports efficiently with the Reports section, learning to use the Report Wizard skillfully. An exercise on creating reports with the Report Wizard will solidify your competence in presentation and data interaction.

The final lesson focuses on Databases and Access Terms, where you’ll explore the nature of databases, distinctions between databases and spreadsheets, and the benefits Access holds over Excel. You’ll dive into understanding relational databases, creating relationships, and assessing the benefits and limitations of Access as a Relational Database Management System (RDBMS).

Upon completing this course, you will have gained a well-rounded introduction to Microsoft Access 365, equipping you or your team to efficiently create, manage, and manipulate databases. This training ensures you are prepared to streamline and enhance your data management tasks, providing a solid foundation for further exploration of Access's capabilities.

1. Databases and Access Terms
   1. Database Defined
   2. Databases vs. Spreadsheets
   3. Access vs. Excel
   4. Spreadsheet or Database (Exercise)
   5. Relational Database Defined
   6. Understanding Relational Databases (Exercise)
   7. Relational Database Management System (RDBMS) Defined
   8. Access is an RDBMS
   9. Creating a Relationship
   10. Benefits and Limitations of Access
2. Quick Overview Access Interface
   1. Access Ribbon
   2. Quick Access Toolbar
   3. Object Navigation Pane
   4. Access Work Surface
   5. Object Overview
   6. Process Overview
   7. Getting Around the Access Environment (Exercise)
   8. Create a Database Using a Wizard
3. Fundamentals
   1. Questions to Ask Before You Start
   2. Asking Questions (Exercise)
   3. Approaches to Database Design
   4. Gather Information
   5. A Few Words about Naming Conventions
   6. Gathering Information (Exercise)
   7. Normalization
   8. Table Relationships
   9. Normalizing Data (Exercise)
4. Tables and Their Views
   1. Definition and Purpose
   2. Datasheet View
   3. Working with Tables in Datasheet View (Exercise)
   4. Import a Table of Data
   5. Design View
5. Tables
   1. Creating an Access Database
   2. Creating a New Database (Exercise)
   3. Data Types
   4. Determining Data Types (Exercise)
   5. Create a Table in Design View
   6. Creating a Table in Design View (Exercise)
   7. Link a Table of Data
6. Queries
   1. Queries
   2. Select Queries
   3. Select Queries with Criteria
   4. Logical Operators
   5. Group and Total with Queries
   6. Creating Select Queries (Exercise)
7. Forms
   1. Forms
   2. Alter a Form
   3. Adding Data Records in Form View (Exercise)
   4. Form Record Navigation
   5. Layout View and Design View
   6. One-Click Forms
   7. Form Wizard
   8. Creating a Form with the Form Wizard (Exercise)
8. Reports
   1. Reports
   2. Report Wizard
   3. Creating a Report with the Report Wizard (Exercise)

Each student receives a comprehensive set of materials, including course notes and all class examples.