Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Office Productivity
Microsoft
Microsoft Access
Microsoft Access Complete Beginner to Advanced

Microsoft Access Complete Beginner to Advanced

Loại khoá học: Microsoft

Ultimate Microsoft Access Training - Create & Maintain Access Tables, Access Queries, Access Forms, Access Reports

image
50.000 VND
99 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

Microsoft Access all in One Package

This Microsoft Access course combines 4 different courses.

  • Microsoft Access 101 - An Introduction to Access and Table Design

  • Microsoft Access 102 - Access Queries

  • Microsoft Access 103 - Form and Reports

  • Automate Microsoft Access Tasks with Macros and VBA

Each Section, (Intro/Tables, Queries, Forms, Reports and Macros/VBA), will start at the basic level and progress to an advanced level with the section.

Material recorded with Access 2016 but works in 2007, 2010, 2013, 2016, 2019, Microsoft 365/2023

Enroll now to go through a deep dive of the popular end-user relational database tool, Microsoft Access. As your instructor I will use my 15+ years of Access training to guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses you will master Access tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Access tools and come out with confidence to complete any Access tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating Effective Database Tables

  • Understanding Table Relationships

  • Building Dynamic User Data Forms

  • Effectively Retrieve Data Using Access Queries

  • Build Effective Reports

  • Automate Access Database Tasks with Macros and VBA

So, what are you waiting for, enroll now and take the next step in mastering Access and go from Access Newb to Access Guru!

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

Manage Large Sets of Data in Microsoft Access Relational Design

Build an Efficient Database Table Design

Control User Data Entry Effectively

Build Dynamic Access Database Queries

Present Dynamic Reports

Build Automation, Saving Time and Money

Yêu cầu

  • Windows Machine with Microsoft Access
  • No Prior Microsoft Access Knowledge Needed

Nội dung khoá học

29 sections

Course Introduction and Exercise Files

2 lectures
Course Topics and Flow
03:03
Course Exercise Files - Download These First!
02:54

Access Overview - Quick Overview of Access Interface

6 lectures
Opening Microsoft Access
03:51
Access Quick Access Toolbar
03:05
Working with the Access Ribbon
03:45
Access Object Panel
04:12
Access File Tab
03:19
Access Security Prompt
03:19

Access Overview - Fundamentals of Access Objects

6 lectures
Understanding the Purpose of Access Tables
08:46
Building Relationships between Access Tables
05:37
Using Access Queries to Select Specific Data
09:15
Building a User Interface with Access Forms
07:34
Reporting on Access Data with Access Reports
05:53
Automate Access Tasks with Macros and VBA
04:07

Access Tables - Working with Table Data

4 lectures
Working in Datasheet View within an Access Table
06:15
Sorting the Datasheet View
03:19
Filtering the Datasheet View with Filter by Selection
03:33
Filter the Datasheet View with Advanced Filter
04:35

Access Tables - Creating Tables in Your Access Database

15 lectures
Preview the "Student Course" Database Tables
03:36
Creating an Access Database
03:42
Designing Access Tables in Design View
10:23
Adding Fields and Defining Common Data Types in an Access Table
05:32
Field Size Property
05:45
Field Caption Property
02:48
Default Value Property
04:08
Required Field Property
01:30
Input Mask Property
09:18
Custom Input Mask
04:52
Working with the Lookup Wizard Data Type
04:29
Edit a Table Field Drop Down
01:54
Adding Field Descriptions
02:00
Setting the Table's Primary Key Field
05:49
Adding Records in the Datasheet View
03:28

Access Tables - Microsoft Access Table Exercise

2 lectures
Table Exercise Introduction
03:11
Building Additional Tables
02:00

Access Tables - Working with Access Table Relationships

7 lectures
Understanding Access Table Relationships
05:37
Creating Access Table Relationships
08:29
Setting Up "Better" Table Relationships
09:20
Setting the Relationship Properties
06:16
Table Relationships Cascade Update/Delete
04:41
Working with Sub Datasheets in Tables
03:06
Creating Table Relationships with the Lookup Wizard
07:24

Access Queries - Working with Access Select Queries

13 lectures
Creating an Access Select Query
06:26
Adding Criteria to an Access Select Query
02:52
Using AND Conditions in an Access Query
03:06
Using OR Conditions in an Access Query
02:40
Another OR Condition
02:11
Sorting Data within an Access Select Query
01:42
Multi-Level Query Sort
03:35
Working with Date Criteria in an Access Select Query
04:01
Using the "Between" Operator
02:00
Access Query Tip -- Using Table Fields within Query Criteria
05:06
Using Wildcards in Query Criteria
05:51
Access Query Tip --- DATA TYPE MISMATCH
05:55
Saving an Access Query
02:08

Access Queries - Query Calculated Fields

4 lectures
Creating a Calculated Field in an Access Query
06:51
Using the MONTH() and MONTHNAME() Functions
08:13
Using the IF() Function in a Query Calculated Field
08:56
Finding the Difference Between Two Dates Using the DateDiff() Function
06:02

Access Queries - Summarizing Data in an Access Query

7 lectures
Working with an Access Total Query
02:12
Grouping and Summarizing Data with a Total Query
06:55
Adding a Calculated Field to a Total Query
04:00
Saving a Total Query
01:30
Total Query Exercise -- Post in the QA Section
02:27
Total Query Example -- Products Table
01:34
Summarizing Data with a Crosstab Query
06:28

Access Queries - Working with Access Action Queries

7 lectures
Introduction to Access Action Queries
04:17
Update Access Table Data with an Update Query
06:22
Update Table Data with a Calculation
05:08
Saving an Action Query
02:37
Creating a New Table with an Access Make Table Query
05:59
Deleting Table Data with an Access Delete Query
10:26
Appending Records to an Exisiting Table with an Access Append Query
04:46

Access Queries -- Querying Multiple Tables with Query Joins

3 lectures
Creating a Query with Multiple Tables
06:59
Working with Query Joins
05:32
Inner Join and Left Outer Join
05:46

Access Queries - Parameter Queries

7 lectures
Parameter Query Preview
01:41
Creating a Single Parameter
04:44
Saving the Parameter Query
02:16
Creating Date Parameters
04:38
Creating Multiple Parameters
02:01
Using Wildcards in Parameters
02:49
Run a Parameter with a Shortcut
01:35

Access Forms - Building Data Entry Forms

7 lectures
Starting with a Blank Form
03:17
Adding Form Fields
06:52
Moving Form Fields
04:05
Resizing Form Fields
01:23
Aligning Form Fields
05:37
Spacing Form Fields
04:44
Saving a Form
01:04

Access Forms - Working with Form Data

4 lectures
Adding, Deleting and Editing Records
06:19
Sorting Form Records
02:13
Filtering Form Records using Filter by Selection
03:16
Filtering Form Records using Advanced Filter
02:17

Access Forms - Form Controls

7 lectures
Introduction to Form Controls
03:17
Adding a Header and Footer
04:10
Creating Calculated Form Fields
05:51
Working with Sub Forms
07:13
Working with the Option Group Control
11:14
Adding the Tab Control to a Form
05:57
Adding Buttons to a Form
05:52

Access Forms - Formatting Options

3 lectures
Formatting Field Controls
04:53
Creating Separation with the Line Control
03:28
Changing the Form Background color
02:33

Access Forms - Building a Database Swithboard

5 lectures
Preview an Access Switchboard
02:43
Start the Switchboard Manager
02:56
Adding Buttons to the Switchboard
04:34
Fomatting the Switchboard
03:59
Modify the Switchboard
02:33

Access Forms - Interacting with Queries through Forms

7 lectures
Preview Filtering Query Data with a Form
01:42
Setting up the Query
02:55
Setting up the Form
06:07
Clean Up the Combo Box Control
05:27
Creating the Form Button to Run the Query
02:48
Adding Form Reference Criteria to the Query
03:56
Running the Query
01:36

Access Reports - Building an Access Report

9 lectures
Starting with a Blank Report
04:17
Adding Report Fields
06:32
Laying out Report Fields
07:07
Working with Report Sections
04:06
Formatting Report Fields
04:13
Working with Report Margins and Orientation
09:01
Access Format Painter
02:16
Working with the Header and Footer
05:04
Saving an Access Report
01:35

Access Reports - Creating Calculated Controls

2 lectures
Adding a Calculated Field using a Text Box Control
06:53
Adding a Calculated Field using a Check Box Control
06:29

Access Reports - Advanced Report Group Options

6 lectures
Grouping and Sorting Reports
06:01
Report Column Headers and Groups
03:06
Repeating Column Headers and Groups
02:08
Group Page Breaks
03:28
Activate Group Footer
02:50
Adding a Group Calculation
05:11

Getting Started with Microsoft Access VBA

3 lectures
Access VBA Intro - Section 1 Exercise File Download
00:19
Introduction to the Access VBE (Visual Basic Editor) Window
03:47
Getting Help with Access VBA
05:35

Working with Access VBA SUB Procedures and Functions

7 lectures
Access VBA SUB Procedures and Functions - Section 2 Exercise File Download
00:20
Understanding and Creating VBA Modules
03:51
Creating Access VBA SUB Procedures
06:08
Calling an Access VBA SUB Procedure
03:29
Using the Immediate Window
04:41
Creating Access VBA Custom Functions
07:23
Using an Access VBA Function
04:09

Understanding and Working with Access Objects with VBA

7 lectures
Access VBA Objects - Section 3 Exercise File Download
00:20
Understanding Access Objects
05:00
Properties, Methods and Events of Access Objects
06:09
Communicating with Access Objects with VBA
11:54
Working with Object Collections
08:10
Using the VBA "With" Statement
05:34
Controlling Access Objects with the "DoCmd" Statement
07:40

Foundational VBA Programming Concepts

7 lectures
Access VBA Programming Concepts - Section 4 Exercise File Download
00:19
Storing and Referencing Data with VBA Variables
06:54
Declaring a Variables Data Type
04:32
Understanding the Scope of a VBA Variable
07:23
Creating Logic within VBA Code Using an IF Statement
06:35
Using a VBA Select Case Statement to Branch within Code
06:24
Repeating Blocks of VBA Code with Loops
09:47

Working with the Access Recordset Object

3 lectures
Access VBA Recordset Object - Section 5 Exercise File Download
00:19
Creating Object Variables
06:29
Iterating through an Access Recordset
09:37

Debugging Access VBA Code

5 lectures
Access VBA Debugging Tools - Section 6 Exercise File Download
00:19
Stepping Through Code a Line at a Time
07:23
Setting Breakpoints with a Procedure
04:32
Adding Error Handling to an Access VBA Procedure
06:30
Using the Access VBA "Err" Object
06:22

Access VBA - Project #1 Working with Access VBA SUB Procedures

8 lectures
Project #1 - Introduction and Preview
01:09
Project #1 - Exercise File Download
00:19
Project #1 - Setting up the Form
04:53
Project #1 - Where to Write Your Code
05:11
Project #1 - Creating a SUB Procedure to Open a Form
03:23
Project #1 - Working with the OnClick Event of a Command Button
04:47
Project #1 - Making Reuasable SUB Procedures
04:57
Project #1 - Quick Recap
01:12

Đá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?

Khoá học liên quan

Oracle SQL Performance Tuning Masterclass (2024)

Oracle SQL Performance Tuning Masterclass (2024)

105 VND
50.000 VND
Excel ứng dụng trong phân tích tài chính

Excel ứng dụng trong phân tích tài chính

26 VND
50.000 VND
ChatGPT Complete Guide: Learn Midjourney, ChatGPT 4 & More

ChatGPT Complete Guide: Learn Midjourney, ChatGPT 4 & More

120 VND
50.000 VND
Master Excel and Solve 500 Problems (Beginner - Advanced)

Master Excel and Solve 500 Problems (Beginner - Advanced)

45 VND
50.000 VND
Unlock Excel VBA and Excel Macros

Unlock Excel VBA and Excel Macros

100 VND
50.000 VND
Làm chủ VBA Excel để tự động hóa công việc

Làm chủ VBA Excel để tự động hóa công việc

399.000 VND
50.000 VND
59 ChatGPT HACKS To Make Money Online in 2024

59 ChatGPT HACKS To Make Money Online in 2024

100 VND
50.000 VND
Microsoft Excel: Data Analysis with Excel Pivot Tables

Microsoft Excel: Data Analysis with Excel Pivot Tables

110 VND
50.000 VND
Microsoft Excel: Advanced Excel Formulas & Functions

Microsoft Excel: Advanced Excel Formulas & Functions

1.899.000 VND
50.000 VND
Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

119 VND
50.000 VND
Khoá học Google Apps Script nâng cao trong Google Sheets

Khoá học Google Apps Script nâng cao trong Google Sheets

749.000 VND
50.000 VND
SAP ABAP Programming For Beginners - Online Training

SAP ABAP Programming For Beginners - Online Training

90 VND
50.000 VND
Chứng chỉ MOS Excel 2019 - Exam MO-200 Microsoft Excel

Chứng chỉ MOS Excel 2019 - Exam MO-200 Microsoft Excel

25 VND
50.000 VND
Microsoft Excel: Data Visualization with 20+ Excel Charts

Microsoft Excel: Data Visualization with 20+ Excel Charts

140 VND
50.000 VND
Microsoft Excel: Business Intelligence w/ Power Query & DAX

Microsoft Excel: Business Intelligence w/ Power Query & DAX

120 VND
50.000 VND
SharePoint - Complete Guide to Microsoft SharePoint Online

SharePoint - Complete Guide to Microsoft SharePoint Online

90 VND
50.000 VND
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.

Get khoá học cho tôi