Microsoft Access 2021 Advanced: Expert Database Management

Focused View

Simon Sez IT

6:31:36

93 View

1. Introduction

1. Course Introduction.mp4

02:08

2. WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

3.1 Access 2021 Advanced Course Exercise Files.zip

3. DOWNLOAD ME Course Exercise Files.html

4.1 Access 2021 Advanced Course Files.zip

4. DOWNLOAD ME Course Demo Files.html

5.1 Access 2021 Advanced transcription.pdf

5. Downloadable Course Transcript.html

6. Set Up for Success in Access 2021.mp4

03:01

7. Section Quiz.html

2. Primary Keys and Indexes

1. Primary Keys and Indexing Rules and Guidelines.mp4

09:21

2. More About Indexes.mp4

08:04

3. Section Quiz.html

3. Using Datasheet View

1. Setup the Northwind Database.mp4

03:16

2. Work in a Datasheet View.mp4

11:00

3. Customize Datasheet View.mp4

09:03

4. Advanced Sorting and Filtering in Datasheet View.mp4

08:24

5. Subdatasheets.mp4

08:19

6. Exercise 01.mp4

00:52

7. Section Quiz.html

4. Linking to Other Access Databases

1. Linking Two Tables to Other Access Databases.mp4

11:37

2. Section Quiz.html

5. Using ODBC and SQL Server

1. Install SQL Server Express.mp4

09:24

2. Setup SQL Server Express.mp4

09:42

3. Exercise 02.mp4

01:14

4. Section Quiz.html

6. Splitting an Access Database

1. Splitting an Access Database into Frontend and Backend.mp4

07:35

2. Convert To Local Table.mp4

07:47

3. Addressing Multi-user Issues when Sharing Data.mp4

10:14

4. Exercise 03.mp4

01:52

5. Section Quiz.html

7. Macros

1. Basics of Macros.mp4

07:35

2. Macro on Events; AutoExec.mp4

11:07

3. More About AutoExec.mp4

11:50

4. Macro Security Settings.mp4

05:49

5. Exercise 04.mp4

02:46

6. Section Quiz.html

8. The Ribbon

1. Customize the Quick Access Toolbar and Tabs.mp4

09:57

2. Section Quiz.html

9. Visual Basic for Applications

1. Convert Macros to VBA.mp4

09:41

2. Run VBA Code and Error Handling.mp4

11:41

3. Create Modules Subs, Functions, Intellisense and Variables.mp4

09:59

4. Scope, Variable Naming and Strings.mp4

10:20

5. Standard Functions Logical, Case and Loops.mp4

11:05

6. Section Quiz.html

10. Access Events Model

1. Adding Events to Assets Database.mp4

06:47

2. Exercise 05.mp4

01:55

3. Common Events Form and Report Events.mp4

06:49

4. Switchboard, Navigation Forms and Error Handling.mp4

13:53

5. Exercise 06.mp4

05:05

6. Section Quiz.html

11. Forms

1. Formatting Bound and Control Forms.mp4

09:28

2. Split Forms and Macro Error Handling.mp4

11:59

3. Creating Form with Tab.mp4

09:04

4. Go To Combo Box and Its Properties.mp4

11:47

5. Exercise 07.mp4

04:58

6. Section Quiz.html

12. Advanced Use of Queries

1. Basics of Queries.mp4

11:19

2. Syntax of SQL Statements.mp4

12:42

3. Use of Multiple Where Criteria And Select Statements Function.mp4

10:32

4. Joins and Join Types.mp4

11:33

5. Exercise 08.mp4

00:37

6. Action Queries - Part 1.mp4

10:50

7. Action Queries - Part 2.mp4

10:46

8. Subqueries.mp4

03:59

9. Section Quiz.html

13. Protecting the Database and Code

1. Protect the Database and VBA Code.mp4

07:12

2. Exercise 09.mp4

00:56

3. Section Quiz.html

14. Conclusion

1. Course Close.mp4

02:31

Description

Make the leap from Access 2021 user to guru with this advanced course and bring your database skills to expert level.

What You'll Learn?

Understand indexing rules and guidelines
Work effectively in and customize datasheet view
Apply advanced sorting and filtering techniques
Link to tables in other Access databases
Address multi-user issues when sharing database files
Maximize the effective use of macros
Write, edit, debug, and run VBA code
Build advanced queries
Write and modify SQL statements.

Who is this for?

Experienced database managers or those who are familiar with Access 2021/365 or older.

Anyone who wants to learn data and database management using Microsoft Access

What You Need to Know?

A working knowledge of Microsoft Access including how to create and manage databases. This is an advanced course.

Microsoft Access 2021 downloaded and installed on your machine (ideal but not essential)

More details

Description
This course includes downloadable course files to work with and follow along.

Are you already familiar with the basics of Microsoft Access and eager to delve into more advanced concepts and features? Look no further! Welcome to our comprehensive training course, Microsoft Access 2021 Advanced, specifically designed for individuals like you who want to expand their expertise and maximize the potential of this powerful database application.

Building upon your current foundation with Microsoft Access, this course takes your database management skills to new heights, enabling you to tackle complex data challenges with confidence and efficiency.

Our training program is tailored to meet the needs of intermediate and advanced users who seek to master the intricacies of Access 2021. Whether you are a seasoned data professional, a database administrator, a software developer, or an aspiring power user, this course will equip you with the skills and knowledge necessary to harness the full potential of Microsoftâ€™s advanced database management techniques.

Throughout the course, you will embark on an immersive learning journey, exploring a wide range of advanced topics. We will guide you through mastering complex queries, optimizing database performance, writing SQL code, developing macros, leveraging advanced forms and reports, and integrating Access with other applications and data sources.

Whether you aspire to become a database expert, advance your career, or enhance your problem-solving abilities, this course will meet you at your skill level and provide the necessary guidance to become proficient in Microsoft Access 2021. Our goal is to empower you with the skills and knowledge to tackle complex data challenges, optimize performance, and leverage

In this course, you will learn how to:
Create primary keys
Understand indexing rules and guidelines
Set up the sample â€˜Northwindâ€™ database
Work efficiently in datasheet view
Customize datasheet view
Apply advanced sorting and filtering techniques
Create sub-datasheets
Link to tables in other Access databases
Install and set up SQL Server Express
Split an Access database into front end and back end
Convert tables to local tables
Address multi-user issues when sharing database files
Work through the basics of macros
Modify the AutoExec macro
Understand macro events
Adjust macro security settings
Handle macro errors
Customize the quick access toolbar
Convert macros to VBA code
Write and run VBA code
Understand VBA error handling
Create modules, subs, functions, IntelliSense, and variables
Name variables and strings
Work with standard functions
Add events to a database
Create switchboards and navigation forms.
Format bound and control forms
Split forms
Create tabbed forms
Adjust combo-box properties
Build advanced queries
Write and modify SQL statements
Understand joins and join types
Work with action queries
Create subqueries
Protect the database and VBA code.

This course includes:
6+ hours of video tutorials
50 individual video lectures
Course and Exercise Files to follow along
Certificate of completion
Who this course is for:
Experienced database managers or those who are familiar with Access 2021/365 or older.
Anyone who wants to learn data and database management using Microsoft Access

User Reviews

Rating

average 0

Total votes0

Focused display

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 8,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 630,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.