MS Access 2013 Online Course
MS Access 2013 Online Courses in Zimbabwe
This 2KO Zimbabwe Access 2013 course provides students with the knowledge and skills that are needed to use the Microsoft Access 2013. 2KO is an IT consulting and training company, offering both business services and multi-platform training. 2KO Africa's wide range of computer courses are available as full time classes, or as online learning.
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.
The Microsoft Certified Application Specialist Certification, (MOS)
recognizes business professionals who have demonstrated expertise in
Microsoft Office 2013.
Price in US Dollars - as at 21 August | USD 29 |
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