MS Access 2003 Level 2 - 1 Day

Location: Toronto Date: 2010-03-24
List Price: $245 Offered Price: $196.00
Seats Available: 3

TekSource Corporate Learning ~ Windows Server Training in Toronto Cancellation Policy

Description:

As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications. 

**GUARANTEED TO RUN**

Course Objective

You will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft® Office Access 2003 with other applications.

Target Student: Microsoft® Access 2003:

Course Content

Lesson 2: Building the Structure of a Database
Topic 2A: Create a New Database
Topic 2B: Create a Table Using a Wizard
Topic 2C: Create Tables in Design View
Topic 2D: Create Relationships between Tables

Lesson 3: Controlling Data Entry
Topic 3A: Restrict Data Entry with Field Properties
Topic 3B: Create an Input Mask
Topic 3C: Create a Lookup Field

Lesson 4: Finding and Joining Data
Topic 4A: Find Data with Filters
Topic 4B: Create Query Joins
Topic 4C: Join Unrelated Tables
Topic 4D: Relate Data Within a Table

Lesson 5: Creating Flexible Queries
Topic 5A: Set Select Query Properties
Topic 5B: Create Parameter Queries
Topic 5C: Create Action Queries

Lesson 6: Improving Your Forms
Topic 6A: Enhance the Appearance of a Form
Topic 6B: Restrict Data Entry in Forms
Topic 6C: Add Command Buttons
Topic 6D: Create a Subform

Lesson 7: Customizing Your Reports
Topic 7A: Organize Report Information
Topic 7B: Set Report Control Properties
Topic 7C: Control Report Pagination
Topic 7D: Summarize Information
Topic 7E: Add a Subreport to an Existing Report
Topic 7F: Create Mailing Labels

Lesson 8: Expanding the Reach of Your Data
Topic 8A: Publish Access Data as a Word Document
Topic 8B: Analyze Access Data in Excel
Topic 8C: Export Data to a Text File
Topic 8D: Merge Access Data with a Word Document

Appendix A: Microsoft Office Specialist Program

About our GUARANTEED TO RUN courses

With (R)Evolution, TekSource is transforming the way IT professionals receive training. Our courses are led by Certified Instructors and supported by online course mentors. Course content is delivered through expert video modules and interactive features, in tandem with virtual lab exercises and progress quizzes. When you take training with TekSource, you get a comprehensive training solution that incorporates the following value add components into one “revolutionary” offering:>

Pre-class Facilitation

We start the learning process well before you arrive at our door with lots of communication and information. Our instructors, coordinators and facilitators will ensure that when course participants arrive, they will have all the tools they need to be successful and students will have already started to learn

In our Facility with Certified instructors

With (R)Evolution, each course is supported by a certified instructor who facilitates, coaches and mentors the students through the learning process - their only job is to ensure our students’ success. Students attend class in one day increments (which can be non-consecutive days for multi-day courses).

• Since the course content is provided by the expert video modules, the in-class instructor can devote 100% of their time to individual instruction and guidance.
• Our exclusive consultative learning approach ensures that the needs of each student are assessed and support during and subsequent to the course is tailored to them.

Expert Video Modules

(R)Evolution guarantees consistent, high quality instruction, and uniform delivery of the course material mapped to official vendor course curriculum with no missed topics.

• Content is delivered by World Class Experts and Certified Trainers and it has been edited and produced so that students are presented the best possible delivery of the course material.
• Self Scheduled progress matches the learning speed of each student – it allows for instant review, and results in improved retention.
  

Interactive Content

Throughout the Learning experience, instruction is reinforced with practical exercises, lab exercises completed in live lab environments and progress checks that give immediate feedback to the student regarding their progress.

• Keeps students engaged, on track and in line with their objectives
• Provides instant feedback, real time results and acts as a measure for the instructor to provide further mentorship

Online Mentoring and Support

The online mentoring support that is included with (R)Evolution starts when the student enters the classroom and continues for 6 months. As both a 3rd training resource in the classroom and as a valuable support service that is available 24/7, students have yet another mechanism to support their learning.

• Reinforces learning and acts as a support during the classroom session
• Assistance applying course concepts
• Access to our facility and ability to re-take some or all of the training is absolute assurance that required learning is received.

Pre-Requisites:

To ensure the successful completion of Microsoft Access 2003: Level 2, we recommend completion of the following courses, or equivalent knowledge (basic familiarity with Access tables, relationships, queries, forms, and reports) from another source:
• Microsoft Access 2003: Level 1
A basic understanding of Microsoft® Excel and Microsoft® Word would also be helpful, but is not required.

Certificates offered:

Participants will receive a course manual and certificate of participation.

Duration Details:

1 full day - 9:00 - 4:30 (center opens at 8 and closes at 5)

Facility Location:

TekSource Learning Center
36 Lombard Street, Suite 600
Toronto
Ontario
Canada
M5C 2X3

This listing has been viewed 9 times.