Instructor led, group-paced, classroom-delivery learning model with structured... more details
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Target Students
This course is designed for individuals who wish... more details
This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft Office Access program. The target student may also include individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.
Prerequisites
Before taking this course, students are recommended to... more details
Before taking this course, students are recommended to take the following course, or have equivalent knowledge:
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Course Objectives
Upon successful completion of this course, students will... more details
Upon successful completion of this course, students will be able to:
Streamline data entry and maintain data integrity.
Join tables to retrieve data from unrelated tables.
Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
Improve forms.
Customize reports to organize the displayed information and produce specific print layouts.
Share data between Access and other applications.
Course Content
Lesson 1: Designing a Relational Database
Topic A: Relational... more details
Topic A: Create Query Joins Topic B: Join Tables That Have No Common Fields Topic C: Relate Data within a Table Topic D: Work with Subdatasheets Topic E: Create Subqueries
Lesson 3: Organizing a Database for Efficiency
Topic A: Data Normalization Topic B: Create a Junction Table Topic C: Improve Table Structure
Lesson 4: Sharing Data Across Applications
Topic A: Import Data into Access Topic B: Export Data to Text File Formats Topic C: Export Access Data to Excel Topic D: Create a Mail Merge
Lesson 5: Advanced Reporting
Topic A: Organize Report Information Topic B: Format Reports Topic C: Include Control Formatting in a Report Topic D: Add a Calculated Field to a Report Topic E: Add a Subreport to an Existing Report
Locations
Infero Training Ltd is based in the... more details
Infero Training Ltd is based in the Lace Market in Nottingham. Training courses take place at the following locations including Nottingham, Derby, Loughborough, Mansfield, Chesterfield, Burton-on-Trent, Lincoln, Leicester, Sheffield, Stoke-on-Trent, Tamworth, Wolverhampton, Walsall, Birmingham, Solihul, Coventry, Nuneaton, Peterborough, Grantham.
What you get
Professional Microsoft Certified Trainer
Comfortable Premises, equipped with all the technology you need