| |
|
| |
Managing Critical Business Information Using Microsoft Office Access 2003 Training Class
Course ID: 5240
|
|
| |
|
|
| |
|
|
| |
Managing Critical Business Information Using Microsoft Office Access 2003 Training Seminar
Overview:
In this course, students learn how to create solid database structures, pull in outside data, and integrate Access with other Microsoft Office System 2003 applications, leading up to creating flexible, user-friendly reports.
Who Should Attend:
This course is designed for experienced Access users. This audience uses Access to store information about their business and is skilled at using tables in datasheet view, creating their own forms and reports, and evenwriting queries. While understanding how to create these Access objects, these students are looking for additional methods for processing data, including importing and linking to data existing outside of Access.
At Course Completion:
After completing this course, students will be able to: - Create solid relational database structures using Access for data integrity that is easier to maintain. - Import data of various formats from outside sources. - Utilize appropriate techniques for querying information in the Access database as various business needs arise. - Create consistent standard user interfaces for inputting data. - Generate powerful and flexible reports for management. - Describe the benefits that can be realized from the integration of Access with other Office 2003 applications,
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Creating a Strong Foundation for Your Database
What Is a Relational Database?
Demonstration: Creating Tables and Using the Relationships Window
Expert Video: Importance of Using Relationships and Referential Integrity
Types of Files Commonly Imported or Linked to Access
Exercise: Importing a Text File and Excel Data
Best Practices for Creating Tables and Utilizing Outside Data
|
|
Lesson 2: Creating an Effective User Interface
Good Form Design
Mapping Out the Forms to Use in the Fourth Coffee Database
Exercise 1: Creating the Necessary Input Forms
Exercise 2: Creating the Main Switchboard and Setting Startup Properties
Best Practices for Creating User Interfaces
|
Lesson 3: Organizing Data Though Queries
Choosing the Right Type of Query for the Task at Hand
Exercise 1: Creating Select and Totals Queries
Retrieving Only the Information That You Want
Exercise 2: Adding Criteria to Queries
Exercise 3: Using Forms and Controls for Criteria
Exercise 4: Adding Data by Using an Append Query
Best Practices for Using Queries to Their Fullest Potential
|
Lesson 4: Reporting Strategic Information with Access
Generating Reports That Display Strategic Information
Exercise 1: Generating the Base Report
Demonstration: Touring Report Design View
Exercise 2: Creating a Macro to Companies Only on the Report
|
Lesson 5: Integrating Access with other Office Applications
Integration with Other Office Applications
Exercise 1: Publishing Information Using Word and Excel
Exercise 2: Creating a Custom Toolbar for Office Links and Mail Recipient
Exercise 3: Performing Mail Merge Between Access and Word
Best Practices for Avoiding the Pitfalls of Integration
| |
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
A basic understanding of relational databases.
An understanding of Access tables, queries, forms and reports and a base knowledge of how they are used within an Access database.
Experience creating Access macros and using them in forms.
A working familiarity with standard Microsoft Office applications (such as Outlook, Word and Excel), as well as a general awareness of Web navigation tools, such as Microsoft Internet Explorer.
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Managing Critical Business Information Using Microsoft Office Access 2003 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5240
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|