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.
Group Bookings Only - All States and Territories of Australia
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.
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.
Lesson 1: Creating a Strong Foundation for Your Database
- What Is a Relational Database?
- Demonstration: Creating Tables and Using the Relationships Window
- Expert Vide 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