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: