Understand your Database with Microsoft Access 2010

  • Understand your Database with Microsoft Access 2010, Singapore elarning online course
  • Understand your Database with Microsoft Access 2010, Singapore elarning online course
  • Understand your Database with Microsoft Access 2010, Singapore elarning online course
  • Understand your Database with Microsoft Access 2010, Singapore elarning online course
  • Understand your Database with Microsoft Access 2010, Singapore elarning online course
  • Understand your Database with Microsoft Access 2010, Singapore elarning online course

Course Description

As part of the release of the Office 2010 software suite, Microsoft is introducing the latest version of Access, their entry-level database application software. Don't let the words 'entry-level' fool you, this is one very powerful database tool. Access was designed to collect, store, manage, report, and dissect data for individuals and small businesses. The release of the 2010 version continues to raise the bar of what an entry-level database product can do. In this course, Mark Long takes you from opening Access 2010 for the first time through the entire process of creating a database. He covers tables, queries, forms, reports, and many of the other bells and whistles that make up Access 2010.

Realise the full potential of your data with Microsoft Access.

- Learn about the functions in Microsoft Access that can help your understand data better
- Know the different ways of vizualising your data with Microsoft Access
- Pick up the knowledge of utilizing Access for better understanding your data
- Learn how you can stretch your data for optimum analysis

Course Objectives

1. Understand the concept of database in Microsoft Access
2. Understand the basics of Microsoft Access
3. Know the different analytics functions in Microsoft Access
4. Able to prep data and how to input for analysis 
5. Know how to visualise charts, graphs and lines using results


Related Courses

  • Microsoft Office for Mac 2011

    Microsoft Office for Mac 2011

    SGD $45.00

    Course Description

    Office for Mac 2011 is a powerful update of the widely used productivity suite. Mac users now have access to a slew of updated features which are designed to simplify workflow while still maintaining the incredible strength of inter-application collaboration. This VTC course explores the 2011 update through a detail driven approach and with the help of practical examples. All of the major applications in Office are covered, along with several of the lesser profile utilities. Office may be constantly changing, but that doesn't mean you need to be left behind! Jump on board with Sam McGuire and get the very most out of the tools you use on a daily basis. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course This course is SkillsFuture Credit Eligible.


  • Creating Dynamic Presentations

    Creating Dynamic Presentations

    SGD $40.00

    Course Description

    Creating meaningful presentations is easier than ever using powerful tools that incorporate mobile technology, touch interfaces, and interactive media. This course explores the most common presentation software available and showcases workflows that are useful in creating dynamic presentations. University professor Sam McGuire helps viewers explore ways to get past the tools and focus on the storytelling involved with your presentations.Wow your audience with your next presentation!- Know how to make use of the resources that you have - Learn how to use different types of media in your presentation- Learn how to present an effective presentation - Learn various presentation tips at the end of this course


  • Learn about Digital Audio with Steinberg Nuendo 5

    Learn about Digital Audio with Steinberg Nuendo 5

    SGD $49.00

    Course Description

    Steinberg's Nuendo 5 is the latest update to the popular professional digital audio post-production software. In this VTC course, author Mark Struthers will demonstrate the program's system requirements before looking at how to make initial input and output connections that allow Nuendo to communicate with microphones, synths, and soundcard hardware. He intentionally declutters Nuendo's project window so that you can focus on the track in hand instead of getting distracted by large complex projects. As the course progresses, Mark will guide you through specific tasks and functions, such as creating projects, archiving, audio editing, using markers and much more, so that techniques and tips can be absorbed quickly. Be able to produce music recording, arranging and editing with Steinberg. - Learn how to work with audio files using Steinberg- Know how Steinberg works as an audio editing software- Enable yourself to be able to produce your own music with Steinberg - Learn about the different techniques used in Steinberg to achieve quality audioThis course is SkillsFuture Credit Eligible.




Preview Available



Course Objectives

Course Structure

What is Access?

New in 2010

Database Basics

Preview Available


What is a Database?

Database Types

Database Objects


Data Types

Primary Key


Database Design Basics


What is Normalization?

Normalization Benefits

Understanding Relationships

Relationship Types pt. 1

Relationship Types pt. 2

Relationship Types pt. 3

Understanding Integrity

Access 2010 Basics


What Can I Do with Access?

Access Database Objects

Opening Access 2010

Creating a Database

Getting Around in Access

Where to Really Start

Working with Tables


Creating Our Database

Quick Access Toolbar Shortcut

Datasheet or Design?

Access Data Types

Field Size Settings

Date/Time Formats

Custom Date/Time Formats

Creating Our Tables

Required Fields

Deleting Rows

Input Masks

Setting the Field Size

Default Values

Allow Zero Length

Renaming Fields & Tables

Editing a Table

Data Validation

Adding an Index

Deleting a Table

Using Caption

Using the Data Documenter



Determining Relationships

Creating a Relationship

Relationship Options

Relationship Reports

Working with Datasheet View


Using Auto Numbering

Adding Data to the Table

Using Data Lookups

Datasheet View Basics

Replacing Values

Datasheet Formatting

Filter By Form

Freezing & Thawing

Accessing Your Data


Query Basics

Access & SQL

Access 2010 Query Types

Using the Query Wizard

Using the Query Design View

Writing Queries in SQL

Total Queries

Make Table Queries

Action Queries

Crosstab Queries

Union Queries

Top Queries

Multi-Table Queries

Understanding Query Joins

Distinct Queries

Data Forms


Why Use Forms?

Using AutoForm

Using the Form Wizard

Starting from Scratch

Layout or Design View?

Form Controls

Adding Controls

Using the Control Wizard

Control Properties

Using Combo Boxes pt. 1

Using Combo Boxes pt. 2

Navigation Form

Setting the Tab Order

Creating a Pop-up Form pt. 1

Creating a Pop-up Form pt. 2

Access 2010 Forms

Access 2010 Reports


Report Basics

Report Types

Reports the Easy Way

Reports the Wizard Way

Reports the Real Way

Finding the Data

Basic Report Design

Sorting & Grouping Data

Report Headers

Group & Sum Totals

Using Expressions

Report Cosmetics pt. 1

Report Cosmetics pt. 2

Report Cosmetics pt. 3

External Data


You Need It Where?

Exporting Data

Importing Data

Linking to Data

Linking Issues

Multi-user Access Applications


Multi-User Application Basics

Network Performance Issues

Splitting the Database

Pass-Through Queries

Database Locking

More Cool Access Stuff


Copying Tables

Access Analyzer Tools

Database Backups

Pivot Tables & Charts

Intro to Macros & Events

Intro to VBA



Course Wrap Up

Resource Files



About the Author

SGD $49.00
(Price excludes GST)
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.