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:
