Microsoft Access 2021 Advanced: Expert Database Management

سرفصل های دوره

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

1. Introduction

1. Course Introduction

2. WATCH ME Essential Information for a Successful Training Experience

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

7. Section Quiz.html

2. Primary Keys and Indexes

1. Primary Keys and Indexing Rules and Guidelines

2. More About Indexes

3. Section Quiz.html

3. Using Datasheet View

1. Setup 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

7. Section Quiz.html

4. Linking to Other Access Databases

1. Linking Two Tables to Other Access Databases

2. Section Quiz.html

5. Using ODBC and SQL Server

1. Install SQL Server Express

2. Setup SQL Server Express

3. Exercise 02

4. Section Quiz.html

6. 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

5. Section Quiz.html

7. Macros

1. Basics of Macros

2. Macro on Events; AutoExec

3. More About AutoExec

4. Macro Security Settings

5. Exercise 04

6. Section Quiz.html

8. The Ribbon

1. Customize the Quick Access Toolbar and Tabs

2. Section Quiz.html

9. 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

6. Section Quiz.html

10. 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

6. Section Quiz.html

11. 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

6. Section Quiz.html

12. 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

9. Section Quiz.html

13. Protecting the Database and Code

1. Protect the Database and VBA Code

2. Exercise 09

3. Section Quiz.html

14. Conclusion

1. Course Close

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy