Curriculum Design and Instruction To Teach
Microsoft Office Access 2007: Forms:
Volume 4:
Author: Charles Hayes:
Microsoft Office Access, previously
known as Microsoft Access, is a
relational database management
system from Microsoft which combines
the relational Microsoft Jet Database
Engine with a graphical user interface.
It is a member of the 2007 Microsoft
Office system. Access can use data stored
in Access/Jet, Microsoft SQL Server, Oracle,
or any ODBC-compliant data container.
Skilled software developers and data
architects use it to develop application
software. Relatively unskilled programmers
and non-programmer "power users" can use it
to build simple applications. It supports
some object-oriented techniques but falls
short of being a fully object-oriented
development tool.
Special Features Include:
* Phases For Conducting A Needs Assessment:
* Curriculum Design Supplement:
* Curriculum Design Plan:
* Lesson Plans:
* Instructional Goals:
* Instructional Objectives:
* Instructional Activities:
* Instructional Evaluation Techniques:
* Standard Vocabulary:
* A Limited Glimpse:
Topics Include:
@ Queries:
* Introduction:
I. Creating Select Queries:
A. Types of Queries:
B. Creating a Query in Design View:
B. Creating a Query with the Simple
Query Wizard:
C. Viewing Your Query:
D. Understanding Design View:
1. Design view:
2. Working with tables in Design view:
3. Introducting the query design grid:
4. Navigating Design view:
5. Displaying or hiding table names:
F. Tips for Creating a Query:
1. Adding tables to the Query:
2. Inserting fields in a design
grid:
G. Editing a Query:
1. Sorting a query:
2. Viewing top values:
3. Hiding fields:
H. Storing Your Forms and Reports:
1. Form and report management:
2. Importing forms and reports from
other databases:
I. Editing Data Using Forms:
1. Saving your data:
2. Printing Forms:
II. Jazzing Up Your Forms
(and Reports):
A. Taking Control of Your Form
or Report:
1. Form control types:
2. Making a new control:
3. Setting control properties:
B. Making Controls That display
Text:
1. Making and editing labels:
2. Putting Text and Memo fields in
text boxes:
C. Displaying Number, Currency, and
Date Fields:
D. Moving, Renaming, Resizing, Deleting,
and Copying Controls:
E. Formatting Your Text:
1. Copying your formatting:
2. Make it red if it's bad news:
F. Creating Check Boxes for Yes/No Fields:
G. Neatening Up Your Controls:
H. Adding Lines, Boxes, and Backgrounds:
I. Controlling Cursor Movement in Your Form:
III. Creating Smarter Forms:
A. Creating and Configuring Combo and List Boxes:
1. Making combo boxes the really easy way:
2. Running the Combo or List Box Wizard:
B. Cool Looks for Yes/No Fields:
C. Creating Option Groups:
D. Creating Command Buttons:
E. Making a Close Buttons:
1. Making a button to display a related form:
2. Making a button to print the current record:
3. Making other cool buttons:
4. Customizing your command button:
5. Making a find Button:
G. Adding and Linking Subforms:
1. Creating a subform:
2. The properties of subform controls:
H. Adding Form Headers and Footers:
I. Creating Tabbed Forms:
J. You Can't Type That Here!:
K. Making Switchboards-A Friendly Face for
Your Database:
1. The secret life of switchboards:
2. Switchboard Manager, boss of the switchboards:
3. The alternative to switchboards:
IV. Doing Calculations in Forms (and Reports):
A. Doing Elementary Calculations:
1. Making a calculated control:
2. Checking your expression:
3. Troubleshooting expressions:
B. Calculating and Formatting Numbers:
C. Calculating anf Formatting Dates:
D. Calculating and Formatting Text:
E. Adding Subtotals and Totals from Subforms:
1. Using aggregate functions:
2. Referring to control on a subform:
3. Creating the controls to total a subform:
F. Formatting Calculated Controls:
* STATE OF THE ART CURRICULUM DESIGN:
* NEW:
* REFERENCES:
* ILLUSTRATIONS:
* B & W - COLOR PRINT:
* 8 TO 10 INCH FONTS:
* PHOTOS:
* PAPERBACK:
* TRANSPARENT FRONT PAGE:
* TITLE PAGE:
* BLACK OR WHITE BACK PAGE COVER:
* BINDED: BLACK OR WHITE COIL:
* 100 WHITE PAGES: 8x11 INCHES:
* ALLOW 10 TO 14 DAYS TO RECEIVE ITEM:
* ORDER EARLY WHILE SUPPLIES LAST:
