Microsoft Access 2016 Part 1

Unlock the full potential of Microsoft Access 2016 with our expertly designed Microsoft Access 2016 Part 1 course. Whether you're a beginner or looking to sharpen your skills, this course is your gateway to mastering database management and analysis.

Key Features:

• CPD Certified
• Free Certificate from Reed
• CIQ Approved
• Developed by Specialist
• Lifetime Access

Digital certificate

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

• Microsoft Access 2016 Part 1 4:35:21

  • 1: Module 01: Orientation to Microsoft Access 27:44
  • 2: Module 02: Create a Table 15:40
  • 3: Module 03: Modify a Table and Fields 06:26
  • 4: Module 04: Modify Table Data 08:25
  • 5: Module 05: Create Table Relationships 10:11
  • 6: Module 06: Data Normalization 12:16
  • 7: Module 07: Create Lookups 11:55
  • 8: Module 08: Create a Junction Table 05:48
  • 9: Module 09: Work with Records 10:13
  • 10: Module 10: Create Action Queries 07:21
  • 11: Module 11: Create Find Duplicate and Find Unmatched Queries 07:28
  • 12: Module 12: Create Parameter Queries 05:43
  • 13: Module 13: Create Query Joins 08:56
  • 14: Module 14: Create Subqueries 05:33
  • 15: Module 15: Sort and Filter Data in a Query 11:40
  • 16: Module 16: Perform Calculations in a Query 09:31
  • 17: Module 17: Summarize Data 06:59
  • 18: Module 18: Relate Data within a Table 05:49
  • 19: Module 19: Join Data from Different Tables in a Query 13:07
  • 20: Module 20: Join Tables That Have No Common Fields 04:16
  • 21: Module 21: Create a Simple Access Database 17:19
  • 22: Module 22: Enhance the Appearance of a Report 04:16
  • 23: Module 23: Format Reports 07:48
  • 24: Module 24: Add a Calculated Field to a Report 04:02
  • 25: Module 25: Add a Sub-report to an Existing Report 05:03
  • 26: Module 26: Create a Mailing Label Report 06:07
  • 27: Module 27: Organize Report Information 09:56
  • 28: Module 28: Export Access Data to Excel 04:57
  • 29: Module 29: Export Data to Text File Formats 05:55
  • 30: Module 30: Publish a Report as PDF 04:29
  • 31: Module 31: Get Help in Microsoft Access 05:22
  • 32: Module 32: Work with Subdatasheets 04:06
  • 33: CPD Certificate - Free 01:00

In the "Microsoft Access 2016 Part 1" course, learners will gain essential skills in using Microsoft Access for managing databases. The course begins with an introduction to Access, teaching you how to create and modify tables and their data. You'll learn how to build relationships between tables, organize data efficiently, and use lookups to make data entry easier. You'll master various types of queries to sort, filter, and analyze your data, including how to handle duplicate records and join data from multiple tables.

Additionally, you'll learn how to create and format reports, including mailing labels and sub-reports. The course also covers exporting data to different formats and publishing reports as PDFs. By the end, you'll be proficient in managing and analyzing data, generating reports, and ensuring your database is well-organized and efficient.

Course Curriculum

• Module 01: Orientation to Microsoft Access
• Module 02: Create a Table
• Module 03: Modify a Table and Fields
• Module 04: Modify Table Data
• Module 05: Create Table Relationships
• Module 06: Data Normalization
• Module 07: Create Lookups
• Module 08: Create a Junction Table
• Module 09: Work with Records
• Module 10: Create Action Queries
• Module 11: Create Find Duplicate and Find Unmatched Queries
• Module 12: Create Parameter Queries
• Module 13: Create Query Joins
• Module 14: Create Subqueries
• Module 15: Sort and Filter Data in a Query
• Module 16: Perform Calculations in a Query
• Module 17: Summarize Data
• Module 18: Relate Data within a Table
• Module 19: Join Data from Different Tables in a Query
• Module 20: Join Tables That Have No Common Fields
• Module 21: Create a Report
• Module 22: Enhance the Appearance of a Report
• Module 23: Format Reports
• Module 24: Add a Calculated Field to a Report
• Module 25: Add a Sub-report to an Existing Report
• Module 26: Create a Mailing Label Report
• Module 27: Organize Report Information
• Module 28: Export Access Data to Excel
• Module 29: Export Data to Text File Formats
• Module 30: Publish a Report as PDF
• Module 31: Get Help in Microsoft Access
• Module 32: Work with Subdatasheets

Learning Outcomes:

• Understand Microsoft Access 2016 interface and basic functions for efficient navigation.
• Create, modify, and manage tables and fields to organise data effectively.
• Develop table relationships and perform data normalisation for structured data.
• Design and execute various types of queries to extract and analyse information.
• Generate, format, and customise reports and mailing labels for data presentation.
• Export data to Excel and text files and publish reports in PDF.

• Individuals wanting to master database management using Microsoft Access.
• Professionals seeking to enhance their data handling and reporting skills.
• Students aiming for a comprehensive understanding of Microsoft Access 2016.
• Employees looking to improve their efficiency in managing and querying data.
• Anyone interested in learning practical database design and reporting techniques.

• Database Administrator
• Data Analyst
• Business Analyst
• Report Developer
• Data Entry Specialist
• IT Support Specialist

Currently there are no Q&As for this course. Be the first to ask a question.