Advanced File Tasks
Using My Computer within Access
Navigating with My Computer
Performing Basic Tasks with My Computer
Changing Views with my Computer
Using the My Places Toolbar
Database Management
Compact and Repair a Database
Backing up Your Database
Editing Database Properties
Saving
Your Files
Using the Save As Dialogue
Using the Save As Menu
Using File Properties
Using AutoRecover
Exporting Files
Exporting to PDF or XPS
Exporting to Word or Excel
Exporting to Other Destinations
Using Saved Exports
Exporting to a CAB File
Exporting to Older Versions of Access
Linking Files
Linking to an Excel Spreadsheet
Linking to Another Database
Linking to a SharePoint Site
Other Types of Linked Documents
Creating a Hyperlink
Working with
Tables
Customizing Tables
Understanding Field Properties
Adding a Primary Key to a Table
Indexing a Field
Inserting, Deleting, and Moving Fields
Importing a Table from another Source
Formatting Tables
Formatting Number Fields
Formatting Text Fields
Adding Field Descriptions
Changing Field Data Types
Adding Captions
Controlling Table Data Entry
Setting a Default Value
Setting a Required Value
Creating and Using Input Masks
Creating and Removing Table Relationships
Managing Table Data Entry
How to Validate Data
Creating a Lookup Field
Modifying a Lookup Field
Creating a Value List
Modifying a Value List
Working with
Forms
Basic Form
Controls
Adding a Control
Using the Control Wizard
Cutting, Copying, Pasting, and Moving a Control
Formatting a Control
Advanced Form Controls
Modifying a Control’s Properties
Changing a Control’s Data Source
Changing a Control’s Default Value
Creating a Calculated Control
Using Form Properties |
Formatting
Your Form
Formatting Gridlines
Modifying the Font
Adding Logos
Changing the Layout
Formatting Controls
Changing the Color of a Control
Using Control Properties
Aligning Controls
Applying Special Effects
Formatting Records
Modifying Fonts
Using AutoFormat
Using the Formatting Ribbon
Using the Arrange Ribbon
Working with
Reports
Organizing Report Data
Adding and Removing Fields
Using Report Sections
Changing Section Properties
Grouping and Sorting in a Report
Changing Group Properties
Using Calculated Controls in a Report
Formatting Reports
Formatting Gridlines
Modifying the Font
Adding Logos
Changing the Layout
Using AutoFormat
Common Report Tasks
Adding a Photo
Adjusting Page Properties
Adding Headers and Footers
Adding Page Numbers
Using the Label Wizard
Working with
Queries
Basic Queries
Review of Queries
Creating a Query
Sorting a Query
Filtering a Query
Hiding Fields
Using AND OR Operators
Use of IIF Functions
Multiple Table Queries
Creating a Multiple Table Query
Creating a Calculated Field
Using the Expression Builder
Using Queries to Summarize
Using Advanced
Queries
Creating a Parameter Query
Using Parameter Queries
Creating Crosstab Queries
Using Crosstab Queries
Using Make-Table Queries
Management
Queries
Append Queries
Delete Queries
Update Queries
Exporting Queries
|