Access Expert 4
01. Extended Info Tables (19:26)
Create CustomerExtendedT
ShortText and LongText Fields in 2013
Yes/No NULL Value
Password Input Mask
Family Member Table
Relative Type Table
Force One-to-One Relationship
Indexed No Duplicates
02. Extended Customer Form 1 (23:55)
Create Extended Customer Form
Option Group
Yes as -1, No as 0
Unspecified option
Change y/n to number
Create List Box from Scratch
Create Toggle Buttons
Manipulate Toggle Colors
Lighter Darker 50%
Hover Color
Pressed Color
03. Extended Customer Form 2 (26:05)
Command Button Open Ext Form
Default Value
Forms!CustomerF!CustomerID
Locked Property
Change Form Properties
Modal, Popup
Navigation Buttons
Record Selectors
Caption & Trick
Tab Controls
Image Control
Save Path Filename in Table
Set Image Control Source
Customer With Image Query
Display Image on Report
Customer Labels with Image
04. Family Member Form (14:15)
Description Indexed No Duplicates
Relative Type Helper Form
SQL Recordsource
Family Member Form
Relative Type Combo Box
Link Master Fields
Link Child Fields
List Items Edit Form
05. Toolbox Control Overview (11:20)
Hyperlink Control
Label with Hyperlink Address
Show File Extensions
Brief Discussion Of...
Web Browser Control
Page Break Control
Chart Control
Line & Rectangle Controls
Attachment Control
ActiveX Controls
|