Further Details
Table Relationships
· Multi-table concepts
· Relating Tables
· Join Types
· Deleting Relationships
· Enforcing Relationships
Queries
· Querying multiple tables
· Parameter Queries
· Totals Queries
· Delete Queries
· Append Queries
· Make Table Queries
· Update Queries
Import / Export
· Importing / Exporting from Excel
· Importing / Exporting from Access
· Importing / Exporting from Text
· Linking vs Importing
Forms
· Using Option Groups and Check Boxes
· Using Page Tabs
· Changing the data source of the form
· Adding lines and boxes
· Using Conditional formatting
· Creating multi-table forms
Reports
· Using the wizard to create grouped reports
· Understanding the design
· Manually changing grouping settings
· Resizing and moving objects
· Adding subtotals and averages
· Making cosmetic changes to a report
Guide price
£150 |
