Curriculum Design and Instruction To Teach

Microsoft Office Access 2007: Database

Administration: Volume 7:


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:


@ Database Administration:

* Introduction:

I. Database Housekeeping:

A. Compacting and Repairing Your

Database:

B. Making Backups:

1. Backing up your database:

2. Backing up specific objects:

C. Converting Databases:

D. Analyzing and Documenting Your

Database:

1. Viewing relationships in the

Relationships window:

2. Looking at a list of the objects in

your database:

3. Viewing object dependencies:

4. Analyzing database performance:

5. Documenting your database:

E. Loading and Managing Add-Ins:

1. Running the Add-in Manager:

2. Creating add-ins:

F. Locking Up Your Database as an ACCDE File:

1. Creating an ACCDE file:

2. Making updates later:

II. Sharing the Fun and the Database:

Managing Multiuser Access:

A. Putting Your Database Where They Can

See It:

B. Splitting Your Database into a Front

end and a Back End:

1. Why split?

2. Let's split:

3. Splitting by hand:

4. Handing out front ends:

5. Relinking your tables:

C. Putting Your Favorite Objects into

Groups:

1. Making and unmaking new groups:

D. Editing with Multiple Users:

1. Fixing Exclusive access:

2. Managing record-locking:

III. Securing Your Access Database:

A. Windows Security:

B. Setting Startup Options:

C. Password-Protecting Your Database:

1. Encrypting your database with a password:

2. Opening a password-protected database:

D. Granting Database Access to Specific Users:

1. How user-level security works:

2. The default workgroup file:

3. Your new workgroup file:

4. Choosing your users and groups:

5. Securing a database:

6. Opening your secure database:

7. Setting passwords:

8. Creating the rest of your users

and groups:

9. Setting permissions for groups:

10. Securing your VBA modules:

11. Securing front-end and back-end

databases:

* 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: