Type
Virtual
Classroom ILT
Skill Level
Available dates
Learning Path
Virtual
Duration
1 Day
TYPE
Virtual
Classroom ILT
LEARNING PATH
SKILL LEVEL
DURATION
AVAILABLE DATES
Introduction
Welcome to the first part of Microsoft Office Access 2016. Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user.
Audience profile
This course is intended to help all novice computer users get up to speed quickly. This course will also help more experienced users who have little to no experience with Microsoft Access and databases in general.
Pre-requisites
This manual assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Students should also be comfortable navigating their computer in order to create and manage files and folders. Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Microsoft Access is necessary.
Course objectives
After completing this course, students will be able to:
- Navigate the Access 2016 interface
- Create a new database from scratch
- Query a database
- Generate reports
- Share data
Course content
Module 1: Getting Started with Access |
Lesson A: Orientation to Microsoft Access
Lesson B: Create a Simple
Lesson C: Get Help in Microsoft Access
|
Module 2: Working with Table Data |
Lesson A: Modify Table Data
Lesson B: Work with Records
Lesson C: Sort and Filter Records
Lesson D: Create Lookups
|
Module 3: Querying a Database |
Lesson A: Join Data from Different Tables in a Query
Lesson B: Sort and Filter Data in a Query Criteria
Lesson C: Perform Calculations in a Query Arithmetic Operators
|
Module 4: Creating Advanced Queries |
Lesson A: Create Parameter Queries
Lesson B: Create Action Queries
Lesson C: Create Find Duplicate and Find Unmatched Queries
Lesson D: Summarize Data
|
Module 5: Generating Reports |
Lesson A: Create a Report
Lesson B: Add Controls to a Report
Lesson C: Enhance the Appearance of a Report
Lesson D: Prepare a Report for Print
|
Module 6: Customizing the Access Environment |
Lesson A: The Access Options
|
Module 7: Designing a Relational Database |
Lesson A: Relational Database Design
Lesson B: Create a Table
Lesson C: Modify a Table and Fields
Lesson D: Create Table Relationships
|
Module 8: Joining Tables |
Lesson A: Create Query Joins
Lesson B: Join Tables That Have No Common Fields
Lesson C: Relate Data within a Table
Lesson D: Work with Subdatasheets
Lesson E: Create Subqueries
|
Module 9: Organizing a Database for Efficiency |
Lesson A: Data Normalization
Lesson B: Create a Junction Table
|
Module 10: Sharing Data Across Applications |
Lesson A: Import Data into Access
Lesson B: Export Data to Text File Formats
Lesson C: Export Access Data to Excel
Lesson D: Create a Mail Merge
|
Module 11: Advanced Reporting |
Lesson A: Organize Report
Lesson B: Format Reports
Lesson C: Include Charts in a Report
Lesson D: Add a Calculated Field to a Report
Lesson E: Add a Subreport to an Existing Report
|
Module 12: Additional Reporting Options |
Lesson A: Create a Mailing Label Report
Lesson B: Publish a Report as PDF
|
Associated certifications and exam
On successful completion of this course students will receive a Torque IT attendance certificate.
Microsoft Overview
Skilled Microsoft engineers add significant value to the marketplace by reducing the cost of technology solutions whilst improving efficiency and fuelling innovation. Through authorized Microsoft training, Torque IT empowers engineers, developers and end-users to realise their full potential by providing them with the necessary knowledge and skills to optimise the adoption and use of Microsoft solutions.
Torque IT considers authorised Microsoft training to be an integral part of any Microsoft implementation. Microsoft authorised training, and associated certification, ensures that you get the most from your technology investment and that you are able to operate above the technology curve. Microsoft career certifications are universally recognised as demonstrating a high level of expertise and credibility for individuals and the organisations that employ them.
Authorized Microsoft training and certification is the industry standard for any solution that includes designing, selling, implementing, upgrading, managing, and operating Microsoft solutions.
For 19 years, Torque IT has maintained the status of Gold Learning Partner for Microsoft in South Africa. This is the highest level of accreditation that Microsoft awards to Learning Partners that specialize in technical, product, sales, development, end-user and solutions training.
These achievements reflect our commitment to providing our customers with quality skills development, enablement, training, and certification solutions that demonstrate exceptional depth, breadth, and expertise across Windows Server, Windows Client, Microsoft Virtualization, Microsoft Azure, Office 365, Exchange Server, SharePoint Server, Skype for Business, System Centre Server, Visual Studio and Microsoft Office technologies.
Torque is recognized by Microsoft, and the industry, as having met rigorous standards for educational competency, service, customer satisfaction and investment in Microsoft technologies that will prepare the next generation of IT industry professionals.