Microsoft Access 2013 Intermediate Training

Microsoft Access 2010/2013 Intermediate Training Course Microsoft® Access 2010/2013 Training
By ComSystem Solutions
Microsoft Office Family:

Microsoft® Access 2010/2013 Intermediate

“Experience the power of Microsoft Access 2013!”

By ComSystem Solutions


PSMB Certified Training Provider • Comptia Authorized Delivery Partner • Pearson Vue Certified Test Centre • Registered with Ministry of Finance
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Email Customer Service [email protected]
[email protected]
Contact Customer Service +603-5162-8254 , +603-2201-4622
Course Title:
Microsoft® Access 2010/2013 Intermediate
Training Category:
Information Technology
Target Audience:
This 2-day Microsoft Access course is ideal for people who wants to learn the time saving techniques and features when working with Microsoft Access 2013 or those who wish to extend their knowledge.
Duration:
2 Days
Public Training Events
Aug 2017 ›
Venue:
ComSystem Solutions Training Centre, Wisma Goshen, Plaza Pantai, Kuala Lumpur, Malaysia
Schedule:
Thu 10 Aug 2017 - Fri 11 Aug 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,075.00
Promotions:
  • Register before 01 Aug 2017 for only RM875 per person.
  • For 3 paxs registration, the 3rd person will receive a complimentary seat.
  • For 2 paxs registration, the 2nd person will be entitled to 20% discount.
Register Now!

* Other terms & conditions apply.
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact ComSystem Solutions
Contact customer service +603-5162-8254
+603-2201-4622
Email customer service [email protected]
[email protected]
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Workshop
  • Computer Lab Work
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

This Microsoft Access 2013 Intermediate training course is aimed at those who have a good understanding of Access 2013 at an introductory level. This course allows the delegate to experience the power of Access 2013 and provide knowledge and techniques necessary for the successful creation and manipulation of databases and reports.

Course Objectives ›

Upon completion of this Microsoft Access training, participants should be able to:

  • Retrieve Data from Access 2013 Database
  • Work with Forms to allow for add / edit / deletion of data from Access databases
  • Design Reports for Easier analysis in Microsoft Access 2013.
  • Design a simple database from scratch
  • Create and understand table relationships
  • Create filters and queries
  • Use expressions in the Query Designer

Course Outline ›

DAY 1

Using App Views

  • Understanding Views
  • Adding a New View
  • Editing a View
  • Deleting a View
  • Adding a Popup View

Customizing Apps (I)

  • Checking Your Database Name or Server Location
  • Modifying the Action Bar
  • Opening a Table for Editing
  • Moving, Resizing, or Deleting Controls

Customizing Apps (II)

  • Adding Controls from the Ribbon
  • Adding Controls from the Field List
  • Changing Control Properties

Advanced Record Tasks

  • Showing Totals
  • Adding from Outlook
  • Saving a Record as an Outlook Contact
  • Adjust Row Height
  • Hiding and Un-hiding Fields
  • Freezing and Unfreezing Fields
  • Formatting Text

Adding Other Types of Fields

  • Adding Rich Text and Long Text Fields
  • Adding Attachment Fields
  • Adding Hyperlink Fields
  • Adding Lookup & Relationship Fields
  • Adding Calculated Fields
DAY 2

Advanced Field Tasks

  • Adjusting the Field Size/Width
  • Setting Field Default Value
  • Working with More Fields
  • Working with Field Validation Options
  • Using the Field List

Working in Table Design View

  • Opening Design View
  • Working with Field Properties
  • Setting the Primary Key
  • Using the Properties Sheet
  • Working with Table Properties
  • Viewing Table Relationships
  • Using Relationship Tools
  • Viewing Object Dependencies

Working with External Data

  • Linking Data
  • Importing Data
  • Using the Table Analyzer
  • Refreshing Data
  • Exporting Data

Creating Queries

  • Creating a Select Query
  • Creating a Make Table Query
  • Creating an Append Query
  • Creating a Cross tab Query
  • Showing and Removing Tables

Creating Forms and Reports

  • Creating a Form with the Form Wizard
  • Creating a Report with the Report Wizard
  • Modifying Form Layout
  • Navigating the Field List
  • Key Features on the Form Tools Tabs
  • Key Features on the Report Tools Tabs

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-5162-8254, +603-2201-4622
Email Customer Service E-mail : [email protected], [email protected]

Related Courses ›

More Other Training Courses ›

Published by: ,