Courses / Access 2002 Intermedaite
Access 2002 Intermedaite
- Provider
- Solveway
- Course ID
- 084401
- Summary
- As you begin this course, you should have the basic skills you need to design and create relational databases with Access. At this point, you're about knee-deep in Access. You're able to get started and work through many of the essential and straightforward tasks related to your work. You might be hopeful that no one will ever ask for anything too complicated! This course takes you to the next step. By the end of it, you'll be “waist-deep” and more fully able to put the power of database computing to work for you. You will have a handle on many intermediate-level skills, particularly those related to creating more complex queries, customizing your forms and reports, and broadening the availability of your data.
Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.
About the Course
- Target
- This course targets persons who use Access 2002 as a tool for getting their work done. Your responsibilities might include creating and/or revising the design of tables, queries, forms, reports, and data access pages. This course also serves as a prerequisite for persons interested in learning more advanced skills and features.
- Entry requirements
- Students enrolling in this course should have a basic level of understanding of the Access 2000 interface and should have experience designing tables, simple queries, forms, and reports. To ensure your success, we recommend you first take the following Solveway course or have equivalent knowledge:
• Windows 2000 Introduction
• Access 2002 Foundation - Outcome
- You will learn intermediate Access 2002 skills, including how to enhance your database designs by using the principles of table relationships and referential integrity, integrate data with other applications, modify a table design to control data entry, find data with filters and queries, customize forms and reports, and create data access pages.
- Qualifications
- Certificate of attendance
- Content
- Lesson 1: Managing a Database and Data
Topic 1A: Import Data
Topic 1B: Maintain Record Integrity
Topic 1C: Exporting Data
Topic 1D: Documenting Table Relationships
Lesson 2: Controlling Data Entry
Topic 2A: Make Data Entry More Accurate
Topic 2B: Make Data Entry More Efficient
Topic 2C: Facilitate Data Entry
Lesson 3: Finding and Joining Data
Topic 3A: Find Data with Filters
Topic 3B: Get the Correct Data with Query Joins
Topic 3C: Building Bridges Between the Data
Topic 3D: Relating Data within a Table
Lesson 4: Creating Flexible Queries
Topic 4A: Summarizing Data with Queries
Topic 4B: Enter Criteria on the Fly
Topic 4C: Maintain Data with Queries
Lesson 5: Improving Your Forms
Topic 5A: Enhance the Appearance of a Form
Topic 5B: Enhance the Usability of a Form
Topic 5C: Make Your Forms More Professional
Topic 5D: Display Form Data from Multiple Tables
Lesson 6: Customizing Your Reports
Topic 6A: Organize Report Information
Topic 6B: Enhancing Data Layout
Topic 6C: Working with Report Pagination
Topic 6D: Summarizing Information
Topic 6E: Add a Subreport to an Existing Report
Topic 6F: Creating Mailing Labels
Lesson 7: Making Your Data Available on the Web
Topic 7A: Create a Data Access Page
Topic 7B: Improving the Look of a Data Access Page
Topic 7C: Editing Data Using a Data Access Page
Topic 7D: Group Records in a Data Access Page - Cost
- Deals Available for Single and Group Bookings.
Please call 0203 015 4316 or email us at info@solveway.co.uk for our latest deals - Enrolment
Availability
- Duration
- 1 Day
- Provider
- Solveway
Venues/Contact
Company registered address.
20, Heathcliff Avenue
Fairfield Park
Stotfold
Hertfordshire
SG5 4EY
UK
Telephone 0203 015 4316
Email info@solveway.co.uk
Website www.solveway.co.uk
Courses
Syndicate
