Mô tả

**JUST ADDED** a 3 Hour Course on How to Migrate your Data from Excel to Access!  The course now contains 17 HOURS of Videos!

Just about everyone knows and uses Microsoft Excel, but many of the things they use Excel for would be better done with Access.  In just about every office, there are people struggling with long, multi-step processes with Excel that could literally be done with a single mouse click in Access.  The problem is that while Excel is the most awesome data analysis tool on the planet, it is not an effective database!  BUT people are using it for that purpose anyway because it is all they know.

So why doesn't everyone just use Access?  Well, here is the bad news:
It is harder and takes longer to get productive with Access.

But then again there is some good news too:
It is harder and takes longer to get productive with Access.

What?  Is that a typo?  How can the  good and bad news be exactly the same?

Here is the deal - MOST people won't take the time to learn Access.  They will continue to struggle doing their laborious, complex Excel database processes because they do not have the discipline and determination to learn new ways of doing things.  BUT these people, and the companies they work for, are VERY HAPPY to pay someone who can show them a simple database that does these same tasks with a few mouse clicks.

No matter what office environment you are in, if you take the time to learn Access and implement it to automate some of your own tasks, you will soon be "discovered" by your co-workers and you will start getting requests for "help" with their work.  Bosses who are not accustomed to getting exactly the report they want ahead of time will start asking for more detailed reports and the person who can deliver on these requests becomes much more valuable as an employee.

For you, the person who decided to work extra or work on your own time to get productive with Access, you will benefit for that short time of intense work for the rest of your life.  Things that other people assume are very hard to do are not hard at all and every time you are confronted with something new, you learn a little more about Access. 

The more you work with it, the better and more skilled you become.  You will find that you have transitioned from semi-manual labor with Excel (copying and pasting, doing many steps), to THINKING about how to use the power of Access to automate the entire process.  You will have enriched your work environment and your life!

I've worked with Access just about every day since it was first released and I learn more about what it can do every week!  There is just about no limit to what you can do and you are limited only by your imagination.

So are you the one who wants to make a positive change in their life?  Are YOU the one who is willing to work hard for awhile to reap the benefits forever?  The person who will stand out, who will be as close to "layoff-proof" as possible and always in demand?

Take this course and let me layout the basics of Access and explain why everything I've said above is true - and could be true in YOUR LIFE too!

The videos in this course were created using Access 365.  To get the most out of this course, students should be using Office 365 (Access 365) or Office 2019 (Access 2019), but you can also use earlier versions, like Access 2010, Access 2013 or Access 2016.  With earlier versions, not all techniques will work and the screens will not look the same in some cases.

With the addition of three hours of new videos on migrating Excel data to Access, you can save yourself a lot of headaches by seeing all the common problems people encounter during this process.  These new videos are at the end of the Access course because you will be using many of the skills you have learned to determine where problems are in imported data and how to resolve them.


Bạn sẽ học được gì

Understand how Access is constructed and how to use the major objects within it.

Be confident in moving around within Access and using the many tools available

Be able to build effective database solutions for their unique data needs.

Be able to save time by automating tasks with macros and/or simple VBA subroutines

Yêu cầu

  • Students need a general knowledge of Windows and using Microsoft Office programs like Excel
  • Students should have an Office 365 subscription and have the latest version of Office installed, which includes Access
  • No database experience is needed. You will learn all that in the course!

Nội dung khoá học

22 sections

Introduction to the Access 365 Master Class

4 lectures
A Short Demo of the Finished Database
04:53
How to Get the Most Out of This Course
02:07
Full Screen Viewing at 1080p Resolution is Recommended!
00:26
A NOTE about VBA
00:57

Getting Started with Access 365

3 lectures
Quick Tour Part 1 - Parts of the Screen and Objects
13:50
Quick Tour Part 2 - Navigation Pane, Menu, Ribbons and Objects
12:13
Getting Started with Access 365
9 questions

TABLE Objects: The Basics

7 lectures
Database Download (in case you didn't do it in Quick Tour Part 2)
00:03
Creating Our First Table and Field Data Types
13:17
Adding, Editing and Deleting Records
09:35
Primary Keys: What They Are and Why They Are Important
11:53
Basic Table Sorting and Filtering
06:18
A Demonstration of Database Sharing
03:51
TABLE Objects - the Basics
12 questions

TABLE Design

4 lectures
Fix for a Problem in viewing the Invoice Done report
00:57
Getting Excel Data Ready for Access
08:43
THREE Best Practices in Table Design with PDF
11:05
TABLE Design
8 questions

The Database Tools Menu

3 lectures
The Relationships Window
11:56
The Rest of the Database Tools
07:15
The Database Tools Menu
6 questions

REPORT Objects - the Basics

3 lectures
Overview of Reports and Report Views
12:39
Create a Report with the Wizard and Work with Controls
25:24
REPORT Objects - the Basics
6 questions

QUERY Objects - the Basics

8 lectures
Basic Queries
10:01
Query Criteria
06:39
Date Criteria and Between
05:25
Using OR in Criteria
05:27
Parameter Queries and Showing All Fields
10:25
Multi-Table Queries
13:58
Using Query Dynasets
05:52
QUERY Objects - the Basics
12 questions

PROPERTIES: Making Thousands of Choices Manageable

15 lectures
Table and Field Properties
07:37
The Field INDEXED Property and Options, Object Designers
05:02
The Text Field ALLOW ZERO LENGTH Property
04:52
Predefined Formats in the FORMAT Property
05:35
Custom Formats for TEXT in the FORMAT Property
08:46
Custom Formats for NUMBERS in the FORMAT Property
06:55
Custom Formats for DATES in the FORMAT Property
08:24
Using the INPUT MASK Property
08:00
Using an INPUT MASK with Phone Numbers
07:23
The VALIDATION RULE Property
16:03
QUERY Properties
11:55
How to get the Report Mess report
00:44
Report Properties and Fixing a Report Mess
12:40
Fixing a Report Mess and Adding Page Footers
14:42
PROPERTIES: Making Thousands of Choices Manageable
22 questions

FORM Objects - the Basics

5 lectures
Creating a Form with the Wizard
11:22
More Form Modifications
14:52
Add a Combo Box to our Form
19:13
Changing Tab Order
05:23
FORM Objects - the Basics
6 questions

The FILE Menu

5 lectures
The FILE Menu - Part 1
05:53
The FILE Menu - Part 2
07:33
OPTIONS 1 - General through Languages
09:04
OPTIONS 2 - Client Settings through Trust Center
08:07
The FILE Menu
4 questions

Advanced TABLES

6 lectures
Lookup Wizard and Multi Valued Combo Boxes
15:30
The Calculated Data Type
07:38
The Hyperlink Data Type
04:19
The OLE Object and Attachment Data Types
08:33
Advanced Sorting and Filtering
04:23
Advanced TABLES
6 questions

Advanced QUERIES

9 lectures
Using TOTAL Queries
08:28
ACTION Queries - APPEND
06:56
ACTION Queries - UPDATE
04:38
ACTION Queries - MAKE TABLE
07:11
ACTION Queries - DELETE
04:42
ACTION Queries - CROSSTAB
05:34
A Parameter Query Trick
05:11
Calculations in Queries Introduction to Functions
03:09
Advanced QUERIES
13 questions

Using FUNCTIONS

5 lectures
Using Functions and the Builder
09:08
Using Mid and Instr
10:31
Example of using Switch
11:15
Domain Functions
07:00
Using FUNCTIONS
6 questions

Advanced REPORTS

4 lectures
Reports based on the Parameter Query Trick
10:42
Subtotals in Reports
16:53
Conditional Formatting
06:16
Advanced REPORTS
5 questions

Advanced FORMS

7 lectures
Finish Orders Form and Using TAB Controls - Part 1
09:41
Finish Orders Form and Using TAB Controls - Part 2
08:11
Create the Customer Form
20:30
Create the Orders Subform
09:25
Create the Order Product List Subform
08:51
Add Subforms to Main Forms
08:40
Advanced FORMS
9 questions

Automating Forms with MACROS

8 lectures
Create a Prototype Button
06:37
Create a Go To Customer Button
07:28
Create a To Orders Button in a Subform
08:39
A New Order Button on the Customer Form
07:45
Modify the Add Order Macro to Plug the Name and Address
07:58
New Customer/Exit Buttons – Autoexec Macro
08:52
Macro Commands Used in This Section
00:05
Automating Forms with MACROS
7 questions

Automating Forms with VBA

10 lectures
Updating the ProdName and Unit Price from ProdCode
14:36
Update ProdCode and Unit Price from the ProdName Combo box
04:11
Update the Main Form Total
20:45
Create an Afterupdate for the UnitPrice and create a Delete Button
15:25
Testing Data Entry from Customer to Order
11:00
Recalc Domain Functions and Force Proper Case
08:55
Afterupdate on City and Fill In State and Zip
13:47
Create an Unbound Company Search Combo Box
11:29
VBA Code Used in This Section
00:05
Automating Forms with VBA
10 questions

Creating a Multi-Page Invoice

4 lectures
Create an Invoice Report from the Orders Subform
14:04
More Formatting on the Invoice Report
12:50
Create an Invoice Button on the Orders Form
04:51
Creating a Multi-Page Invoice
3 questions

Migrating from Excel to Access 1: Get the Data Into Access

6 lectures
Introduction to the Importing From Excel Sections
02:39
Import Problems 1 – Deciding on the Best Way to Import
16:49
Import Problems 2 – Data in separate files
07:47
Import Problems 3 – Assignment of Data Types
11:58
Import Problems 4 - Common Import Errors
09:43
A Clean Import - but is it?
15:22

Migrating from Excel to Access 2: 3 Best Practices in Designing Table Structures

2 lectures
Creating Table Structures with 3 Best Practices
11:57
Create Last Two Tables and Setup Relationships
11:39

Migrating from Excel to Access 3: Using Queries to fill the New Tables

9 lectures
Fill the Product Table
18:14
Demo of what can be done with VBA
11:22
Start working on the Customer table
11:18
Find the Potential Problem Customer Records
11:06
One last check for unique values
14:12
Populate the Customer Table and Create CustID's
06:55
Fill the Orders Table
09:57
Final Cleanup
02:55
Migrating from Excel Conclusion
07:49

Access 365 Master Course Conclusion and a Few Cautions

2 lectures
Conclusion and a Few Cautions
05:23
BONUS Lecture! Learn even MORE!
00:16

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.