Virtual Live Training
Class is guaranteed to Run
|START DATE||END DATE||CLASS TIMINGS||MODE||LOCATION||ACTION|
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 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 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.
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