access
Lifetime
content
13.0 Hours
enrolled
149
Description
Deep dive into the popular end-user relational database tool, Microsoft Access with this comprehensive course! This Microsoft Access course combines four different courses in one. Jump in, and you'll walk through everything from the absolute Access basics to more advanced concepts, like building dynamic user data forms and effective reports. By the end of the course, you'll have the know-how required to create effective database tables, automate tasks, and more with this powerful tool.- Access 172 lectures & 13 hours of content 24/7
- Explore creating effective database tables & understanding table relationships
- Gain knowledge on retrieving data using access queries
- Get a grip on building dynamic user data forms & effective reports
- Learn to automate Access database tasks w/ Macros & VBA
Instructor
Kyle Pew is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including Microsoft Office Suite, SharePoint End-User, and VBA (Excel and Access).Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 15 days of purchase
- Experience level required: beginner
Requirements
- Internet access
- Windows machine w/ Microsoft Access 2007, 2010, 2013 & 2016
Terms
- Unredeemed licenses can be returned for store credit within 15 days of purchase. Once your license is redeemed, all sales are final.
Course Outline
- Course Introduction and Exercise Files
- Course Topics and Flow - 3:03
- Course Exercise Files - Download These First!
- Access Overview - Quick Overview of Access Interface
- Opening Microsoft Access - 3:51
- Access Quick Access Toolbar - 3:05
- Working with the Access Ribbon - 3:45
- Access Object Panel - 4:12
- Access File Tab - 3:19
- Access Security Prompt - 3:19
- Access Overview - Fundamentals of Access Objects
- Understanding the Purpose of Access Tables - 8:46
- Building Relationships between Access Tables - 5:37
- Using Access Queries to Select Specific Data - 9:15
- Building a User Interface with Access Forms - 7:34
- Reporting on Access Data with Access Reports - 5:53
- Automate Access Tasks with Macros and VBA - 4:06
- Access Tables - Working with Table Data
- Working in Datasheet View within an Access Table - 6:15
- Sorting the Datasheet View - 3:19
- Filtering the Datasheet View with Filter by Selection - 3:33
- Filter the Datasheet View with Advanced Filter - 4:35
- Access Tables - Creating Tables in Your Access Database
- Preview the "Student Course" Database Tables - 3:36
- Creating an Access Database - 3:42
- Designing Access Tables in Design View - 10:23
- Adding Fields and Defining Common Data Types in an Access Table - 5:32
- Field Size Property - 5:45
- Field Caption Property - 2:48
- Default Value Property - 4:08
- Required Field Property - 1:30
- Input Mask Property - 9:18
- Custom Input Mask - 4:52
- Working with the Lookup Wizard Data Type - 4:29
- Edit a Table Field Drop Down - 1:54
- Adding Field Descriptions - 2:00
- Setting the Table's Primary Key Field - 5:49
- Adding Records in the Datasheet View - 3:28
- Access Tables - Microsoft Access Table Exercise
- Table Exercise Introduction - 3:11
- Building Additional Tables
- Access Tables - Working with Access Table Relationships
- Understanding Access Table Relationships - 5:37
- Creating Access Table Relationships - 8:29
- Setting Up "Better" Table Relationships - 9:20
- Setting the Relationship Properties - 6:16
- Table Relationships Cascade Update/Delete - 4:41
- Working with Sub Datasheets in Tables - 3:06
- Creating Table Relationships with the Lookup Wizard - 7:24
- Access Queries - Working with Access Select Queries
- Creating an Access Select Query - 6:26
- Adding Criteria to an Access Select Query - 2:52
- Using AND Conditions in an Access Query - 3:06
- Using OR Conditions in an Access Query - 2:40
- Another OR Condition - 2:11
- Sorting Data within an Access Select Query - 1:42
- Multi-Level Query Sort - 3:35
- Working with Date Criteria in an Access Select Query - 4:01
- Using the "Between" Operator - 2:00
- Access Query Tip -- Using Table Fields within Query Criteria - 5:06
- Using Wildcards in Query Criteria - 5:51
- Access Query Tip --- DATA TYPE MISMATCH - 5:55
- Saving an Access Query - 2:08
- Access Queries - Query Calculated Fields
- Creating a Calculated Field in an Access Query - 6:51
- Using the MONTH() and MONTHNAME() Functions - 8:13
- Using the IF() Function in a Query Calculated Field - 8:56
- Finding the Difference Between Two Dates Using the DateDiff() Function - 6:02
- Access Queries - Summarizing Data in an Access Query
- Working with an Access Total Query - 2:12
- Grouping and Summarizing Data with a Total Query - 6:55
- Adding a Calculated Field to a Total Query - 4:00
- Saving a Total Query - 1:29
- Total Query Exercise -- Post in the QA Section - 2:27
- Total Query Example -- Products Table - 1:34
- Summarizing Data with a Crosstab Query - 6:28
- Access Queries - Working with Access Action Queries
- Introduction to Access Action Queries - 4:17
- Update Access Table Data with an Update Query - 6:22
- Update Table Data with a Calculation - 5:08
- Saving an Action Query - 2:37
- Creating a New Table with an Access Make Table Query - 5:59
- Deleting Table Data with an Access Delete Query - 10:26
- Appending Records to an Exisiting Table with an Access Append Query - 4:46
- Access Queries -- Querying Multiple Tables with Query Joins
- Creating a Query with Multiple Tables - 6:59
- Working with Query Joins - 5:32
- Inner Join and Left Outer Join - 5:46
- Access Queries - Parameter Queries
- Parameter Query Preview - 1:41
- Creating a Single Parameter - 4:44
- Saving the Parameter Query - 2:16
- Creating Date Parameters - 4:38
- Creating Multiple Parameters - 2:01
- Using Wildcards in Parameters - 2:49
- Run a Parameter with a Shortcut - 1:35
- Access Forms - Building Data Entry Forms
- Starting with a Blank Form - 3:17
- Adding Form Fields - 6:52
- Moving Form Fields - 4:05
- Resizing Form Fields - 1:23
- Aligning Form Fields - 5:37
- Spacing Form Fields - 4:44
- Saving a Form - 1:03
- Access Forms - Working with Form Data
- Adding, Deleting and Editing Records - 6:19
- Sorting Form Records - 2:13
- Filtering Form Records using Filter by Selection - 3:16
- Filtering Form Records using Advanced Filter - 2:17
- Access Forms - Form Controls
- Introduction to Form Controls - 3:17
- Adding a Header and Footer - 4:10
- Creating Calculated Form Fields - 5:51
- Working with Sub Forms - 7:13
- Working with the Option Group Control - 11:14
- Adding the Tab Control to a Form - 5:58
- Adding Buttons to a Form - 5:52
- Access Forms - Formatting Options
- Formatting Field Controls - 4:53
- Creating Separation with the Line Control - 3:28
- Changing the Form Background color - 2:33
- Access Forms - Building a Database Swithboard
- Preview an Access Switchboard - 2:43
- Start the Switchboard Manager - 2:56
- Adding Buttons to the Switchboard - 4:34
- Fomatting the Switchboard - 3:59
- Modify the Switchboard - 2:33
- Access Forms - Interacting with Queries through Forms
- Preview Filtering Query Data with a Form - 1:42
- Setting up the Query - 2:55
- Setting up the Form - 6:07
- Clean Up the Combo Box Control - 5:27
- Creating the Form Button to Run the Query - 2:48
- Adding Form Reference Criteria to the Query - 3:56
- Running the Query - 1:36
- Access Reports - Building an Access Report
- Starting with a Blank Report - 4:17
- Adding Report Fields - 6:32
- Laying out Report Fields - 7:07
- Working with Report Sections - 4:06
- Formatting Report Fields - 4:13
- Working with Report Margins and Orientation - 9:01
- Access Format Painter - 2:16
- Working with the Header and Footer - 5:04
- Saving an Access Report - 1:35
- Access Reports - Creating Calculated Controls
- Adding a Calculated Field using a Text Box Control - 6:53
- Adding a Calculated Field using a Check Box Control - 6:29
- Access Reports - Advanced Report Group Options
- Grouping and Sorting Reports - 6:01
- Report Column Headers and Groups - 3:06
- Repeating Column Headers and Groups - 2:08
- Group Page Breaks - 3:28
- Activate Group Footer - 2:50
- Adding a Group Calculation - 5:11
- Getting Started with Microsoft Access VBA
- Access VBA Intro - Section 1 Exercise File Download
- Introduction to the Access VBE (Visual Basic Editor) Window - 3:46
- Getting Help with Access VBA - 5:35
- Working with Access VBA SUB Procedures and Functions
- Access VBA SUB Procedures and Functions - Section 2 Exercise File Download
- Understanding and Creating VBA Modules - 3:51
- Creating Access VBA SUB Procedures - 6:08
- Calling an Access VBA SUB Procedure - 3:29
- Using the Immediate Window - 4:41
- Creating Access VBA Custom Functions - 7:22
- Using an Access VBA Function - 4:09
- Understanding and Working with Access Objects with VBA
- Access VBA Objects - Section 3 Exercise File Download
- Understanding Access Objects - 5:00
- Properties, Methods and Events of Access Objects - 6:08
- Communicating with Access Objects with VBA - 11:53
- Working with Object Collections - 8:10
- Using the VBA "With" Statement - 5:34
- Controlling Access Objects with the "DoCmd" Statement - 7:40
- Foundational VBA Programming Concepts
- Access VBA Programming Concepts - Section 4 Exercise File Download
- Storing and Referencing Data with VBA Variables - 6:54
- Declaring a Variables Data Type - 4:31
- Understanding the Scope of a VBA Variable - 7:22
- Creating Logic within VBA Code Using an IF Statement - 6:34
- Using a VBA Select Case Statement to Branch within Code - 6:24
- Repeating Blocks of VBA Code with Loops - 9:47
- Working with the Access Recordset Object
- Access VBA Recordset Object - Section 5 Exercise File Download
- Creating Object Variables - 6:29
- Iterating through an Access Recordset - 9:37
- Debugging Access VBA Code
- Access VBA Debugging Tools - Section 6 Exercise File Download
- Stepping Through Code a Line at a Time - 7:23
- Setting Breakpoints with a Procedure - 4:32
- Adding Error Handling to an Access VBA Procedure - 6:30
- Using the Access VBA "Err" Object - 6:22
- Access VBA - Project #1 Working with Access VBA SUB Procedures
- Project #1 - Introduction and Preview - 1:09
- Project #1 - Exercise File Download
- Project #1 - Setting up the Form - 4:53
- Project #1 - Where to Write Your Code - 5:11
- Project #1 - Creating a SUB Procedure to Open a Form - 3:23
- Project #1 - Working with the OnClick Event of a Command Button - 4:47
- Project #1 - Making Reuasable SUB Procedures - 4:57
- Project #1 - Quick Recap - 1:12
access
Lifetime
content
13.0 Hours
enrolled
149
