Microsoft Access 2019 for Beginners
IC1018

Microsoft Access 2019 for Beginners

In this Microsoft Access 2019 beginners course, we start at the very beginning and assume you know nothing about Access. We take a project approach to this course, and you build your own project out as we go. By the end of this course, you will have built out your own database with relevant functionality.

New Course - Not Enough Reviews Yet

Course Goal

  • Learn to create your first Access database
  • Master importing data into Access tables
  • Learn to create relationships between tables in Microsoft Access
  • Learn to create forms and sub-forms to feed data to your Access tables

Audience

  • Consultants
  • Developers
  • End users
  • Executives and Managers
  • IT/Business analysts
  • Project Managers
  • Project team members
  • System Administrators

Exam/Certificate


Lesson Plan

2
Acquiring Access 2019
04:24 mins
3
Structure of the Course
02:23 mins

4
Using Database Templates
10:56 mins
5
Creating, Saving and Opening Databases
06:41 mins
6
The Access Workspace and Backstage
13:41 mins
7
Online Help and Tell Me What You Want To Do
08:42 mins

8
Working with the Ribbon
09:28 mins
9
The Quick Access Toolbar
05:57 mins
10
Contextual Menus
02:39 mins
11
The Status Bar
04:07 mins

12
Keyboard Shortcuts
03:36 mins
13
Key Tips
03:52 mins

14
Exploring Access Options
09:15 mins

15
Creating a Table and Fields
11:30 mins
16
Indexed Field
08:42 mins
17
Lookup Wizard
11:35 mins
18
Numeric Fields
07:46 mins
19
Practice Exercise 01
03:07 mins

20
Importing Data from Excel
10:57 mins
21
Practice Exercise 02
05:38 mins

22
Backing up your Database
03:56 mins
23
Compact and Repair
06:23 mins

24
Design in the Datasheet View
10:12 mins
25
Sorting and Filtering in Datasheet View
09:56 mins
26
Sorting and Filtering in Datasheet View
10:56 mins

27
Creating a Link Table
10:35 mins
28
Setting up Relationships
09:55 mins

29
Creating a Form
12:41 mins
30
Modifying a Form
05:15 mins
31
Practice Exercise 04
02:08 mins
32
Forms in Layout View
11:11 mins
33
Forms in Design View
10:00 mins
34
Form Design
11:11 mins
35
Practice Exercise 05
01:33 mins

36
Setting Up Subforms - Part 1
13:02 mins
37
Setting Up Subforms - Part 2
09:13 mins
38
Setting Up Subforms - Part 3
13:23 mins
39
Practice Exercise 06
04:13 mins

40
Creating a Query
13:27 mins
41
Joins
08:30 mins
42
Query Wizard
12:39 mins
43
Practice Exercise 07
09:45 mins

44
Setting Up Validations
10:40 mins
45
Calculation using Expressions
08:43 mins

46
Basic Reports
07:46 mins
47
Report Design
10:43 mins
48
Complex Reports
13:29 mins
49
Practice Exercise 08
02:23 mins

50
Printing and Print Properties
07:54 mins

51
Yes/No, OLE Objects and Hyperlink Data Types
11:21 mins

52
Form Controls
11:15 mins
53
Form Themes
12:37 mins
54
Navigation Forms
09:52 mins

55
Exporting an Access Database
04:16 mins

56
Adding Application Parts to a Database
04:48 mins

57
Additional Access 2019 Options
05:42 mins

58
Edit Database Properties and Encrype with Password
05:31 mins

59
Closing Message
01:06 mins
60
Appendix - Course Exercise files - ZIP

Instructor

Simon Calder

4.8 Average Rating

12 Reviews

87 Students

12 Courses

Simon Calder

Teaching Business Software

Simon Sez IT makes business and technical software simple to learn. We teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design and QuickBooks. We've been teaching online for over ten years.

It all started when the owner, Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.


More Courses by Simon Calder:

Complete Excel 2019 for Beginners
Complete Excel 2019 for Beginners

This Excel course is perfect for those who are new to Excel and who are using Excel 2019 or Excel 365 editions. In th...

4.8

Average Rating

Excel 2019 Advanced
Excel 2019 Advanced

Move your knowledge beyond the basics and supercharge your Excel capabilities. With this 8-hour, expert-led video tra...

5.0

Average Rating

Excel 2016 Advanced
Excel 2016 Advanced

Go beyond the basics and supercharge your Excel capabilities. With this expert-led training course, you’ll gain...

New Course - Not Enough Reviews yet

View All Courses

Student Feedback

New Course - Not Enough Reviews Yet

Subscribe to All Courses
Subscribe

Or subscribe to this course for

$349


Training 5 or more people?

Unlimited access for your entire SAP team including admin platform and premium reporting.

SAP Training for Businesses

Language: English
Level: Beginner
Duration: 8 hours
Type:  Instructor-led
Release: Enterprise Software
Category: Business Productivity

SAP students

33

student views.
Join them!


Related Courses