|
Access 2007 Foundation
Getting Started
Starting Out
What is Microsoft
Access?
What’s New in Access 2007?
Basic Terminology
Opening Microsoft Access
Interface Overview
Closing Microsoft Access
Step-By-Step
Skill Sharpener
Using the Getting
Started Window
Overview of the
Window
Navigating Through the Window
Creating a Database from a Template
Creating a Blank Database
Step-By-Step
Skill Sharpener
The Trust Center
Warnings You May See when
Opening a Database
Enabling Content
About Digital Signatures
About Trusted Locations
Opening the Trust Center
Assigning a Password to your Database
Step-By-Step
Skill Sharpener
Getting Help
Opening the Help
Screen
Overview of the Help Screen
Online Help vs. Offline Help
Searching for Help
Step-By-Step
Skill Sharpener
Case Study
Review Questions
The
New Interface
Using the Quick
AccessToolbar
About the Default
Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar
Step-By-Step
Skill Sharpener
Basics of Ribbons
About Ribbons
Opening Dialogue Boxes from the Ribbon
About the Office Menu
Step-By-Step
Skill Sharpener
The Home Ribbon
Views
Clipboard
Font
Rich Text
Records
Sort and Filter
Find
Step-By-Step
Skill Sharpener
Create Ribbon
Tables
Forms
Reports
Other
Step-By-Step
Skill Sharpener
External Data Ribbon
Import
Export
Collect and Data
SharePoint Lists
Step-By-Step
Skill Sharpener
Database Tools Ribbon
Macro
Show/Hide
Analyze
Move Data
Database Tools
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Creating a Database
First Steps
Planning a Database
Creating a Database from a Template
Creating a Blank Database
Using Database Objects
Setting Navigation Options
Step-By-Step
Skill Sharpener
About Records
What is a Record?
Navigation Tips
Adding Records
Editing Records
Deleting Records
E-Mailing Records
Printing Records
Step-By-Step
Skill Sharpener
Creating a Table
About Tables
Creating a Table
Entering Data into a Table
Formatting a Table
Step-By-Step
Skill Sharpener
Formatting Text
Using the Zoom Box
Selecting Data
Cutting, Copying, and Pasting
Using the Format Painter
Using Undo and Redo
Checking your Spelling
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Doing More with your
Database
Creating Forms
What is a Form?
Bound vs. Unbound Controls
Creating a Form with the Wizard
Using Design View to Modify Your Form
Using Forms
Step-By-Step
Skill Sharpener
Creating Queries
What is a Query?
Creating a Query with the Wizard
Using Design View to Modify a Query
Using Queries
Step-By-Step
Skill Sharpener
Reports
What is a Report?
Creating a Report with the Wizard
Using Design View to Modify a Report
Using Reports
Step-By-Step
Skill Sharpener
Sorting and Filtering
Data
Using Find and
Replace
Sort Ascending or Descending
Toggling Filter
Using Selection Sort
Using Advanced Sort
Step-By-Step
Skill Sharpener
Viewing Data
Using the View Menu
Using the View Icons
Using the Tabs
Closing Individual Tabs
Step-By-Step
Skill Sharpener
Printing a Database Object
Using the Quick Print
Icon
Using the Print Menu
Using Print Preview
Using the Print Preview Ribbon
Printing vs. Exporting
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Index
Access 2007
Intermediate
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
Step-By-Step
Skill Sharpener
Database Management
Compact and Repair a
Database
Backing up Your Database
Editing Database Properties
Step-By-Step
Skill Sharpener
Saving Your Files
Using the Save As
Dialogue
Using the Save As Menu
Using File Properties
Using AutoRecover
Step-By-Step
Skill Sharpener
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
Step-By-Step
Skill Sharpener
Linking Files
Linking to an Excel
Spreadsheet
Linking to Another Database
Linking to a SharePoint Site
Other Types of Linked Documents
Creating a Hyperlink
Step-By-Step
Skill Sharpener
Case Study
Review Questions
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
Step-By-Step
Skill Sharpener
Formatting Tables
Formatting Number
Fields
Formatting Text Fields
Adding Field Descriptions
Changing Field Data Types
Step-By-Step
Skill Sharpener
Controlling Table Data
Entry
Setting a Default Value
Setting a Required Value
Creating and Using Input Masks
Creating and Removing Table Relationships
Step-By-Step
Skill Sharpener
Managing Table Data Entry
How to Validate Data
Creating a Lookup Field
Modifying a Lookup Field
Creating a Value List
Modifying a Value List
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Working with Forms
Basic Form Controls
Adding a Control
Using the Control Wizard
Cutting, Copying, Pasting, and Moving a Control
Formatting a Control
Step-By-Step
Skill Sharpener
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
Step-By-Step
Skill Sharpener
Formatting Your Form
Formatting Gridlines
Modifying the Font
Adding Logos
Changing the Layout
Step-By-Step
Skill Sharpener
Formatting Controls
Changing the Color of a
Control
Using Control Properties
Aligning Controls
Applying Special Effects
Step-By-Step
Skill Sharpener
Formatting Records
Modifying Fonts
Using AutoFormat
Using the Formatting Ribbon
Using the Arrange Ribbon
Step-By-Step
Skill Sharpener
Case Study
Review Questions
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
Step-By-Step
Skill Sharpener
Formatting Reports
Formatting Gridlines
Modifying the Font
Adding Logos
Changing the Layout
Using AutoFormat
Step-By-Step
Skill Sharpener
Common Report Tasks
Adding a Photo
Adjusting Page Properties
Adding Headers and Footers
Adding Page Numbers
Using the Label Wizard
Step-By-Step
Skill Sharpener
Case Study
Review Questions
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
Step-By-Step
Skill Sharpener
Multiple Table Queries
Creating a Multiple Table
Query
Creating a Calculated Field
Using the Expression Builder
Using Queries to Summarize
Step-By-Step
Skill Sharpener
Using Advanced Queries
Creating a Parameter
Query
Using Parameter Queries
Creating Crosstab Queries
Using Crosstab Queries
Using Make-Table Queries
Step-By-Step
Skill Sharpener
Management (Action)
Queries
Append Queries
Delete Queries
Update Queries
Exporting Queries
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Index
Access 2007
Advanced
Advanced Data Management
Referential
Integrity
Using the Relationships
View and Ribbon
Types of Relationships
Establishing Referential Integrity
Enforcing Referential Integrity
Testing Referential Integrity
Step-By-Step
Skill Sharpener
Table Relationships
About Join
Lines
Normalizing Tables
Using Cascade Delete and Cascade Update
Setting Fields for Indexing
Using the Index
Step-By-Step
Skill Sharpener
Switchboards
Using a Switchboard vs.
Using the Navigation Pane and Ribbon Using the
Switchboard Manager
Creating a Switchboard
Editing a Switchboard
Deleting a Switchboard
Step-By-Step
Skill Sharpener
Modal Dialogue Boxes
Creating a Modal Dialogue
Box
Adding Controls
Setting Properties
Formatting your Dialogue Box
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Advanced Form Tasks
Using Subforms
Creating a Subform
Modifying a Subform
Working with a Subform
Synchronizing Subform Data with a Main Form
Displaying a Subform within a Main Form
Step-By-Step
Skill Sharpener
Advanced Form Tasks
Limiting User Access to a
Form
Creating Check Boxes and Command Buttons
Creating Event Procedures
Customizing Error Messages
Step-By-Step
Skill Sharpener
Exporting Your Form
Sending a Form via
E-Mail
Managing Replies
Exporting your Form to XML
Step-By-Step
Skill Sharpener
Using Outlook and
SharePoint with Access
Creating an RSS Feed for
Outlook
Importing Contacts from Outlook
Importing Contacts from a SharePoint Server
Moving your Database to a SharePoint Server
Publishing to a Web Server
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Pivoting Data
Creating a PivotTable
About PivotTables
Creating a PivotTable
More about PivotTable Fields
Completing your PivotTable
Step-By-Step
Skill Sharpener
Creating a PivotChart
About PivotCharts
Creating a PivotChart
More about PivotChart Field
Completing Your PivotChart
Step-By-Step
Skill Sharpener
Using PivotTables and
PivotCharts
Using a PivotTable
Using a PivotChart
Editing a PivotTable or a PivotChart
Common PivotTable and PivotChart Editing Commands
Creating a PivotTable and PivotChart from the Same Object
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Access and Windows
Access and Windows
Recovering Access
Starting Access on Windows Boot
Using Office Diagnostics
Checking for Updates
Step-By-Step
Skill Sharpener
Using the Access Viewer
What is the Access
Viewer?
Downloading the Viewer
Using the Viewer
Step-By-Step
Skill Sharpener
An Introduction to SQL
What is SQL?
Parts of an SQL Statement
SQL Keywords
Adding Where Clauses
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Access 2007 Expert
Add-ons to Access
COM Add-Ins
What is a COM
Add-In?
Using the Add-Ins Tab
Opening the Add-In Manager
Loading Add-Ins
Using the Trust Center
Step-By-Step
Skill Sharpener
Digital Signatures
What is a Digital Signature?
Obtaining a Digital Signature
Attaching Your Signature to a Database
Skill Sharpener
Smart
Tags
What is a Smart Tag?
Inserting Smart Tags into a Database
Customizing Smart Tags
Setting Smart Tag Options
Step-By-Step
Skill Sharpener
Managing Your Database
Analyzing Performance
Analyzing Tables
Viewing Object Dependencies
Splitting a Database
Database Replication
Step-By-Step
Skill Sharpener
Customizing Access
Opening the Options
Dialogue
Overview of the Options Dialogue
Changing User Information
Setting Security Options
Making Access Work Backwards
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Using Scripts in Access
Macro Basics
Creating Macros
Playing Macros
Macro Security
Deleting Macros
Step-By-Step
Skill Sharpener
Other Macro Tasks
Embedding a Macro
Assigning a Macro to a Keystroke
Assigning a Macro to an Event
Assigning a Macro to a Control
Step-By-Step
Skill Sharpener
Visual Basic and Macros
Opening the Visual Basic
Editor
Adding Code to your Macro
Adding Comments to VBA Code
Declaring Variables
Prompting for User Input
Using If-Then-Else Statements
Step-By-Step
Skill Sharpener
Macro Groups
Creating a Macro
Group
Running a Macro Group
Editing a Macro Group
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Using Access to Collaborate
SharePoint Basics
What is SharePoint?
System Requirements
Creating a Workspace
Accessing a Workspace
Publishing to a Workspace
Step-By-Step
Skill Sharpener
SharePoint Data
Using Offline Lists
Exporting a List
Restricting Permission for Data Objects
Skill Sharpener
Your Personal SharePoint
Space
Public and Private
Views
Shared and Private Documents
Creating a List
Creating a Page
Personalizing your Space
Step-By-Step
Skill Sharpener
Case Study
Review Questions
SQL and Microsoft
Access
Understanding SQL
What is an SQL
Database?
What is an SQL Statement?
What is an SQL Convention?
What is SQL Syntax?
Linking a Database to an SQL Server
Step-By-Step
Skill Sharpener
Using the SELECT
Statement
Selecting All Data
Selecting Specific Date
Selecting Conditional Data
Using the ORDER BY Statement
Step-By-Step
Skill Sharpener
Using Subqueries
What is a Subquery?
Creating a Subquery
Subqueries with Equality
Subqueries with Aggregate Functions
Nested Subqueries and Uses of the IN Keyword
Step-By-Step
Skill Sharpener
Using SQL Joins
Creating Simple Joins
Using an Alias
Sorting Joins
Creating Outer Joins
Step-By-Step
Skill Sharpener
Case Study
Review Questions
Index
|
