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.
Syllabus:
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
Course Duration: 12 hours
Course Delivery: Online
