In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.
- Course Outline
You have the basic skills needed to work with Microsoft® Office Access™ 2010 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.
**GUARANTEED TO RUN**
- Topic 1A: Constrain Data Entry Using Field Properties
- Topic 1B: Establish Data Entry Formats for Entering Field Values
- Topic 1C: Create a List of Values for a Field
Lesson 2: Joining Tables
- Topic 2A: Create Query Joins
- Topic 2B: Join Tables with No Common Fields
- Topic 2C: Relate Data Within a Table
Lesson 3: Creating Flexible Queries
- Topic 3A: Set the Select Query Properties
- Topic 3B: Retrieve Records Based on Input Criteria
- Topic 3C: Create Action Queries
Lesson 4: Improving Forms
- Topic 4A: Restrict Data Entry in Forms
- Topic 4B: Organize Information with Tab Pages
- Topic 4C: Add a Command Button to a Form
- Topic 4D: Create a Subform
- Topic 4E: Display a Summary of Data in a Form
- Topic 4F: Change the Display of Data Conditionally
Lesson 5: Customizing Reports
- Topic 5A: Organize Report Information
- Topic 5B: Format Reports
- Topic 5C: Control Report Pagination
- Topic 5D: Summarize Report Information
- Topic 5E: Add a Subreport to an Existing Report
- Topic 5F: Create a Mailing Label Report
Lesson 6: Sharing Data Across Applications
Topic 6A: Import Data into Access
Topic 6B: Export Data to Text File Formats
Topic 6C: Export Access Data to Excel
Topic 6D: Create a Mail Merge
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:
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.
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
- Prerequisites & Certificates
Microsoft® Office Access® 2010 : Level 1, or equivalent knowledge and skills.
Certificate of Completion
- Cancellation Policy
Cancellations or postponements received more than ten business days prior to the first day of the course, will be subject to a 15% administration fee, and course ware fees where applicable. The cost of the course is payable, in full, for any cancellations or postponements received within ten business days, or less, prior to the first day of the course.
- Map & Reviews
TekSource Corporate Learning
[ View Provider's Profile ]
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 262 times.