MS Access 2013 Online Course

MS Access 2013 Online Courses in Botswana


This 2KO Botswana Access 2013 course provides students with the knowledge and skills that are needed to use the Microsoft Access 2013. 2KO Africa is a professional training company, delivering cutting edge programs in the IT space and in selected business applications. Our training is offered online, live online and also by instructor led classes. 2KO Africa's business courses are available world-wide, many of them leading to European Certification.


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.


Register for an Online MS Office Course Here



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