Microsoft Access 2016 Intermediate/Advanced Course

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

The ultimate next step for anyone interested in supercharging their Microsoft Access and data analysis skills

1 - Introduction to Microsoft Access 2016 Advanced

1 - Course Overview and Content

2 - WATCH ME Essential Information for a Successful Training Experience

3 - Access-2016-Advanced-Exercise-Files.zip

3 - DOWNLOAD ME Course Exercise Files.html

4 - Access-2016-Advanced-Course-Files.zip

4 - DOWNLOAD ME Course Demo Files.html

2 - Primary Keys and Indexes

5 - Primary Keys and Indexing Rules and Guidelines

6 - More About Indexes

3 - Using Datasheet View

7 - Settingup Northwind Database

8 - Working in a Datasheet View

9 - Customizing Datasheet View and Advanced Sorting and Filtering

10 - Subdatasheets

11 - Exercise 01

4 - Linking to Other Access Databases

12 - Linking Two Tables to Other Access Databases

5 - Using ODBC and SQL Server

13 - Acquiring and Installing SQL Server Express

14 - Setting up SQL Server Database

15 - Exercise 2

6 - Splitting An Access Database

16 - Splitting an Access Database into Frontend and Backend Databases

17 - Converting Shared Table into Local Table Moving Backend Database

18 - Exercise 3

19 - Addressing Multiusers Issues When Sharing Data

7 - Macros

20 - Basics of Macros

21 - Macros on Events AutoExec

22 - More About AutoExec Bypassing AutoExec

23 - Macro Security Settings

24 - Exercise 4

8 - The Ribbon

25 - Customizing the Ribbon and Quick Access Tool

9 - Visual Basic for Applications in Access 2016

26 - Convert Macros to VBA VBA Editor and Property Windows

27 - VBA Modules Running Code and Error Handling

28 - Creating Modules Subs Functions Intellisense and Variables

29 - Scope Variable Naming and Strings

30 - Standard Functions Logical Case and Loop Statements

10 - Access Events Model

31 - Adding Events to Assets Database

32 - Exercise 05

33 - Common Events Form and Report Events

34 - Switchboard and Navigation Form Error Handling

35 - Exercise 06

11 - Forms

36 - Formatting Bound and Control Form

37 - Split Forms Macro Error Handling

38 - Creating Form with Tab

39 - Go To Combo Box and Its Properties

40 - Exercise 07

12 - Advanced Use of Queries

41 - Basic of Queries Review

42 - Syntax of SQL Statements

43 - Use of Multiple Where Criteria Select Statements Function

44 - Joins and Its Types

45 - Exercise 08

46 - Action Queries Part 1

47 - Action Queries Part 2

48 - Subqueries

13 - Packaging Your Application

49 - Steps in Packaging Access Application

50 - Exercise 09

14 - Conclusion

51 - Online Support and Conclusion

15 - Extras

52 - Access-Shortcuts.pdf

52 - EXTRA RESOURCE The Most Frequently Used Access Shortcuts Infographic.html

235,000 تومان

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

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

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

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