Microsoft Access 2019 Beginners Course

Focused View

Simon Sez IT

8:08:58

141 View

1 - Introduction

1 - Introduction to Access 2019.mp4

03:19

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

02:11

3 - Download Course Transcripts.html

3 - Learn-Access-2019.pdf

4 - Acquiring Access 2019.mp4

04:24

5 - Structure of the Course.mp4

02:23

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.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 - 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 - Keyboard Shortcuts and Key Tip

16 - Keyboard Shortcuts.mp4

03:36

17 - Key Tips.mp4

03:52

5 - Access Options

18 - Exploring Access Options.mp4

09:15

6 - 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 - Importing Data

24 - Importing Data from Excel.mp4

10:57

25 - Practice Exercise 02.mp4

05:38

8 - Backup Restore and Repair

26 - Backing up your Database.mp4

03:56

27 - Compact and Repair.mp4

06:23

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

31 - Creating a Link Table.mp4

10:35

32 - Setting up Relationships.mp4

09:55

33 - Practice Exercise 03.mp4

10:21

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

49 - Setting Up Validations.mp4

10:40

50 - Calculation using Expressions.mp4

08:43

15 - 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 - Printing

55 - Printing and Print Properties.mp4

07:54

17 - More Data Types

56 - YesNo OLE Objects and Hyperlink Data Types.mp4

11:21

18 - More About Forms

57 - Form Controls.mp4

11:15

58 - Form Themes.mp4

12:37

59 - Navigation Forms.mp4

09:52

19 - Exporting

60 - Exporting an Access Database.mp4

04:16

20 - Application Parts

61 - Adding Application Parts to a Database.mp4

04:48

21 - More Access Options

62 - Additional Access 2019 Options.mp4

05:42

22 - Info Tab

63 - Edit Database Properties and Encrypt with Password.mp4

05:31

23 - Extras

64 - Access-Shortcuts.pdf

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

24 - Course Close

65 - Course Close.mp4

01:06

Description

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

What You'll Learn?

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

Who is this for?

Anyone new to Microsoft Access

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.

In this Microsoft Access beginners course, we start at the very beginning and assume you know nothing about MS Access. 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 have built out your own database with relevant functionality.

If youâ€™ve used Excel in the past that will help, but itâ€™s not essential. This course is really aimed at someone just starting out in Access.

In this 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

Exercise and demo files included

This course includes:
7.5 hours of video tutorials
59 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â€¦
â€œClearly explained. I have no prior knowledge of Microsoft Access, because of well explained topics, I completely understand this course. Thanks and see you in your advance course.â€
- Allan Benzon
â€œInteresting. Seems comprehensive. Engaging. Great resources to make my learning experiences easier. Thank you.â€
- John Dunn
â€œOutstanding way of explaining if you really want to learn access this is the best course on udemy to start with..Thank you Mr.Toby i just seen like 5 videos yet but i am sure this will be a great experience for me.â€
- Faisal Riaz

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