|
Microsoft Access 2007 for Database Designers
Need to build or maintain Microsoft Access 2007 databases? This class gives you everything you need.
Based on years of teaching, using Access, and listening to our learners, we have created this Database Designers course, teaching the key topics you need to maximize productivity, including terminology, planning, creating and modifying tables, working with queries, forms, reports and macros.
And to guarantee learning, this two-day format provides plenty of time for hands-on practice and in-class exercises.
Microsoft Access 2007 is a powerful database program you can use to store and organize all kinds of information from a simple list of recipes to a catalogue with tens of thousands of products. When you know how, Access makes your data easy to find, analyze, and report.
Course Outline
DAY ONE
Chapter One: Creating a Database
Planning a Databases
Creating a New Database
Converting an Access Database
Chapter Two: Working with Tables and Fields
Creating a Table
Inserting, Deleting, and Reordering Fields
Adding Fields Descriptions and Captions
Understanding Field Properties
Formatting Text, Number, Currency, and Date/Time Fields
Setting a Default Value
Creating an Input Mask
Validating Data
Requiring Data Entry
Creating a Lookup Field
Modifying a Lookup List
Creating a Value List
Indexing a Field
Adding a Primary Key
Chapter Three: Modifying Tables
Modifying a Table
Creating an Advanced Filter
Changing Gridlines and Cell Effects
Freezing a Column
Hiding a Column
Chapter Four: Working with Queries
Understanding Different Types of Queries
Creating a Multiple Table Query
Creating a Calculated Field
Working with Expressions and the Expression Builder
Using an IF function
Summarizing Groups of Records
Display Top or Bottom Values
Chapter Five: Query Types
Finding Duplicate Records
Finding Unmatched Records
Parameter Queries
Delete Queries
Append Queries
Make Table Queries
Update Queries
Crosstab Queries
DAY TWO
Chapter Six: Working with Forms
Modifying a Form in Layout View
Form Design View Basics
Changing Tab Order
Working with Control Properties
Control Property Reference
Working with Form Properties
Form Property Reference
Changing a Control's Data Source
Creating a Calculated Control
Changing a Control's Default Value
Creating a Subform
Modifying and Working with Subforms
Chapter Seven: Working with Reports
Working in Layout View
Adding a Logo
Working in Design View
Adjusting Page Margins and Orientation
Adding Page Numbers
Grouping and Sorting
Summarize Data Using Totals
Understanding Report Sections
Chapter Eight: Formatting Forms and Reports
Formatting Fonts
Changing Text Alignment
Changing Colours
Applying Special Effects
Using Conditional Formatting
Adding Pictures, Lines, and Gridlines
Working with Number Formatting
Using AutoFormat
Chapter Nine: Working With Macros
Creating and Running a Macro
Editing a Macro
Working with Macro Groups
Assigning a Macro to an Event
Creating Conditional Expressions
Assigning a Macro to a Keystroke Shortcut
Macro Action Reference
Chapter Ten: Advanced Topics
Importing Information
Exporting Information
Linking Information from an External Source
Using Hyperlink Fields
Displaying Database Object Dependencies
Setting a Password in Access
Compacting and Repairing a Database
Student Data Files for this class are located here.
|