Microsoft Access 2021 - Beginner to Advanced

Microsoft Access 2021 - Beginner to Advanced

by Simon Sez IT
Released August 2023
Publisher(s): Packt Publishing
ISBN: 9781835469118

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Access 2021 is so much more than a way to create customizable desktop databases. It is a full lifecycle database management tool that makes creating small to large databases easy. This bundle merges two courses, Access 2021 Beginners (Part 1) and Access 2021 Advanced (Part 2), providing a comprehensive learning experience.

You will start with relational database fundamentals and unlock the art of downloading, installing, and navigating Access 2021. Then navigate interfaces, utilizing ribbons, commands, and keyboard shortcuts. You will then master database creation by crafting tables, tweaking field properties, and comprehending index fields and primary keys. Elevate data quality through lookup menus and validation rules. Seamlessly import data, organize it with sorting and filtering techniques, and forge data relationships for comprehensive insights.

Next, work on crafting user-friendly forms, sub-forms, and navigation forms that guide data interaction. Delve into the intricacies of queries, from basic to complex, aggregating numeric data and crafting expressions for insightful calculations. Advance to linking tables across databases, addressing multi-user concerns, and automating tasks using macros and VBA coding. Finally, navigate advanced queries, and write and modify SQL statements.

By the end of this course, you will have gained a profound understanding of relational databases and the art of efficient database management using Access 2021.

What You Will Learn

  • Download, install, and navigate the interface of Access 2021
  • Create tables and fields for organized data structure
  • Understand index fields and primary keys for data integrity
  • Craft lookup menus for enhanced data interaction
  • Import data from Excel and text files, enriching your dataset
  • Write, edit, debug, and run VBA code along with building advanced queries

Audience

This course is tailor-made for individuals at the absolute beginner level or those seeking to refresh their foundational skills in database management. If you are looking to establish a solid foundation or have aspirations of becoming a seasoned database expert, aiming to advance your career, this course is designed to provide an exceptional starting point.

This course is your gateway to unparalleled expertise in database management, regardless of your current level of proficiency.

No prior knowledge of Microsoft Access is required.

About The Author

Simon Sez IT: Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs.

Simon Sez IT ensures stress-free eLearning and enhanced employee productivity—whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.

Table of contents

  1. Chapter 1 : Introduction to the Beginner's Course
    1. Introduction to Access 2021
    2. Acquiring Access 2021
    3. What's New in Access 2021?
    4. Exercise 01
  2. Chapter 2 : Get Started with Access 2021
    1. Use Database Templates
    2. Create, Save, and Open Databases
    3. Explore the Access Interface and Backstage
    4. Customize the Quick Access Toolbar
    5. Access Menus
    6. Keyboard Shortcuts and Key Tips
    7. Online Help
    8. Access Options
    9. Exercise 02
  3. Chapter 3 : Work with Tables
    1. Create a Table and Fields
    2. Index Fields, Primary Keys, and Add Records
    3. Use the Lookup Wizard to Create a Drop-Down List
    4. Numeric Fields and Data Validation Rules
    5. Add More Table Fields
    6. Exercise 03
  4. Chapter 4 : Import Data
    1. Importing Data from Excel
    2. Importing Data from a Text File
    3. Exercise 04
  5. Chapter 5 : Datasheet View
    1. Design in the Datasheet View
    2. Sort and Filter in Datasheet View
    3. Enter and Modify Data in Datasheet View
    4. Exercise 05
  6. Chapter 6 : Create Relationships
    1. Relationships Explained
    2. Set Up Relationships
    3. Create a Link Table: Part 1
    4. Create a Link Table: Part 2
    5. Edit the Link Table
    6. Exercise 06
  7. Chapter 7 : Forms
    1. Create a Form: Form Wizard
    2. Form Properties
    3. Modify a Form: Single Form Versus Continuous View
    4. Forms in Layout View
    5. Forms in Design View
    6. Exercise 07
  8. Chapter 8 : Subforms
    1. Setting Up Subforms: Part 1
    2. Setting Up Subforms: Part 2
    3. Exercise 08
  9. Chapter 9 : Queries
    1. Create a Query
    2. INNER, RIGHT, and LEFT Joins
    3. Run Queries and Aggregate Numeric Data Using Query Wizard
    4. Exercise 09
  10. Chapter 10 : Validations and Expressions
    1. Set Up More Validations and Expressions
    2. Basic Calculations Using Expressions
    3. Exercise 10
  11. Chapter 11 : Reports
    1. Run a Basic Report
    2. Custom Report Design
    3. Complex Reports
    4. Exercise 11
  12. Chapter 12 : More Data Types
    1. Other Data Types: Yes/No
    2. Other Data Types: Attachments
    3. Exercise 12
  13. Chapter 13 : More About Forms
    1. Form Controls: Option Buttons
    2. Form Themes and Design
    3. Navigation Forms
    4. Exercise 13
  14. Chapter 14 : Share an Access Database
    1. Export Parts of an Access Database
    2. Database Properties and Encryption
    3. Exercise 14
  15. Chapter 15 : Additional Access Features
    1. Compact and Repair
    2. Printing and Database Documenter
    3. Exercise 15
  16. Chapter 16 : Beginner Course Close
    1. Course Close
  17. Chapter 17 : Introduction to the Advanced Course
    1. Course Introduction
    2. Set Up for Success in Access 2021
  18. Chapter 18 : Primary Keys and Indexes
    1. Primary Keys and Indexing Rules and Guidelines
    2. More About Indexes
  19. Chapter 19 : Using Datasheet View
    1. Set Up the Northwind Database
    2. Work in a Datasheet View
    3. Customize Datasheet View
    4. Advanced Sorting and Filtering in Datasheet View
    5. Subdatasheets
    6. Exercise 01
  20. Chapter 20 : Linking to Other Access Databases
    1. Linking Two Tables to Other Access Databases
  21. Chapter 21 : Using ODBC and SQL Servers
    1. Install SQL Server Express
    2. Set Up SQL Server Express
    3. Exercise 02
  22. Chapter 22 : Splitting an Access Database
    1. Splitting an Access Database into Frontend and Backend
    2. Convert to Local Table
    3. Addressing Multi-User Issues When Sharing Data
    4. Exercise 03
  23. Chapter 23 : Macros
    1. Basics of Macros
    2. Macro on Events; AutoExec
    3. More About AutoExec
    4. Macro Security Settings
    5. Exercise 04
  24. Chapter 24 : The Ribbon
    1. Customize the Quick Access Toolbar and Tabs
  25. Chapter 25 : Visual Basic for Applications
    1. Convert Macros to VBA
    2. Run VBA Code and Error Handling
    3. Create Modules: Subs, Functions, Intellisense, and Variables
    4. Scope, Variable Naming, and Strings
    5. Standard Functions: Logical, Case, and Loops
  26. Chapter 26 : Access Events Model
    1. Adding Events to Assets Database
    2. Exercise 05
    3. Common Events: Form and Report Events
    4. Switchboard, Navigation Forms, and Error Handling
    5. Exercise 06
  27. Chapter 27 : Forms
    1. Formatting Bound and Control Forms
    2. Split Forms and Macro Error Handling
    3. Creating Form with Tab
    4. Go to Combo Box and Its Properties
    5. Exercise 07
  28. Chapter 28 : Advanced Use of Queries
    1. Basics of Queries
    2. Syntax of SQL Statements
    3. Use of Multiple Where Criteria and Select Statements Function
    4. Joins and Join Types
    5. Exercise 08
    6. Action Queries - Part 1
    7. Action Queries - Part 2
    8. Subqueries
  29. Chapter 29 : Protecting the Database and Code
    1. Protect the Database and VBA Code
    2. Exercise 09
  30. Chapter 30 : Conclusion
    1. Course Close

Product information

  • Title: Microsoft Access 2021 - Beginner to Advanced
  • Author(s): Simon Sez IT
  • Release date: August 2023
  • Publisher(s): Packt Publishing
  • ISBN: 9781835469118