MS Access 2013 Online Course

MS Access 2013 Online Courses in South Africa


 

This 2KO Access 2013 course provides students with the knowledge and skills that are needed to use the Microsoft Access 2013. 2KO International Group provides IT & business training courses for learners of all levels, and is also a top-rated, certified supplier of online IT courses from the comfort of home or work.

 

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.

 

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