Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


This course is designed for databases managers. Topics include: database replication, databases & the Internet, sharing databases on a network, administrating a database, optimizing database performance, creating MDE files, and setting program defaults.


 
Course Outline

This course takes an in-depth look at sharing databases on a network, using Access with other programs, using Access and the Internet, optimizing a database, and setting defaults.

This course is classroom style instruction: Instructor-led, hands-on training.

Sharing Databases on a Network
Sharing Records
Record Locking Strategies
Splitting a Database
Replicating a Database
Replicating a Database Using Briefcase
Recovering Design Master
Resolving Conflicts
Synchronization of Replicas
System Files

Hyperlinks
Linking to Other Databases
Linking to an Excel Spreadsheet
Linking to Excel Using Range Names
Linking to a Word Document
Linking to Part of a Word Document Using Bookmarks
Linking to a PowerPoint Presentation
Linking to Part of a PowerPoint Presentation
Editing Hyperlinks
Placing Hyperlink in a Form/Report
Linking to an Internet Address

Publishing Access on the WEB
Different HTML Types
Templates vs. Web Pages
Designing a Template
Using Graphics and Scrolling Text
 
Using Video and Sound
Creating the Web Page in Access
Creating Home Pages
Saving Publication Profiles

Optimizing Performance
Table Design Tips
General Performance Tips
Adjusting Virtual Memory Settings
Analyzing Your Database
Analyzing a Table
Analyzing Objects
Improving Multiuser Performance
Improving Performance in Queries
Improving Performance in Forms Improving Performance in Reports

Setting Program Defaults
Setting View Defaults
Setting General Defaults
Setting Hyperlink/HTML Defaults
Setting Edit/Find Defaults
Setting Keyboard Defaults
Setting Datasheet Defaults
Setting Table/Query Defaults
Setting Form/Report Defaults
Setting Advanced Defaults

MDE Files
Overview
Creating MDE Files
Using MDE Files
Limitations

Start Up Options
Application Title and Icon
Designing and Setting
Default Menu Bars
Shortcut "Popup" Menus
Toolbars
Limiting Display of Objects
Disallowing Menu/Toolbar Changes
Startup Options vs Autoexec Macros
Bypassing Startup Options


Prerequisites & Certificates
Pre-Requisites

Course Prerequisite: Required: Solid understanding of all Introduction, Intermediate Level I & Advanced Level I topics.

Certificates offered

Participants receive with this course: * courseware (notes on all topics covered, along with exercises used during course). * a certificate of completion


Cancellation Policy

Map & Reviews
Computer Help
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 341 times.