Access Expert 7
01. Lookup Values in Tables (17:46)
Add Group Field to CustomerT
Lookup Data Type
I will type in the values
Limit to List
Cons of Lookups in Tables
NOT Supported by SQL Server
Allow Value List Edits
Allow Multiple Values
Row Source Item List
Semicolon Delimited Items
Two column text value list
Bound Column
Column Count
Lookup from another table
SQL Statement directly in table
Multi Valued Fields
Allow Multiple Values
Cons of MultiValue Lists
Delete Relationship to GroupT
02. Many to Many Relationships 1 (13:10)
Multiple groups per customer
Many-to-Many
Cross-reference table
Junction table
Customers to Groups
Vendors to Products
GroupXCustomerT
Group Subform on Customer Form
03. Many to Many Relationships 2 (6:25)
Group Form
Show Customers in Group
Copy CustomerGroupSubF
Create GroupCustomerSubF
SHIFT-ENTER line break in label
Groups button on Main Menu
04. Letters By Group (16:36)
IncludeInMailing Field in GroupT
GroupMailingQ
LettersByGroupR
GroupSubF
RefreshRecord in Macro
Duplicate customers in mailing
Quick overview of Aggregate Queries
Group By
Min Value
05. Post Cards (12:02)
Create Report Design
Shape Outline Transparent
Landscape v Portrait
Page Setup Dialog
Number of Columns
Row Spacing
Column Spacing
Column Size
Same as Detail
Down, then Across
Across, then Down
Margins
Resizing with the Rulerbar
Button from Letter Form
06. Vendors to Products (17:16)
Build ProductF Form
Vendor Table
VendorXProductT Junction Table
UnitCost
DateUpdated
Profit Calculation
|