Access 2003 - Level 1

		Book a course:
		State:	Choose a state... QLD WA	Date: What is OLL?
		City:		Time:
		Price:

Duration: 2 Days Overview: In this course, you will be introduced to the concept of the relational database and the Microsoft Office Access 2003 relational database application, and information management tools. Also, you will learn how to design and create a new Access database. Target Audience: This course is designed for students who wish to learn the basic and intermediate-level operations of the Microsoft Access Database program to perform their day to day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The first day addresses job responsibilities that include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications. The second day addresses job responsibilities that include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces integrating Access data with other Microsoft applications. Pre-requisites: Windows XP - Level 1 At Course Completion: You will be introduced to the features of the Microsoft Office Access 2003 application. You will design and create a new Access database; improve queries, forms, and reports; and integrate Access with other applications. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003. Outline: Expand All Module 1: An Overview of Microsoft Access Relational Databases The Access Environment The Database Environment Examine an Access Table Module 2: Managing Data Examine an Access Form Add and Delete Records Sort Records Display Record Sets Update Records Run a Report Module 3: Establishing Table Relationships Identify Table Relationships Identify Primary and Foreign Keys in the Relationships Window Working with Subdatasheets Module 4: Querying the Database The Select Query Add Criteria to a Query Add a Calculated Field to a Query Perform a Calculation on a Record Grouping Module 5: Designing Forms Form Design Guidelines Create AutoForms Create a Form Using the Form Wizard Modify the Design of a Form Module 6: Producing Reports Create an AutoReport Create a Report by Using the Wizard Examine a Report in Design View Add a Calculated Field to a Report Modify the Format Properties of a Control AutoFormat a Report Adjust the Width of a Report Module 7: Planning a Database Design a Relational Database Identify Database Purpose Review Existing Data Determine Fields Group Fields into Tables Normalize the Data Designate Primary and Foreign Keys Module 8: Building the Structure of a Database Create a New Database Create a Table Using a Wizard Create Tables in Design View Create Relationships between Tables Module 9: Controlling Data Entry Restrict Data Entry with Field Properties Create an Input Mask Create a Lookup Field Module 10: Finding and Joining Data Find Data with Filters Create Query Joins Join Unrelated Tables Relate Data Within a Table Module 11: Creating Flexible Queries Set Select Query Properties Create Parameter Queries Create Action Queries Module 12: Improving Your Forms Enhance the Appearance of a Form Restrict Data Entry in Forms Add Command Buttons Create a Subform Module 13: Customizing Your Reports Organize Report Information Set Report Control Properties Control Report Pagination Summarize Information Add a Subreport to an Existing Report Create Mailing Labels Module 14: Expanding the Reach of Your Data Publish Access Data as a Word Document Analyze Access Data in Excel Export Data to a Text File Merge Access Data with a Word Document