• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
12/17/2018 12/17/2018
  • VLT
Live Online

91005: Microsoft Office Access 2013: Part 2 Course 

You're preparing and encounter utilizing Microsoft® Access® 2013 has given you fundamental database administration aptitudes, for example, making tables, planning structures and reports, and building inquiries. In this course, you will extend your insight into social database configuration, compose propelled questions, structure existing information, share information crosswise over applications, and modify reports. Expanding your insight into Microsoft Access 2013 will bring about a vigorous, practical database for your clients. 

You can likewise utilize this course to get ready for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013. 

91005: Microsoft Office Access 2013: Part 2 Audience Profile 

91005: Microsoft Office Access 2013: Part 2 course is intended for understudies wishing to increase halfway level abilities or people whose occupation obligations incorporate developing social databases, performing database support, making propelled inquiries and reports, or coordinating Access with different projects.

91005: Microsoft Office Access 2013: Part 2 Course Outline

Lesson 1: Designing a Relational Database 

  • Theme A: Relational Database Design 
  • Theme B: Create a Table 
  • Theme C: Create Table Relationships 

Lesson 2: Joining Tables 

  • Theme A: Create Query Joins 
  • Theme B: Join Tables That Have No Common Fields 
  • Theme C: Relate Data inside a Table 
  • Theme D: Work with Subdatasheets 
  • Theme E: Create Subqueries 

Lesson 3: Organizing a Database for Efficiency 

  • Theme A: Data Normalization 
  • Theme B: Create a Junction Table 
  • Theme C: Improve Table Structure 

Lesson 4: Sharing Data Across Applications 

  • Theme A: Import Data into Access 
  • Theme B: Export Data to Text File Formats 
  • Theme C: Export Access Data to Excel 
  • Theme D: Create a Mail Merge 

Lesson 5: Advanced Reporting 

  • Theme A: Organize Report Information 
  • Theme B: Format Reports 
  • Theme C: Include Control Formatting in a Report 
  • Theme D: Add a Calculated Field to a Report 
  • Theme E: Add a Subreport to an Existing Report

Awards