Access 2007 Training Intermediate

Title Banner

Expand All | Collapse All

Chapters	Courseware	Online Learning	Skills Assessments

4. Finding, Filtering, and Formatting Data

Finding and Replacing Data	Demo	Demo	Demo
Sorting Records	Demo	Demo	Demo
Using Common Filters	-	-	-
Filtering by Selection	-	-	-
Filtering by Form	-	-	-
Creating an Advanced Filter	-	-	-
Adjusting and Rearranging Rows and Columns	-	-	-
Changing Gridline and Cell Effects	-	-	-
Changing the Datasheet Font	-	-	-
Freezing a Column	-	-	-
Hiding a Column	-	-	-

5. Working with Tables and Fields

Understanding Field Properties	Demo	Demo	Demo
Indexing a Field	Demo	Demo	Demo
Adding a Primary Key to a Table	-	-	-
Inserting, Deleting, and Reordering Fields	-	-	-
Using Field Descriptions and Captions	-	-	-
Changing the Field Size	-	-	-
Formatting Number, Currency, and Date/Time Fields	-	-	-
Formatting Number, Currency, and Date/Time Fields by Hand	-	-	-
Formatting Text Fields	-	-	-
Setting a Default Value	-	-	-
Requiring Data Entry	-	-	-
Validating Data	-	-	-
Creating an Input Mask	-	-	-
Creating a Lookup Field	-	-	-
Creating a Value List	-	-	-
Modifying a Lookup List	-	-	-

6. Creating Relational Databases

Understanding Table Relationships	Demo	Demo	Demo
Creating Relationships between Tables	Demo	Demo	Demo
Enforcing Referential Integrity	-	-	-
Printing and Deleting Relationships	-	-	-
Understanding Relationship Types	-	-	-

7. Working with Queries

Understanding the Different Types of Queries	Demo	Demo	Demo
Creating a Multiple Table Query	Demo	Demo	Demo
Creating a Calculated Field	-	-	-
Working with Expressions and the Expression Builder	-	-	-
Using an IIF Function	-	-	-
Summarizing Groups of Records	-	-	-
Displaying Top or Bottom Values	-	-	-
Parameter Queries	-	-	-
Finding Duplicate Records	-	-	-
Finding Unmatched Records	-	-	-
Crosstab Queries	-	-	-
Delete Queries	-	-	-
Append Queries	-	-	-
Make-Table Queries	-	-	-
Update Queries	-	-	-

8. Working with Forms

Creating and Using a Form	Demo	Demo	Demo
Understanding Form Views	Demo	Demo	Demo
Modifying a Form in Layout View	-	-	-
Form Design View Basics	-	-	-
Changing Tab Order	-	-	-
Working with Control Properties	-	-	-
Control Property Reference	-	-	-
Working with Form Properties	-	-	-
Changing a Control’s Data Source	-	-	-
Form Property Reference	-	-	-
Creating a Calculated Control	-	-	-
Changing a Control’s Default Value	-	-	-
Creating a Subform	-	-	-
Modifying and Working with Subforms	-	-	-

9. Working with Reports

Creating a Report	Demo	Demo	Demo
Working in Layout View	Demo	Demo	Demo
Adding a Logo	-	-	-
Working in Design View	-	-	-
Adjusting Page Margins and Orientation	-	-	-
Adding Page Numbers and Dates	-	-	-
Grouping and Sorting	-	-	-
Summarize Data using Totals	-	-	-
Understanding Report Sections	-	-	-

10. Formatting Forms and Reports

Formatting Fonts	Demo	Demo	Demo
Changing Text Alignment	Demo	Demo	Demo
Changing Colors	-	-	-
Applying Special Effects	-	-	-
Using Conditional Formatting	-	-	-
Adding Pictures, Lines and Gridlines	-	-	-
Working with Number Formatting	-	-	-
Using AutoFormat	-	-	-

Popular Courses

Copyright © 2010 CustomGuide Inc. - All rights reserved.