|
Creating Forms
Creating a Form
Using the Wizard
Creating a Form from Scratch
Add Text
Add Fields & Formulas
Add a Picture/Drawing
What are Controls?
Select Boxes
Move and Size Controls
Align Controls and the Different Views
Basic Formatting
Using the Colour Icons
Spacing Between Objects
Delete Objects
Cut, Copy, Paste
Copy Formats
Bring to Front/Send to Back
The Toolbox
Tab Order
Print
Forms Based on Multiple Tables
Control Properties
Name
Control Source
Default Value
Validation Rule, Validation Text
Format, Decimal Places
Custom Date Formats
Input Mask
Status Bar Text & Control Tip
Enabled & Locked
Tab Stop
Combo Boxes
Type 1 - You Type a List of Choices
Type 2 - Display Data from a Table
Type
3 - Display from Master Table, Store in Related Table (Linked)
|
Working with Bands/Form
Change the Background Colour
Rulers/Grid
Form Properties
Command Buttons
Creating with the Wizard
Subforms
Add to Main Form
About Child Fields and Master Fields
Edit a Subform from within the Main Form
Relating Tables
Why
Relate Tables?
How
to Relating Tables
Referential Integrity
Cascade Update/Delete
Testing the Relationship
Edit
and Delete Relationships
Primary Keys and Unique Indexing
See
Related Data in a Table
Creating Reports
All
Applicable Forms Topics, plus:
Wizards, Creating a Blank Report
Print Preview vs. Layout Preview
Page Setup
Report Bands & Band Properties
Sorting and Grouping
Calculations in a Report
Envelopes
Label Wizard
Import, Export, & Link
Importing and Linking Tables
Exporting Tables or Queries
Word
Merge
|