Microsoft Access 2019 Beginners Course

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

Requirements

Microsoft Access 2019

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 notHow to modify Access to suit your needsAll about importing data and the datasheet viewHow tables work in Access and how to create relationships between themCreating forms and sub-forms that feed data into your tablesHow to run queries in AccessSetting up validations and calculations using expressions in AccessPrinting from AccessTo start to use macros and Modal DialogThe basics of the Access web appExporting and reporting in Access***Exercise and demo files included***This course includes:7.5 hours of video tutorials59 individual video lecturesExercise files to practice what you learnedCertificate of completionThis 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 RiazDid 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!

Overview

Section 1: Introduction

Lecture 1 Introduction to Access 2019

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 Download Course Transcripts

Lecture 4 Acquiring Access 2019

Lecture 5 Structure of the Course

Lecture 6 Course Exercise Files

Lecture 7 Course Demo Files

Section 2: Getting Started with Access 2019

Lecture 8 Using Database Templates

Lecture 9 Creating, Saving and Opening Databases

Lecture 10 The Access Workspace and Backstage

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

Section 3: The Ribbon and Toolbars

Lecture 12 Working with the Ribbon

Lecture 13 The Quick Access Toolbar

Lecture 14 Contextual Menus

Lecture 15 The Status Bar

Section 4: Keyboard Shortcuts and Key Tip

Lecture 16 Keyboard Shortcuts

Lecture 17 Key Tips

Section 5: Access Options

Lecture 18 Exploring Access Options

Section 6: Tables

Lecture 19 Creating a Table and Fields

Lecture 20 Indexed Field

Lecture 21 Lookup Wizard

Lecture 22 Numeric Fields

Lecture 23 Practice Exercise 01

Section 7: Importing Data

Lecture 24 Importing Data from Excel

Lecture 25 Practice Exercise 02

Section 8: Backup, Restore and Repair

Lecture 26 Backing up your Database

Lecture 27 Compact and Repair

Section 9: Datasheet View

Lecture 28 Design in the Datasheet View

Lecture 29 Sorting and Filtering in Datasheet View

Lecture 30 Entering and Modifying Data in Datasheet View

Section 10: Relationships

Lecture 31 Creating a Link Table

Lecture 32 Setting up Relationships

Lecture 33 Practice Exercise 03

Section 11: Forms

Lecture 34 Creating a Form

Lecture 35 Modifying a Form

Lecture 36 Practice Exercise 04

Lecture 37 Forms in Layout View

Lecture 38 Forms in Design View

Lecture 39 Form Design

Lecture 40 Practice Exercise 05

Section 12: Subforms

Lecture 41 Setting Up Subforms - Part 1

Lecture 42 Setting Up Subforms - Part 2

Lecture 43 Setting Up Subforms - Part 3

Lecture 44 Practice Exercise 06

Section 13: Queries

Lecture 45 Creating a Query

Lecture 46 Joins

Lecture 47 Query Wizard

Lecture 48 Practice Exercise 07

Section 14: Expressions

Lecture 49 Setting Up Validations

Lecture 50 Calculation using Expressions

Section 15: Reports

Lecture 51 Basic Reports

Lecture 52 Report Design

Lecture 53 Complex Reports

Lecture 54 Practice Exercise 08

Section 16: Printing

Lecture 55 Printing and Print Properties

Section 17: More Data Types

Lecture 56 Yes/No, OLE Objects and Hyperlink Data Types

Section 18: More About Forms

Lecture 57 Form Controls

Lecture 58 Form Themes

Lecture 59 Navigation Forms

Section 19: Exporting

Lecture 60 Exporting an Access Database

Section 20: Application Parts

Lecture 61 Adding Application Parts to a Database

Section 21: More Access Options

Lecture 62 Additional Access 2019 Options

Section 22: Info Tab

Lecture 63 Edit Database Properties and Encrypt with Password

Section 23: Extras

Lecture 64 EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic

Section 24: Course Close

Lecture 65 Course Close

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