Access 2007 Intermediate
Take This Course $250
by CompuWorks
This course builds on the skills and concepts taught in Access 2007: Introduction. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.
MODULE 1: Introduction
-
Video Lesson 1:
Introduction
MODULE 2: Relational Database Concept Overview
-
Video Lesson 1:
Understanding Relationships
-
Video Lesson 2:
Enforcing Referential Integrity
-
Video Lesson 3:
Modifying and Deleting Relationships
MODULE 3: Table Design
-
Video Lesson 1:
Field Components
-
Video Lesson 2:
Accessing Field Properties
-
Video Lesson 3:
Using Text-Based Field Types
-
Video Lesson 4:
Using Numeric Field Types
-
Video Lesson 5:
Using Other Field Types
-
Video Lesson 6:
Setting Formats
-
Video Lesson 7:
Setting Input Masks
-
Video Lesson 8:
Adding Captions
-
Video Lesson 9:
Setting Default Values
-
Video Lesson 10:
Setting Validation Rules
-
Video Lesson 11:
Required Property
-
Video Lesson 12:
Indexed Property
-
Video Lesson 13:
Unicode Compression Property
MODULE 4: Calculations
-
Video Lesson 1:
Performing Calculations with Queries
-
Video Lesson 2:
Concatenating Text
-
Video Lesson 3:
Calculating Totals in a Query
MODULE 5: Multi-Table Queries
-
Video Lesson 1:
Understanding Multi-Table Queries
-
Video Lesson 2:
Creating a Multi-Table Query
-
Video Lesson 3:
Grouping and Counting Totals
-
Video Lesson 4:
Referencing Calculated Fields in Another Query
-
Video Lesson 5:
Fixing WHERE Clause Errors
-
Video Lesson 6:
Calculating the Top Five Customers
MODULE 6: Action Queries
-
Video Lesson 1:
Understanding Action Queries
-
Video Lesson 2:
Using Make Table And Append Queries
-
Video Lesson 3:
Using Update Queries
-
Video Lesson 4:
Using Delete Queries
MODULE 7: Parameter Queries
-
Video Lesson 1:
Understanding Parameter Queries
-
Video Lesson 2:
A Simple Parameter Query
-
Video Lesson 3:
Parameter Queries With Wildcards
-
Video Lesson 4:
Finding Date Ranges
-
Video Lesson 5:
Creating Multi-Parm Queries
MODULE 8: Calculations In Forms
-
Video Lesson 1:
Understanding Forms
-
Video Lesson 2:
Understanding The Hidden Table
-
Video Lesson 3:
Resizing Controls
-
Video Lesson 4:
Performing Calculations With Bound Text Boxes
-
Video Lesson 5:
Setting Control Properties
MODULE 9: Advanced Form Functions
-
Video Lesson 1:
Creating a Combo Box
-
Video Lesson 2:
Creating a Calculated Control
-
Video Lesson 3:
Adding Label and Formatting Control
MODULE 10: Advanced Report Functions
-
Video Lesson 1:
Using The Report Wizard
-
Video Lesson 2:
Using A Calculated Control To Concatenate Text
-
Video Lesson 3:
Creating Other Calculated Controls
-
Video Lesson 4:
Making The Control Source A Parameter Query
-
Video Lesson 5:
Using Report Bands
-
Video Lesson 6:
Using The Group/Sort Panel
MODULE 11: Conclusion
-
Video Lesson 1:
Conclusion
View All Users Who Viewed This Course Also Viewed
CompuWorks
CompuWorks is a collaborative of computer training specialists with over 25 years’ experience teaching students how to get the most out of their technology tools. CompuWorks innovative elearning videos display trainers on screen all the time creating a learning experience that most closely mimics a traditional classroom.
Other Courses from CompuWorks
-
$250Word 2007 Intermediate
-
$250Word 2007 Introduction
CompuWorks authored 51 courses
View All
No User Found
0 Reviews