Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality met...Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics. Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, like research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility such as time reporting or recording a sale.But virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will learn how to use Access 2013 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data. You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2013.Show MoreCourse Prerequisites:
Computer Literacy Request a Quote
Instructor-Led Training (ILT)
Attend training in a classroom environment at a campus near you. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.
Duration 1 Day
Upcoming dates for MOS: Microsoft Office Access 2013 Intermediate
Hang on... we're fetching some dates from the Course Schedule.
MOS: 70-424 Microsoft Office Access 2013 Intermediate
Lesson 2: Joining Tables
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
MOS: 70-424 Microsoft Office Access 2013 Advanced
CTU Training Solutions, Updated: April 24th, 2018
Share with friends
Request a Quote
The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates.
Terms and Conditions
Refer a friend
Save 23% when you register for the Cisco CCNA Routing and Switching (CCNAX) course at CTU, or share it with a friend and get 5% on your course of choice!
Either way you win!
Join the CTU community
Join the CTU Community Portal and gain access to superior resources.