Online MS Access Training

Sold By:GNT Nigeria

Highlights

Online MS Access Training

COURSE OUTLINE (BRIEF):

  • Create a new database
    • Create new databases, create databases using templates, create databases in older formats, create databases using wizards
  • Manage relationships and keys
    • Edit references between tables, create and modify relationships, set primary key fields, enforce referential integrity, set foreign keys, view relationships
  • Navigate through a database
    • Navigate to specific records, set a form as the startup option, use navigation forms, set navigation options, change views
  • 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
  • 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

Preparation resources

  • Create your first Access 2013 database
  • Video: Creating relationships between your tables
  • How to: Compact and repair a database

Build tables (25–30%)

  • Create a table
    • 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
  • Format a table
    • Hide fields in tables, change data formats, add total rows, add table descriptions, rename tables
  • Manage records
    • Update records, add new records, delete records, append records from external data, find and replace data, sort records, filter records, group records
  • 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

Preparation resources

  • Introduction to tables
  • Basic tasks for an Access 2013 desktop database
  • Video: Build the first table and set data types

Create queries (15–20%)

  • Create a query
    • Run queries, create crosstab queries, create parameter queries, create action queries, create multi-table queries, save queries, delete queries
  • Modify a query
    • Rename queries, add new fields, remove fields, hide fields, sort data within queries, format fields within queries
  • Utilize calculated fields and grouping within a query
    • Add calculated fields, add conditional logic, group and summarize data, use comparison operators, use basic operators

Preparation resources

  • Introduction to queries
  • Video: Use parameter queries to filter your results
  • Video: Using date criteria in queries

Create forms (15–20%)

  • Create a form
    • Create new forms, create forms with application parts, save forms, delete forms
  • Set form controls
    • Move form controls, add form controls, modify data sources, remove form controls, set form control properties, manage labels
  • Format a form
    • Modify tab order in forms, format print layouts, sort records, apply themes, change margins, insert backgrounds, auto-order forms, insert headers and footers, insert images, modify existing forms

Preparation resources

  • Create an Access form
  • Basic tasks for an Access 2013 desktop database
  • Set form, report, and control properties

Create reports (15–20%)

  • Create a report
    • Create new reports, create reports with application parts, delete reports
  • Set report controls
    • Group data by fields, sort data, add sub-forms, modify data sources, add report controls, manage labels
  • 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

2 Year complete access

Online Instructor LED Training

Vendor Certificate of Excellence Upon Completion

  • Coupon(s) valid until 2017-05-24 (unused Coupons after this date will not be honoured/refunded by Merchant/DealDey)
    • Multiple Coupons may be purchased
    • Coupons numbers or QR codes must be presented for redemption
    • Download Coupon for Merchant’s details 
    • Reservation must be made before redemption
    • Please call 01-4609950 | 08094609951 for more payment enquiries 
  • Terms and conditions apply
  • Details

    This Instructor-Led Complete Training is suitable for both inexperienced users that need to learn functionsfrom scratch, and for experts, who need to refresh their knowledge. This makes the training the ideal tool forlearning the entire Microsoft Access 2016 Application.

    GNT Nigeria The G-Hub, 28 Moremi Street, Off Aare Avenue, New Bodija, Ibadan, Ibadan, Oyo, Nigeria
    View website
    DealDey Helpline

    01-4609950, 08094609951

    Reviews

    There are no reviews yet.

    Be the first to review “Online MS Access Training”

    Sold By:GNT Nigeria

    Highlights

    Online MS Access Training

    COURSE OUTLINE (BRIEF):

    • Create a new database
      • Create new databases, create databases using templates, create databases in older formats, create databases using wizards
    • Manage relationships and keys
      • Edit references between tables, create and modify relationships, set primary key fields, enforce referential integrity, set foreign keys, view relationships
    • Navigate through a database
      • Navigate to specific records, set a form as the startup option, use navigation forms, set navigation options, change views
    • 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
    • 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

    Preparation resources

    • Create your first Access 2013 database
    • Video: Creating relationships between your tables
    • How to: Compact and repair a database

    Build tables (25–30%)

    • Create a table
      • 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
    • Format a table
      • Hide fields in tables, change data formats, add total rows, add table descriptions, rename tables
    • Manage records
      • Update records, add new records, delete records, append records from external data, find and replace data, sort records, filter records, group records
    • 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

    Preparation resources

    • Introduction to tables
    • Basic tasks for an Access 2013 desktop database
    • Video: Build the first table and set data types

    Create queries (15–20%)

    • Create a query
      • Run queries, create crosstab queries, create parameter queries, create action queries, create multi-table queries, save queries, delete queries
    • Modify a query
      • Rename queries, add new fields, remove fields, hide fields, sort data within queries, format fields within queries
    • Utilize calculated fields and grouping within a query
      • Add calculated fields, add conditional logic, group and summarize data, use comparison operators, use basic operators

    Preparation resources

    • Introduction to queries
    • Video: Use parameter queries to filter your results
    • Video: Using date criteria in queries

    Create forms (15–20%)

    • Create a form
      • Create new forms, create forms with application parts, save forms, delete forms
    • Set form controls
      • Move form controls, add form controls, modify data sources, remove form controls, set form control properties, manage labels
    • Format a form
      • Modify tab order in forms, format print layouts, sort records, apply themes, change margins, insert backgrounds, auto-order forms, insert headers and footers, insert images, modify existing forms

    Preparation resources

    • Create an Access form
    • Basic tasks for an Access 2013 desktop database
    • Set form, report, and control properties

    Create reports (15–20%)

    • Create a report
      • Create new reports, create reports with application parts, delete reports
    • Set report controls
      • Group data by fields, sort data, add sub-forms, modify data sources, add report controls, manage labels
    • 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

    2 Year complete access

    Online Instructor LED Training

    Vendor Certificate of Excellence Upon Completion

  • Coupon(s) valid until 2017-05-24 (unused Coupons after this date will not be honoured/refunded by Merchant/DealDey)
    • Multiple Coupons may be purchased
    • Coupons numbers or QR codes must be presented for redemption
    • Download Coupon for Merchant’s details 
    • Reservation must be made before redemption
    • Please call 01-4609950 | 08094609951 for more payment enquiries 
  • Terms and conditions apply
  • Details

    This Instructor-Led Complete Training is suitable for both inexperienced users that need to learn functionsfrom scratch, and for experts, who need to refresh their knowledge. This makes the training the ideal tool forlearning the entire Microsoft Access 2016 Application.

    GNT Nigeria The G-Hub, 28 Moremi Street, Off Aare Avenue, New Bodija, Ibadan, Ibadan, Oyo, Nigeria
    View website
    DealDey Helpline

    01-4609950, 08094609951

    Reviews

    There are no reviews yet.

    Be the first to review “Online MS Access Training”