77-730: Microsoft Access – from beginner to Specialist

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

Learn what Microsoft want you to know for their database certification.

1 - Introduction

1 - Introduction

2 - Welcome to Udemy.html

3 - Introduction to Udemy

4 - Do you want autotranslated subtitles in more languages.html

5 - Curriculum

6 - Final Databases.html

6 - MyFirstDatabase.zip

6 - MySecondDatabase.zip

2 - Level 1 Section 1 Creating a database

7 - Opening Microsoft Access and Creating a blank database

8 - Lets take a look around

9 - Opening the Northwind Database

10 - Create a database from a template

11 - Practice Activity Number 1.html

12 - Practice Activity Number 1 Solution

3 - Level 1 Section 2 Create tables

13 - Create a table

14 - Navigating tables

15 - Copying and pasting data

16 - Practice Activity Number 2.html

16 - ShoppingList.xlsx

17 - Practice Activity Number 2 Solution

4 - Level 1 Section 3 Creating forms reports and queries

18 - Create a form

19 - Other form types

20 - Create a report based on the table

21 - Create a report by using a wizard

22 - Create a query using the Query Design

23 - Create a query by using a wizard

24 - Practice Activity Number 3.html

25 - Practice Activity Number 3 Solution

5 - Level 2 Section 1 Developing tables in the Datasheet view

26 - Find and replace data

27 - Manage records in tables

28 - Advanced filter

29 - Managing tables

30 - Create and modify fields

31 - Add validation rules

32 - Practice Activity Number 4.html

33 - Practice Activity Number 4 Solution

6 - Level 2 Section 2 Developing tables in the design view

34 - Introducing the Design View and changing the number field type

35 - Using Input Masks

36 - Primary Keys and Autonumbers

37 - Using Lookup Values

38 - Practice Activity Number 5.html

39 - Practice Activity Number 5 Solution

7 - Level 2 Section 3 Good table design

40 - Introducing Normal Forms

41 - First Normal Form

42 - Second Normal Form

43 - Third Normal Form

8 - Level 2 Section 4 Manage multiple tables relationships and keys

44 - ImportData.xlsx

44 - Import data from Excel spreadsheets

45 - Append data and link data

46 - Create relationships between tables

47 - Enforce referential integrity

48 - Cascade Update Related Fields

49 - Cascade Delete Related Records

50 - Subdatasheets and miscellaneous relationships options

51 - Documenting your Database

52 - Practice Activity Number 6.html

53 - Practice Activity Number 6 Solution

9 - Level 3 Section 1 Modifying queries and grouping within queries

54 - Modifying queries

55 - CustomFormatting.pdf

55 - Formatting in queries

56 - Group and summarize data

57 - Set filtering criteria Text

58 - Set filtering criteria on results

59 - Set filtering criteria on NULLs

60 - Practice Activity Number 7.html

61 - Practice Activity Number 7 Solution

10 - Level 3 Section 2 Create calculated fields and grouping

62 - Creating our first calculated field

63 - DateTime Functions

64 - Math and Text Functions

65 - Group Data Using Operators

66 - Practice Activity Number 8.html

67 - Practice Activity Number 8 Solution

11 - Level 3 Section 3 Create various types of queries

68 - Create a multitable query

69 - Searching for missing information

70 - Create a parameter query

71 - Create a crosstab query

72 - Create an action query

73 - Create an append query

74 - Practice Activity Number 9.html

75 - Practice Activity Number 9 Solution

12 - Level 4 Section 1 Create and configure forms

76 - Create a report Recap

77 - Move form controls

78 - Add form controls

79 - Set form control properties Data Event and Other tabs

80 - Set form control properties Format tab

81 - Applying table layouts

82 - Practice Activity Number 10.html

83 - Practice Activity Number 10 Solution

13 - Level 4 Section 2 Subforms and data sources

84 - Add subforms

85 - Modify data sources

86 - Create a form from a template with application parts

87 - Create Navigation forms

14 - Level 4 Section 3 Format a form

88 - Modify tab order in forms

89 - Insert headers and footers

90 - Themes sorting and print settings

15 - Level 5 Section 1 Create reports

91 - You already know how to do this

92 - Practice Activity Number 11.html

93 - Practice Activity Number 11 Solution

94 - Group and Sort fields

16 - Level 5 Section 2 Protect and maintain databases

95 - Protect and maintain databases

96 - Print and export data

17 - The End

97 - Thank you very much

98 - Bonus Lecture

98 - idodatabonuslecture230113.zip

45,900 تومان

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

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

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

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