Import HUD Property Data | A2P School

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Microsoft Access Data Mastery

Introduction and Course Overview

Introduction (1:38)

Getting Started With Access

The 10 Minute Access Quick Tour (13:41)
Working with the Navigation Pane, Menu, Ribbons and Objects (17:38)

TABLE Objects

Creating Our First Table and Data Type (15:27)
Creating a Combo Box (4:21)
Adding, Editing and Deleting Records (9:14)
Field Properties (10:26)
Predefined Formats in the FORMAT Property (11:57)
Using the INPUT MASK Property (7:47)
The Validation Rule Properties (8:57)
Import HUD Property Data (7:17)
Basic Table Sorting and Filtering with HUD Property table (8:48)
Import the Contract Renewals (8:02)
Import the RentUtility file (6:33)
Relationships Window (11:06)

QUERY Objects

Basic Queries (5:18)
Query Criteria (7:48)
Number and Date Criteria and Between (6:05)
Using OR in Criteria (3:26)
Query Properties – Unique Values, Dynasets and TOP (9:18)
Calculations in Queries Introduction to Functions (8:20)
Multi Table Queries (4:46)
Exporting query results to Excel (2:38)
ACTION Queries - MAKE TABLE (8:16)
ACTION Queries – DELETE (3:06)
ACTION queries – APPEND (13:24)
ACTION Queries - UPDATE (11:49)
TOTAL Queries (6:44)
ACTION QUERIES - Crosstab (6:20)
Parameter Queries (5:19)

REPORT Objects

Create a Report with the Wizard and Work with Controls (14:22)
Modify and Finish the Report (15:46)
Report Sorting and Grouping (15:01)
Setup the Group and Report Footers (11:47)
Create Versions of the Report Based on Queries (10:08)
Create a Report With Dates in the Title (20:05)

FORM Objects

Creating a Form with the Wizard (11:39)
Moving Labels and Adding a Tab Control (8:29)
Adding Rectangles and Colors (9:32)
Tab Order and Tab Stops (8:26)
Create the Renewals Subform (8:54)
Final Formatting on the ContractRenewal Subform (8:01)
Create the Utilities Subform (6:48)
Add Subforms to HUDProperties Main Form (9:40)

MACRO Objects - Beginning Automation

Create an AUTOEXEC macro (4:31)
Create a Prototype Form Button and do EXIT (8:10)
Create a Button to Open or Print a REPORT (4:27)
Add PRINT and CLOSE Buttons to the Report (7:34)
Add an UNBOUND Combo Box to Show List of Properties (9:33)
Add a Macro to Locate the Property (9:27)

Transition to VBA Courses with Lessons from Access 365 Course

Transition Overview (1:06)
Using MID and INSTR Functions (10:31)
Domain Functions (7:00)
Create a Prototype Button (4:01)
Create a Go To Customer Button (7:28)
Create a To Orders button in a Subform (8:39)
A New Order Button on the Customer Form (7:45)
Modify the Add Order Macro to Plug the Name and Address (7:58)

Conclusion and Final Thoughts

Conclusion (0:53)

Teach online with

Import HUD Property Data

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock