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

91004: Microsoft Office Access 2013: Part 1 About this Course 

Information is all around. Regardless of whether you are at the supermarket, office, research center, classroom, or ballpark, you are inundated with information: costs, plans, execution measures, lab comes about, formulas, contact data, quality measurements, advertise files, evaluations, and insights. 

Most employment parts today include some type of information administration. On account of information specialists, it might be their essential occupation assignment. For a few, similar to look into researchers and bookkeepers, information administration might be a solid segment of the employment. What's more, for others, for example, deals assistants or those in the gifted exchanges, information administration may comprise of a coincidental employment duty, for example, time revealing or recording a deal. In any case, basically everybody is influenced somehow by the need to oversee information. 

A social database application, for example, Microsoft® Office Access® 2013 can enable you and your association to gather and oversee a lot of information. Get to is an adaptable device. You can utilize it as an individual information administration apparatus (for your utilization alone), or you can utilize it as a development set to create applications for a whole division or association. In this course, you will figure out how to utilize Access 2013 to deal with your information, including making another database; developing tables; outlining structures and reports; and making inquiries to join, channel, and sort information. 

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

91004: Microsoft Office Access 2013: Part 1 Audience Profile 

91004: Microsoft Office Access 2013: Part 1 course is intended for understudies who wish to build up a foundational comprehension of Microsoft Office Access 2013, including the aptitudes important to make another database, develop information tables, plan structures and reports, and make inquiries.

91004: Microsoft Office Access 2013: Part 1 Course Outline

91004: Microsoft Office Access 2013: Part 1 course is intended for understudies who wish to set up a foundational comprehension of Microsoft Office Access 2013, including the aptitudes important to make another database, develop information tables, plan structures and reports, and make questions. 

Subjects 

Lesson 1: Getting Started with Access 

Subject An: Orientation to Microsoft Access Page 1 

Subject B: Create a Simple Access Database 

Subject C: Get Help in Microsoft Access 

Lesson 2: Working with Table Data 

Subject A: Modify Table Data 

Subject B: Sort and Filter Records 

Subject C: Create Lookups 

Lesson 3: Querying a Database 

Subject A: Join Data from Different Tables in a Query 

Subject B: Sort and Filter Data in a Query 

Subject C: Perform Calculations in a Query 

Lesson 4: Creating Advanced Queries 

Subject A: Create Parameter Queries 

Subject B: Create Action Queries 

Subject C: Create Unmatched and Duplicate Queries 

Subject D: Summarize Data 

Lesson 5: Generating Reports 

Subject A: Create a Report 

Subject B: Add Controls to a Report 

Subject C: Enhance the Appearance of a Report 

Subject D: Prepare a Report for Print 

Lesson 6: Customizing the Access Environment 

Subject A: The Access Options Dialog Box 

Addendum A: Microsoft Office Access 2013 Exam 77-424 

Addendum B: Microsoft Access 2013 Common Keyboard Shortcuts

Awards