Chicago area career training
Microsoft Office 2013 Access Level 3
This course is the expert level for Access and expands on topics covered in Levels 1 and 2. It introduces complex concepts such as complex forms, calculated controls, complex reports, subreports, database customization, splitting databases, and customizing the user interface.
About This Course
Upon successful completion of this course, students will be able to:
- Use the advanced reports feature on understanding report sections.
- Change the designs of the report to better organize and summarize information and to improve the appearance.
- Change the format of forms and report through special effects.
- Create and revise basic Access macros.
- Generate calculated control within the design of the report.
- Run macros that require automatic data entry in certain fields.
- Create macros using keystroke commands and edit basic macros to perform different types of results.
- Import and export data from other applications as it relates to Access.
- Understand and use hyperlink fields within Access.
WIOA Approved Training Course
Working with Forms
- Form Controls
- Formatting Your Form
- Creating a Form from a Query
- Using Subforms
- Creating a Navigation Form
Using Macros in Access
- Program Control with If-Then-Else Statements
- Using Macros in Tables
- Database Management
- Setting Navigation Options
- Splitting a Database
Exporting, Importing, and Linking Tables
- Exporting Files
- Importing Data
- Linking Data
Exam 77-424: Microsoft Office Access
The Logistics of Your Exam
- The cost of the exam is an additional $96
Locate a Certiport testing center near you
Create a Certiport Account and Schedule Your Exam
Review Certiport and Microsoft Exam Policies prior to taking your exam
|Number of Questions||40-60|
|Types of Questions||Performance-based live in application testing|
|Length of Test||50 minutes|
|Exam Results||Provided immediately after exam|
Exam Pass Guarantee
At Microtrain we are committed to your success!
Let us show you the return you get from great tech training. We will personally guarantee that if you take our class and follow our program you will be successfully certified!