Access 2007: Shortcuts

Introduction

• Welcome
• Using the exercise files

• Customizing the Navigation pane
• Toggling between Design and Data views
• Creating new fields with field templates
• Understanding the "Cannot contain a Null value" error
• Working with AutoNumbers as foreign keys
• Using input masks
• Four ways to add fields to a query
• Four ways to filter data
• Selecting multiple form and report controls
• Aligning and distributing controls on forms and reports

• Opening recent files
• Opening your most recently used file automatically
• Selecting a startup form
• Changing the default saving location

• Expanding and collapsing the Ribbon
• Three ways to customize the Quick Access toolbar
• Selecting Ribbon buttons using KeyTips

• Turning the Navigation pane into a switchboard
• Right-clicking
• Using keyboard shortcuts

• Navigating between records
• Using Search, Go to, and Find
• Selecting fields, rows, columns, and tables

• Undo and Redo tips
• Entering data across, not down
• Repeating data from the record above
• Inserting today's date
• Removing automatic hyperlinks
• Using AutoCorrect
• Using concatenated fields
• Linking Outlook contacts
• Saving imports and exports for reuse

• Creating a table using table templates
• Setting data types
• Understanding number field sizes
• Setting default field types
• Using validation rules
• Using flag fields
• Using an index
• Using a datasheet Totals row
• Filtering by selection
• Resizing columns and rows
• Removing gridlines and shading from tables
• Hiding and unhiding table fields
• Freezing fields when scrolling
• Analyzing your table for redundant structure

• Setting a starting AutoNumber
• Creating a multi-field primary key
• Using subdatasheets
• Using relationship reports

• Using wildcards
• Using IN instead of OR
• Hiding query fields
• Changing captions
• Finding duplicate records
• Moving records with append and delete queries
• Using make-table queries
• Creating an update query
• Turning a query into a PivotTable
• Turning a query into a PivotChart
• Using SQL statements

• Using the property sheet to work with controls
• Creating option groups
• Using a ComboBox to select a record
• Creating tabbed form layouts
• Inserting charts
• Creating your own smart tags
• Using the CanGrow and CanShrink properties
• Hiding fields in printouts
• Setting tab stops
• Clipping, stretching, and zooming images
• Viewing single or continuous forms
• Changing a form's default view

• Inserting page breaks in reports and forms
• Creating headers and footers
• Hiding duplicates in reports

• Using the Format Painter
• Setting default appearance for new databases

• Using a Before Change macro to create a time stamp
• Triggering a Before Delete warning message
• Creating a user interface macro
• Using AutoExec macros

• Exporting to PDF
• Compacting and repairing a database
• Locking files

• Goodbye