Microsoft Access 2021 : beginner to advanced.

[First edition].

[Place of publication not identified] : Packt Publishing, 2023.

1 online resource (1 video file (13 hr., 39 min.)) : sound, color.

Access is available to the Yale community.

Access restricted by licensing agreement.

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.

O'Reilly Safari. OCLC KB.

Images / Online / Video & Film

English

October 03, 2023

Simon Sez IT, presenter.