Course Schedule:
Please call 8622 8900 or
email us for further information
Overview:
This scenario-based class provides experienced Microsoft Access users with a stronger relational database foundation. It brings home relational database concepts and teaches how to employ powerful techniques using Access in gathering, organising, and reporting of information vital to your business. You will learn how to create solid database structures, how to pull in outside data, and how to integrate Access with other Microsoft Office System 2003 applications - all leading up to creating flexible, user-friendly reports. The goal of this course is to give you more confidence in managing your business information using various Access database techniques, thus enabling you to accomplish your daily work more efficiently and competently.
Learning Method:
Instructor led.
Who will benefit from this course?
This course is designed for experienced Access users – those who use Access to store information about their business and are skilled at using tables in datasheet view, creating their own forms and reports, and even writing queries. While understanding how to create these Access objects, you are looking for additional methods for processing data, including importing and linking to data existing outside of Access.
Pre-requisites:
Before attending this course, you must have:
- 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 Microsoft Outlook, Word, and Excel)
What can you expect to gain from this course?
After completing this course, you will b 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.
- Utilise 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 realised from the integration of Access with other Office 2003 applications
Course Content:
Module 1:Creating a Strong Foundation for Your Database
- This module introduces the concepts of relational database design, including creating tables and relationships, as well as importing data into tables from various external sources.
- 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 Utilising Outside Data
Module 2: Creating an Effective User Interface
- This module introduces form design standards and creating interfaces. Creating switchboards and utilising the Form Wizard to create a base and modify a form is also discussed in this module.
- 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
Module 3:Organising Data Though Queries
- This module introduces the advantage of different types of queries to organise and provide views of data in various ways as necessary for a business. In addition, the use of parameters and practice to retrieve only the data the students need are covered in this module. Finally, this module shows students how to display parameterised queries using a Combo Box located on a form.
- 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
Module 4: Reporting Strategic Information with Access
- This module discusses reporting strategic information using Access by showing techniques for calling reports from forms and by adding macros to turn on and turn off reports to display the data users require.
- 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
Module 5:Integrating Access with other Office Applications
- This module shows how to take information contained within your Access database and merge it 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