Microsoft Access: Access Level 1 & 2 (GUI, Macros, VBA)

Microsoft Access: Access Level 1 & 2 (GUI, Macros, VBA), available at $64.99, has an average rating of 4.4, with 99 lectures, based on 59 reviews, and has 1466 subscribers.

You will learn about Access Graphical User Interface and the 4 main objects (tables, reports, queries, and forms) Excel to Access Import While Following All Database Principles Access Macros – Discover How To Utilize Macros for simple tasks Access VBA Will Allow You To Import Excel Into Access Using Code This course is ideal for individuals who are Access Beginners, and/or those that need a refresher. or An individual or business that wants to build a basic or intermediate database for their small business. or Employees who want to get a skill that is still very much valuable and necessary It is particularly useful for Access Beginners, and/or those that need a refresher. or An individual or business that wants to build a basic or intermediate database for their small business. or Employees who want to get a skill that is still very much valuable and necessary.

Enroll now: Microsoft Access: Access Level 1 & 2 (GUI, Macros, VBA)

Summary

Title: Microsoft Access: Access Level 1 & 2 (GUI, Macros, VBA)

Price: $64.99

Average Rating: 4.4

Number of Lectures: 99

Number of Published Lectures: 99

Number of Curriculum Items: 99

Number of Published Curriculum Objects: 99

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Access Graphical User Interface and the 4 main objects (tables, reports, queries, and forms)
Excel to Access Import While Following All Database Principles
Access Macros – Discover How To Utilize Macros for simple tasks
Access VBA Will Allow You To Import Excel Into Access Using Code

Who Should Attend

Access Beginners, and/or those that need a refresher.
An individual or business that wants to build a basic or intermediate database for their small business.
Employees who want to get a skill that is still very much valuable and necessary

Target Audiences

Access Beginners, and/or those that need a refresher.
An individual or business that wants to build a basic or intermediate database for their small business.
Employees who want to get a skill that is still very much valuable and necessary

Welcome to ‘Microsoft Access: Access Tutorial, Level 1 & 2 (GUI, Macros, VBA)’.

We start with the Graphical User Interface of Access but then build up to Access Macros and Access VBA. We will also look at how to build a database by following all database principles.

All this means that you will go beyond learning how to use an existing database. We will give you a hands-on illustration of the key database principles so you can begin building a database on your own.

You will begin by exploring the 4 main objects of Access (tables, reports, queries, and forms), and then you build on that by learning about how to properly build a database.

We have seen quite a few courses on here who do a great job overall in teaching Access but then make fundamental mistakes when it comes to database design. These kinds of mistakes make it impossible to actually build a database on your own, unless the database is used for a trivial venture. You will learn about normalization, referential integrity, and other principles related to good database design.

For those of you spreadsheet experts from Excel, we have two course sections on importing Excel to Access via the GUI and Access VBA code. All of this while following database principles. If you’re interested in learning the differences between Excel and Access, and how you may go about using both..this is a good opportunity.

This Microsoft Access Tutorial is perfect if you are a small business, or an individual, that needs to do a better job in terms of managing your data. If you want your data organized, and prepared for analysis and reporting. This course is perfect for you.

Microsoft Access is one of those programs that is currently highly undervalued, and this in large part because newer programs have come out, yet for 95% of businesses out there, Access has everything you need..and it is quite inexpensive and fairly easy to learn.

Microsoft Access is the perfect all-purpose database, and it can help your company store information and manage large amounts of data.

There is no risk. If you should not like the course, Udemy offers a 30-day money back guarantee. Get a valuable skill today!

Course Curriculum

Chapter 1: Introduction

Lecture 1: How To Have The Best Course Experience

Lecture 2: In The Rare Case Where You Don't Have Access

Lecture 3: All The Databases Used

Lecture 4: Setting Up Access Options

Chapter 2: Everything about Tables

Lecture 1: Intro To Working With Tables and Navigation

Lecture 2: Fundamentals of Editing Records

Lecture 3: Sorting in Access

Lecture 4: Filtering in Access

Lecture 5: Find and Replace

Lecture 6: Creating Our First Table, 1

Lecture 7: Creating Our First Table, 2

Lecture 8: Creating Our First Table, 3

Lecture 9: Field Properties 1 (Field size, Format, Input Mask)

Lecture 10: Default Values and Validation Rules

Lecture 11: Zero Length Text Fields

Lecture 12: Look-ups in Access

Lecture 13: Moving and Adding Fields in Design View

Chapter 3: Working with Reports in Access

Lecture 1: Intro to Reports and Report Wizard

Lecture 2: Move, Resize, Align in Reports

Lecture 3: Unbounded Controls in Access

Lecture 4: Bound Controls in Access

Lecture 5: Calculated Controls in Access

Lecture 6: First Control Text Box in Report

Lecture 7: Grand Total Control

Lecture 8: Grouping in Reports

Lecture 9: Conditional Formatting in Reports

Chapter 4: Queries (Select Queries)

Lecture 1: Intro to Queries and Designing Queries

Lecture 2: Sorting In Queries

Lecture 3: Criteria in Queries

Lecture 4: Wildcard Criteria in Queries

Lecture 5: Formulas in Queries

Lecture 6: Calculations in Queries

Lecture 7: Parameter Queries

Lecture 8: Top Records Queries

Lecture 9: Totals Queries

Lecture 10: Crosstab Query

Chapter 5: Action Queries

Lecture 1: Update

Lecture 2: Make Table

Lecture 3: Append

Chapter 6: Forms in Access

Lecture 1: Intro To Forms

Lecture 2: Creating Customer Form

Lecture 3: Alignment in Forms

Lecture 4: Styling Our Form

Lecture 5: Controlling Tab Order

Lecture 6: Transactions Form

Lecture 7: Creating Subform

Lecture 8: Some Final Touches To Our Customer Transactions Form

Lecture 9: Form Record Source

Lecture 10: Form Design Tips

Chapter 7: Database Design 1 (Becoming a Database Expert from Other Areas)

Lecture 1: Spreadsheet Expert

Lecture 2: End User vs. Developer Comparison

Lecture 3: Coding Experts

Chapter 8: Database Design 2, Illustrating Normalization Practically

Lecture 1: 1st Rule for Normalized Tables, Hands-On Illustration

Lecture 2: 2nd Rule for Normalized Tables, Hands-On Illustration

Lecture 3: 3rd Rule for Normalized Tables, Hands-On Illustration

Chapter 9: Database Design 3, Table Design

Lecture 1: Primary Key Tips

Lecture 2: Picking A Starting Auto-number

Lecture 3: Is Duplication Sometimes Necessary?

Lecture 4: Non-Normalized to Normalized

Lecture 5: Field Type Consistency

Chapter 10: Database Design 4, Relationships and Referential Integrity

Lecture 1: Relationships and Referential Integrity Intro

Lecture 2: Many-to-Many Relationship

Lecture 3: One-To-Many Relationships

Lecture 4: One-To-One Relationship

Lecture 5: Hands-On Referential Integrity Illustration

Lecture 6: Hands-on Cascade Delete Illustration

Lecture 7: Cascade Update

Chapter 11: Database Design Activity

Lecture 1: Database Design Activity

Chapter 12: Importing Excel into Access using GUI and Database Principles

Lecture 1: Intro to Excel and Access

Lecture 2: Excel No Heading Problem

Lecture 3: Excel Import Errors

Lecture 4: Data Check/Considerations Before Import

Lecture 5: Many Excel Files to One

Lecture 6: Creating Master Table in Access

Lecture 7: Normalize by Creating Specific Tables and Implementing Relationships

Lecture 8: Appending, in Order

Chapter 13: Essence of Programming – Program Flow And Controlling Flow/Direction

Lecture 1: Control Structures

Lecture 2: Decision Structures (if-then-else)

Lecture 3: Loop Structures (do-while)

Chapter 14: An Intro To Access Macros

Lecture 1: Creating an AutoExec Macro

Lecture 2: Standalone and Embedded Macros

Lecture 3: Exploring Options in Macro Action Catalog

Lecture 4: Button Control Macros using Wizard

Lecture 5: AutoExec Macro 2 – Using Table and Form to Create Welcome Message, 1

Lecture 6: AutoExec Macro 2 – Using Table and Form to Create Welcome Message, 2

Lecture 7: AutoExec Macro 2 – Finishing Touches

Instructors

Ermin Dedic
All Things Data.

Rating Distribution

1 stars: 0 votes
2 stars: 4 votes
3 stars: 7 votes
4 stars: 21 votes
5 stars: 27 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu