Microsoft Access 2013 – Basic and Intermediate

Course Code: ASKAB3

Course Objective – Microsoft Access 2013 – Basic and Intermediate

During the course, Microsoft Access 2013 – Basic and Intermediate, participants will develop essential knowledge and skills in using Access 2013. It helps participants in creating and modifying database objects such as tables, forms, reports and queries, and subsequently apply intermediate skills to manage data entry, ensure data integrity, automate tasks and analyze data.

Desire to study more in depth on Access 2013, don’t miss Microsoft Access 2013 – Advanced

  • Course Dates and Venue

    Course Duration: 2 day (16 hours), 9:00a.m. – 5:00p.m.

    CourseVenueJun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17
    Microsoft Access 2013 - Basic and IntermediateJTC Summit-24-25-14-15-16-17-
    Mountbatten Square08-09-10-11-12-13-07-08

    September 2015

    SMTWTFS
    30
    31
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    1
    2
    3
  • Database Basics

    • Introduction to Databases
    • What’s New in Access 2013
    • Understanding the Access Program Screen
    • Working with Database Objects
    • Tour of a Table, Form, Query & Report
    • Adding, Editing and Deleting Records
    • Selecting Data & Using the Zoom Box

    Creating and Working with a Database

    • Planning a Database
    • Creating a New Database
    • Converting an Access Database

    Working with Tables and Fields

    • Modifying a Table
    • Understanding Field Properties
    • Indexing a Field
    • Adding a Primary Key to a Table
    • Inserting, Deleting, and Reordering Fields
    • Adding Field Descriptions and Captions
    • Changing the Field Size
    • Formatting Number, Currency & Date/Time Fields by Hand
    • Formatting Text Fields
    • Using Hyperlink Fields
    • Setting a Default Value
    • Requiring Data Entry
    • Validating Data
    • Creating an Input Mask
    • Creating a Lookup Field
    • Creating a Value List
    • Modifying a Lookup List

    Finding, Filtering, and Formatting Data

    • Finding and Replacing Data
    • Sorting Records
    • Using Common Filters
    • Filtering by Selection & by Form
    • Creating an Advanced Filter
    • Adjusting and Rearranging Rows and Columns
    • Changing Gridline and Cell Effects
    • Changing the Datasheet Font
    • Freezing & Hiding a Column

    Creating Relational Databases

    • Understanding Table Relationships
    • Creating Relationships Between Tables
    • Enforcing Referential Integrity
    • Printing and Deleting Relationships
    • Understanding Relationship Types

    Working with Queries

    • Creating & Sorting a Query
    • Using AND and OR Operators in a Query
    • Understanding Different Types of Queries
    • Creating a Multiple Table Query
    • Creating a Calculated Field
    • Summarizing Groups of Records
    • Display Top or Bottom Values

    Working with Forms

    • Creating a Form with the Form Wizard
    • Creating and Using a Form
    • Understanding Form Views
    • Modifying a Form in Layout View
    • Form Design View Basics
    • Creating a Subform
    • Modifying and Working with Subforms

    Working with Reports

    • Creating a Report with the Report Wizard
    • Creating a Report
    • Working in Layout View
    • Adding a Logo
    • Working in Design View
    • Adjusting Page Margins and Orientation
    • Adding Page Numbers and Dates
    • Creating Mailing Labels with the Label Wizard

    Formatting Forms and Reports

    • Formatting Fonts
    • Changing Text Alignment
    • Changing Colors
    • Using Conditional Formatting
    • Adding Pictures, Lines and Gridlines
    • Working with Number Formatting
    • Using Themes

  • For those with little or zero knowledge of using Microsoft Access

Fees and Grants

$406.60 per participant (Inc. GST)

Tap on PIC Scheme or Cash Payout and PIC Bonus for Training of Employees. For more details, refer to IRAS Website.

SDF subsidy: $2 per training hour. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

Applicants may use SkillsFuture Credit for this course

Absentees will be charged the full course fee.

Registration

Click here to download registration form.

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Apply Online

Microsoft Access 2013 – Basic and Intermediate (ASKAB3)


All registration should be submitted at least 1 week before course commencement. Please call us directly to check on the class status.

A. Company Particulars

Company Name

Company Address

Postal Code

B. Training Coordinator / Contact Person

TC / Contact Person Name*

TC / Contact Person Email*

Contact Number*

Fax Number

C. Billing Information


Billing Contact Person Name*

Billing Contact Person Email*

Billing Contact Number*

Billing Fax Number

Business Unit (BU / SBU)

For Businesses or Government Agencies using the e-invoice system only.

Are you applying for SDF Grant?

Applicable to some select IT and Softskills Courses.


D. Participants

Participant 1*

Course Start Date*

Course End Date*

Participant 2

Course Start Date*

Course End Date*

Participant 3

Course Start Date*

Course End Date*

Have more than 3 participants?

Attach their particulars here (PDF, Word .doc, Excel .xls)

I have Read and Agree to the Terms and Conditions


We do not sell or share your information with anyone else.