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
- Chapter 1 : Introduction to the Beginner's Course
- Chapter 2 : Get Started with Access 2021
- Chapter 3 : Work with Tables
- Chapter 4 : Import Data
- Chapter 5 : Datasheet View
- Chapter 6 : Create Relationships
- Chapter 7 : Forms
- Chapter 8 : Subforms
- Chapter 9 : Queries
- Chapter 10 : Validations and Expressions
- Chapter 11 : Reports
- Chapter 12 : More Data Types
- Chapter 13 : More About Forms
- Chapter 14 : Share an Access Database
- Chapter 15 : Additional Access Features
- Chapter 16 : Beginner Course Close
- Chapter 17 : Introduction to the Advanced Course
- Chapter 18 : Primary Keys and Indexes
- Chapter 19 : Using Datasheet View
- Chapter 20 : Linking to Other Access Databases
- Chapter 21 : Using ODBC and SQL Servers
- Chapter 22 : Splitting an Access Database
- Chapter 23 : Macros
- Chapter 24 : The Ribbon
- Chapter 25 : Visual Basic for Applications
- Chapter 26 : Access Events Model
- Chapter 27 : Forms
- Chapter 28 : Advanced Use of Queries
- Chapter 29 : Protecting the Database and Code
- Chapter 30 : Conclusion
Product information
- Title: Microsoft Access 2021 - Beginner to Advanced
- Author(s):
- Release date: August 2023
- Publisher(s): Packt Publishing
- ISBN: 9781835469118
You might also like
video
Microsoft Excel 2021/365 - Beginner to Advanced
Microsoft has released its latest stand-alone Excel version, which opens up many of the features and …
video
The Complete Excel Guide: Beginners to Advanced
Everyone knows that the Microsoft Office suite is used by millions worldwide. Unlocking its full potential …
video
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Microsoft Power BI is an interactive data visualization software primarily focusing on business intelligence, part of …
video
Microsoft Power BI - A Complete Introduction [2023 EDITION]
Learn to achieve your business intelligence goals with Power BI’s comprehensive tools in this video course. …