Microsoft Office Specialist (MOS) 77-424: Access 2013
Details
Access 2013 is the newest version of Microsoft’s dynamic database management system and it offers features that allow you to create and modify a variety of database types through a convenient graphic user interface. Access, as a desktop application, helps
you store and manage related information in one place. It helps prevent errors, inconsistencies, and duplicate information.
Our MOS Access 2013 training course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software. When you pass the Access 2013 Exam 77-424, you achieve Microsoft Certified Application Specialist (MOS) status in Access 2013.
Course Delivery
Outline
Access 2013 – Introduction
- Section 1-1 – Creating Databases
- Creating New Databases
- Create Databases Using Templates
- Create Databases In Older Formats
Section 1-2 – Creating Tables
- Create New Tables
- Import External Data Into Tables
- Create Linked Tables From External Sources
- Import Tables From Other Database
- Create Tables From Templates And Application Parts
Section 1-3 – Format A Table
- Hide Fields In Tables
- Change Data Formats
- Add Total Rows
- Add Table Descriptions
- Rename Tables
Section 1-4 – Manage Records
- Update Records
- Add New Records
- Delete Records
- Append Records From External Data
- Find And Replace Data
- Sort Records
- Filter Records
Section 1-5 – Create And Modify Fields
- Add Fields To Tables
- Add A Validation Rules To Fields
- Change Field Captions
- Change Field Sizes
- Change Field Data Types
- Configure Fields To Auto-Increment
- Set Default Values
- Use Input Masks
- Delete Fields
Section 2-1 – Create A Query
- Run Queries
- Create Crosstab Queries
- Create Parameter Queries
- Create Action Queries
- Create Multi Table Queries
- Save Queries And Delete Queries
Section 2-2 – Modify A Query
- Rename Queries
- Add New Fields
- Remove Fields
- Hide Fields
- Sort Data Within Queries
- Format Fields Within Queries
Section 2-3 – Utilize Calculated Fields And Grouping Within A Query
- Add Calculated Fields
- Add Conditional Logic
- Group And Summarize Data
- Use Comparison Operators
- Use Basic Operators
Section 3-1 – Create A Form
- Create New Forms
- Create Forms With Application Parts
- Save And Delete Forms
Section 3-2 – Set Form Controls
- Move Form Controls
- Add Form Controls
- Modify Data Sources
- Remove Form Controls
- Set Form Control Properties
- Manage Labels
Section 3-3 – Format A Form
- Modify Tab Order In Forms And Auto-Order Forms
- Format Print Layouts
- Sort Records
- Apply Themes
- Change Margins
- Insert Backgrounds
- Insert Headers And Footers
- Insert Images
- Modify Existing Forms
Section 4-1 – Create A Report
- Create New Reports
- Create Reports With Application Parts
- Delete Reports
Section 4-2 – Set Report Controls
- Group Data By Fields
- Sort Data
- Add Sub-Forms
- Modify Data Sources
- Add Report Controls
- Manage Labels
Section 4-3 – Format A Report
- Format Reports Into Multiple Columns
- Add Calculated Fields
- Set Margins
- Add Backgrounds
- Change Report Orientation
- Change Sort Order
- Insert Headers And Footers
- Insert Images & Insert Page Numbers
- Apply Themes
- Modify Existing Reports
Section 5-1 – Manage Relationships And Keys
- Create And Modify Relationships & View Relationships
- Set Primary Key Fields
- Set Foreign Keys
- Enforce Referential Integrity
Section 5-2 – Navigate Through A Database
- Navigate To Specific Records
- Set A Form As The Startup Option
- Use Navigation Forms
- Set Navigation Options
- Change Views
Section 5-3 – Protect And Maintain A Database
- Compact Databases & Repair Databases
- Back Up Databases
- Split Databases
- Encrypt Databases With A Password
- Merge Databases
- Recover Data From Backups
Section 5-4 – Print And Export A Database
- Print Reports
- Print Records
- Maintain Backward Compatibility
- Save Databases As Templates
- Save Databases To External Locations
- Export To Alternate Formats
- Program Close
Second to this, our online training is simple to use and highly effective. We offer a whole range of features designed to get you certified faster. Some of these incredible features include video and audio based training so you can see and hear your tutor, 24/7 online tutor support, and online labs to practice your skills in a simulated environment.
Come and give us a try. We’ll change the way you think about learning.