Microsoft Access 2019 Beginners Course

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

Learn to harness the power of Microsoft Access and get control of your data with this 2019 course.

1 - Introduction

1 - Introduction to Access 2019

2 - WATCH ME Essential Information for a Successful Training Experience

3 - Download Course Transcripts.html

3 - Learn-Access-2019.pdf

4 - Acquiring Access 2019

5 - Structure of the Course

6 - Access-2019-Exercise-Files.zip

6 - Course Exercise Files.html

7 - Access-2019-Course-Files.zip

7 - Course Demo Files.html

2 - Getting Started with Access 2019

8 - Using Database Templates

9 - Creating Saving and Opening Databases

10 - The Access Workspace and Backstage

11 - Online Help and Tell Me What You Want To Do

3 - The Ribbon and Toolbars

12 - Working with the Ribbon

13 - The Quick Access Toolbar

14 - Contextual Menus

15 - The Status Bar

4 - Keyboard Shortcuts and Key Tip

16 - Keyboard Shortcuts

17 - Key Tips

5 - Access Options

18 - Exploring Access Options

6 - Tables

19 - Creating a Table and Fields

20 - Indexed Field

21 - Lookup Wizard

22 - Numeric Fields

23 - Practice Exercise 01

7 - Importing Data

24 - Importing Data from Excel

25 - Practice Exercise 02

8 - Backup Restore and Repair

26 - Backing up your Database

27 - Compact and Repair

9 - Datasheet View

28 - Design in the Datasheet View

29 - Sorting and Filtering in Datasheet View

30 - Entering and Modifying Data in Datasheet View

10 - Relationships

31 - Creating a Link Table

32 - Setting up Relationships

33 - Practice Exercise 03

11 - Forms

34 - Creating a Form

35 - Modifying a Form

36 - Practice Exercise 04

37 - Forms in Layout View

38 - Forms in Design View

39 - Form Design

40 - Practice Exercise 05

12 - Subforms

41 - Setting Up Subforms Part 1

42 - Setting Up Subforms Part 2

43 - Setting Up Subforms Part 3

44 - Practice Exercise 06

13 - Queries

45 - Creating a Query

46 - Joins

47 - Query Wizard

48 - Practice Exercise 07

14 - Expressions

49 - Setting Up Validations

50 - Calculation using Expressions

15 - Reports

51 - Basic Reports

52 - Report Design

53 - Complex Reports

54 - Practice Exercise 08

16 - Printing

55 - Printing and Print Properties

17 - More Data Types

56 - YesNo OLE Objects and Hyperlink Data Types

18 - More About Forms

57 - Form Controls

58 - Form Themes

59 - Navigation Forms

19 - Exporting

60 - Exporting an Access Database

20 - Application Parts

61 - Adding Application Parts to a Database

21 - More Access Options

62 - Additional Access 2019 Options

22 - Info Tab

63 - Edit Database Properties and Encrypt with Password

23 - Extras

64 - Access-Shortcuts.pdf

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

24 - Course Close

65 - Course Close

235,000 تومان

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

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

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

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