Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

courses popup callback

E-COURSE:

Microsoft Office 2013 - Access

Instructor-led video course with presentations, workbooks, games, flashcards and quizzes.
Overview
This course Microsoft Office Access 2013 prepare students for their certification exam 77-424, Microsoft Access 2013 guides about the scenarios for creating databases. You will learn to create a very simple, standardized database from a template and then create a customized database. At the completion of this course, you will understand tables, relationships, queries, forms, and reports.
Objectives
  • Create a new database
  • Create and format table
  • Modifying fields
  • Modifying fields
  • Building forms
  • Using calculated fields and groups in a query
  • Protecting a database
  • Create and modify the query
  • Creating different types of queries
  • Create, set report controls and format report
Target Audience
  • Refresh your concepts on tables, forms, queries, and reports
  • IT Professionals
  • If you wish to obtain the Microsoft Office Specialist Certification (MOS), you should take this course
  • If you need to gain additional skills in Access 2013, this course is for you
  • This course is not for individuals who have not worked within the Access 2013 environment.

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
E-COURSE Expert-led video course with presentations, workbooks, quizzes, games and flashcards.
  • 07:38:52+ Hours Of learning
  • Includes video, presentations, workbooks, quizzes, flashcards & games
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months access
  • 10-Day money-back guarantee
Back to Top