Ultimate Microsoft Access 2019 Bundle: Beginner - Advanced

Focused View

Simon Sez IT

15:45:13

193 View

1 - Access 2019 Beginners Introduction

1 - Introduction to Access 2019.mp4

03:19

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

02:11

3 - Access-2019-Exercise-Files.zip

3 - DOWNLOAD ME Course Exercise Files.html

4 - Access-2019-Course-Demo-Files.zip

4 - DOWNLOAD ME Course Demo Files.html

5 - DOWNLOAD ME Course Transcripts.html

5 - Learn-Access-2019.pdf

6 - Acquiring Access 2019.mp4

04:24

7 - Structure of the Course.mp4

02:23

2 - Access 2019 Beginners Getting Started with Access 2019

8 - Using Database Templates.mp4

10:56

9 - Creating Saving and Opening Databases.mp4

06:41

10 - The Access Workspace and Backstage.mp4

13:41

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

08:42

3 - Access 2019 Beginners The Ribbon and Toolbars

12 - Working with the Ribbon.mp4

09:28

13 - The Quick Access Toolbar.mp4

05:57

14 - Contextual Menus.mp4

02:39

15 - The Status Bar.mp4

04:07

4 - Access 2019 Beginners Keyboard Shortcuts and Key Tip

16 - Keyboard Shortcuts.mp4

03:36

17 - Key Tips.mp4

03:52

5 - Access 2019 Beginners Access Options

18 - Exploring Access Options.mp4

09:15

6 - Access 2019 Beginners Tables

19 - Creating a Table and Fields.mp4

11:30

20 - Indexed Field.mp4

08:42

21 - Lookup Wizard.mp4

11:35

22 - Numeric Fields.mp4

07:46

23 - Practice Exercise 01.mp4

03:07

7 - Access 2019 Beginners Importing Data

24 - Importing Data from Excel.mp4

10:57

25 - Practice Exercise 02.mp4

05:38

8 - Access 2019 Beginners Backup Restore and Repair

26 - Backing up your Database.mp4

03:56

27 - Compact and Repair.mp4

06:23

9 - Access 2019 Beginners Datasheet View

28 - Design in the Datasheet View.mp4

10:12

29 - Sorting and Filtering in Datasheet View.mp4

09:56

30 - Entering and Modifying Data in Datasheet View.mp4

10:56

10 - Access 2019 Beginners Relationships

31 - Creating a Link Table.mp4

10:35

32 - Setting up Relationships.mp4

09:55

33 - Practice Exercise 03.mp4

10:21

11 - Access 2019 Beginners Forms

34 - Creating a Form.mp4

12:41

35 - Modifying a Form.mp4

05:15

36 - Practice Exercise 04.mp4

02:08

37 - Forms in Layout View.mp4

11:11

38 - Forms in Design View.mp4

10:00

39 - Form Design.mp4

11:11

40 - Practice Exercise 05.mp4

01:33

12 - Access 2019 Beginners Subforms

41 - Setting Up Subforms Part 1.mp4

13:02

42 - Setting Up Subforms Part 2.mp4

09:13

43 - Setting Up Subforms Part 3.mp4

13:24

44 - Practice Exercise 06.mp4

04:13

13 - Access 2019 Beginners Queries

45 - Creating a Query.mp4

13:27

46 - Joins.mp4

08:30

47 - Query Wizard.mp4

12:39

48 - Practice Exercise 07.mp4

09:45

14 - Access 2019 Beginners Expressions

49 - Setting Up Validations.mp4

10:40

50 - Calculation using Expressions.mp4

08:43

15 - Access 2019 Beginners Reports

51 - Basic Reports.mp4

07:46

52 - Report Design.mp4

10:43

53 - Complex Reports.mp4

13:29

54 - Practice Exercise 08.mp4

02:23

16 - Access 2019 Beginners Printing

55 - Printing and Print Properties.mp4

07:54

17 - Access 2019 Beginners More Data Types

56 - YesNo OLE Objects and Hyperlink Data Types.mp4

11:21

18 - Access 2019 Beginners More About Forms

57 - Form Controls.mp4

11:15

58 - Form Themes.mp4

12:37

59 - Navigation Forms.mp4

09:52

19 - Access 2019 Beginners Exporting

60 - Exporting an Access Database.mp4

04:16

20 - Access 2019 Beginners Application Parts

61 - Adding Application Parts to a Database.mp4

04:48

21 - Access 2019 Beginners More Access Options

62 - Additional Access 2019 Options.mp4

05:42

22 - Access 2019 Beginners Info Tab

63 - Edit Database Properties and Encrypt with Password.mp4

05:31

23 - Access 2019 Beginners Course Close

64 - Course Close.mp4

01:06

24 - Access 2019 Advanced Introduction

65 - Course Overview and Content.mp4

05:07

66 - WATCH ME Essential Information for a Successful Training Experience.mp4

02:03

67 - Access-2019-Advanced-Exercise-Files.zip

67 - DOWNLOAD ME Course Exercise Files.html

68 - Access-Advanced-2019.pdf

68 - Downloadable Course Transcripts.html

25 - Access 2019 Advanced Primary Keys and Indexes

69 - Primary Keys and Indexing Rules and Guidelines.mp4

09:54

70 - More About Indexes.mp4

08:36

26 - Access 2019 Advanced Using Datasheet View

71 - Settingup Northwind Database.mp4

03:34

72 - Working in a Datasheet View.mp4

11:04

73 - Customizing Datasheet View and Advanced Sorting and Filtering.mp4

17:14

74 - Subdatasheets.mp4

09:24

75 - Exercise 01.mp4

01:06

27 - Access 2019 Advanced Linking to Other Access Databases

76 - Linking Two Tables to Other Access Databases.mp4

13:24

28 - Access 2019 Advanced Using ODBC and SQL Server

77 - Acquiring and Installing SQL Server Express.mp4

11:36

78 - Setting Up SQL Server Database.mp4

13:41

79 - Exercise 02.mp4

01:17

29 - Access 2019 Advanced Splitting an Access Database

80 - Splitting an Access Database into Frontend and Backend.mp4

09:39

81 - Converting Shared Table into Local Table Moving Backend Database.mp4

11:25

82 - Exercise 03.mp4

01:48

83 - Addressing Multiuser Issues when Sharing Data.mp4

09:54

30 - Access 2019 Advanced Macros

84 - Basics of Macros.mp4

13:26

85 - Macros on Events AutoExec.mp4

12:01

86 - More About AutoExec Bypassing AutoExec.mp4

16:12

87 - Macro Security Settings.mp4

06:32

88 - Exercise 04.mp4

04:09

31 - Access 2019 Advanced The Ribbon

89 - Customizing the Ribbon and Quick Access Tool.mp4

13:11

32 - Access 2019 Advanced Visual Basic for Applications

90 - Convert Macros to VBA VBA Editor and Property Windows.mp4

12:06

91 - VBA Modules Running Code and Error Handling.mp4

14:41

92 - Creating Modules Subs Functions Intellisense and Variables.mp4

12:56

93 - Scope Variable Naming and Strings.mp4

13:46

94 - Standard Functions Logical Case and Loop Statements.mp4

15:15

33 - Access 2019 Advanced Access Events Model

95 - Adding Events to Assets Database.mp4

11:00

96 - Exercise 05.mp4

01:57

97 - Common Events Form and Report Events.mp4

12:24

98 - Switchboard and Navigation Form Error Handling.mp4

14:54

99 - Exercise 06.mp4

06:48

34 - Access 2019 Advanced Forms

100 - Formatting Bound and Control Form.mp4

13:19

101 - Split Forms Macro Error Handling.mp4

13:54

102 - Creating Form with Tab.mp4

12:26

103 - Go To Combo Box and Its Properties.mp4

10:06

104 - Exercise 07.mp4

05:08

35 - Access 2019 Advanced Advanced Use of Queries

105 - Basics of Queries.mp4

11:37

106 - Syntax of SQL Statements.mp4

15:22

107 - Use of Multiple Where Criteria & Select Statements Function.mp4

11:28

108 - Exercise 08.mp4

00:46

109 - Action Queries Part 1.mp4

14:20

110 - Action Queries Part 2.mp4

10:55

36 - Access 2019 Advanced Packaging You Application

111 - Steps in Packaging Access Application.mp4

13:10

112 - Exercise 9.mp4

00:55

37 - Extras

113 - Access-Shortcuts.pdf

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

38 - Conclusion

114 - Course Close.mp4

00:45

Description

Master Microsoft Access with this comprehensive beginner to advanced MS Access course

What You'll Learn?

Discover how to effectively link to other data sources.
Learn how to split a database by splitting the frontend and backend.
Explore the use of Visual Basic for Applications (VBA).
Practice what you learned with included exercise files
Sorting information and running queries
Creating tables and relationships
Navigating the Access 2019 interface
Design forms and generate reports
Learn valuable new skills for complex data projects at work
Supercharge your database projects
Discover how to into import data from Excel
Learn Queries, use validations, how to create and print reports
How to compact, repair and backup your database
How to create a linked table
Discover how to use the Query Wizard
Learn to use Model Dialog and Macros
Discover advanced options for the use of forms.
Dive into options for packaging your application for distribution.
Follow along as you learn to create and maintain macros.
Get helpful techniques that allow you to link, report, and package your data quickly.

Who is this for?

Anyone new to Microsoft Access

Experienced database managers or those who are familiar with Access 2016 or 2013

Users new to Microsoft Access 2019 and those upgrading from previous software versions

Anyone new to the data management role

Anyone who wants to learn data management and Microsoft Access

More details

Description
This course includes practice exercises and LIFETIME access

Microsoft Access remains an amazing tool for when your data outgrows spreadsheets. Unlike many other database tools, itâ€™s far more user-friendly and ideal if youâ€™re not a developer.

This huge-value Microsoft Access bundle is made up of two full MS Access courses, Access for Beginners and Access Advanced. If you are brand new to Microsoft Access, that's no problem. We start at the very beginning and take you on a journey to becoming an Access database superstar.
We take a project approach to this course, which means you build your own project out as we go. By the end of this Access 2019 course, you will be using Advanced Access functions such as VBA and Macros and SQL.

In the Microsoft Access Beginners course you will learn:
Where to start in Microsoft Access and whether to use a template or not
How to modify Access to suit your needs
All about importing data and the datasheet view
How tables work in Access and how to create relationships between them
Creating forms and sub-forms that feed data into your tables
How to run queries in Access
Setting up validations and calculations using expressions in Access
Printing from Access
To start to use macros and Modal Dialog
The basics of the Access web app
Exporting and reporting in Access

In the Microsoft Access Advanced course you will learn:
All about Primary Keys and Indexes in Access
About customizing and filtering on the Datasheet View
How to link to other databases
All about using ODBC and SQL Server
How to split an Access database into front and back-end
All about Macros in Access including AutoExec
How to do basic VBA in Access including code and error handling
More advanced techniques around creating forms in Access
Advanced queries including â€œmultiple whereâ€ criteria
Exercise and demo files included

This course includes:
14+ hours of video tutorials
100+ individual video lectures
Exercise files to practice what you learned
Certificate of completion
This course is designed for students that are new to Microsoft Access, are upgrading from a previous version, or have a basic understanding and are looking to sharpen their skills. If youâ€™ve been using Access for years but are convinced that youâ€™re not utilizing its full potential, then you need this course.

If your Excel spreadsheets keep crashing with too much data, then itâ€™s time you got to know Microsoft Access. Let us show you how.

Hereâ€™s what our students are sayingâ€¦
â€œThis was a great course. I already had a base in some of these programs, but this has taken my understanding to a whole new level!â€
- Nathaniel Andrew Putnam
â€œGreat course!

I've created some decent Access databases in years past but it was mostly self taught through reading and some early YouTube videos. There was much that I didn't know or comprehend that left my databases incomplete or didn't perform the way I wanted. This course explains all of the things I was missing.

Tons of information provided and explained very well. Access is very powerful with so many options, properties, and such that it will take a beginner quite some time to become proficient but this course explains so much, with many examples that reinforce learning. Macros, SQL, and VBA, has been a big mystery for years...for me. The instructor walks you through the basics and now I have a foundation to pursue these topics further without hesitation.

The instructor is pleasant to listen to and is very organized in the information given, both in order and detail.â€
- David Keach
â€œI am using access 2019 and this course is very informative. I want to say think you for taking your time and explaining each step. I recommend this course to everyone who wants to improve their access knowledge.â€
- Adam Hanek

Did you know?

Simon Sez IT teaches all sorts of software, including:
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Word
- Microsoft Project
- Microsoft Outlook
- QuickBooks
- Photoshop Elements
- Web Development Languages
- And so much more!
Who this course is for:
Anyone new to Microsoft Access
Experienced database managers or those who are familiar with Access 2016 or 2013
Users new to Microsoft Access 2019 and those upgrading from previous software versions
Anyone new to the data management role
Anyone who wants to learn data management and Microsoft Access

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Access

Simon Sez IT

Instructor's Courses

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.