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 Visual Basic for Access 2010

    Microsoft Visual Basic for Access 2010

    SGD $40.00

    Course Description

    Microsoft Access allows a user to create many different items: tables, forms, reports, macros, and queries. However, the greatest power lies in Modules. Modules contain Visual Basic for Applications (VBA) code that runs in the background, performing more complex operations than any of the other items can perform. This VTC course will discuss how to do many different processes in VBA Modules, including creating customized data items and classes, as well as referencing data that exists in a separate database. 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 

    Read more...

  • Essential Online Course - Microsoft Outlook 2016

    Essential Online Course - Microsoft Outlook 2016

    SGD $299.00

    Course Description

    Microsoft Outlook is by far one of the most popular email applications used by millions of professionals and students all over the world. Microsoft Outlook 2016 provides better organization, search capabilities, communication and social networking features. With this Microsoft Outlook 2016 training course, you will learn the four major components of outlook including contacts, email, calendars and tasks. This course will also touch on the OneNote application that provides a cross platform and cross application note taking tool. This course covers all the bases including Basic Outlook 2016, Intermediate Outlook 2016 and Advanced Outlook 2016. 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

    Read more...

  • Introduction to Cloud Computing

    Introduction to Cloud Computing

    SGD $45.00

    Course Description

    Technology is evolving and changing to embrace the cloud. Cloud computing allows you to utilize shared resources available through a service provider. Those resources can be storage space, use of software applications, or servers. You can buy more resources in the cloud if you need to and you can also give back resources that you no longer need. In this hands-on VTC course, you will access a variety of cloud services and work with different cloud providers such as Apple, Microsoft, Google, and Amazon. You will set up virtual servers, work with cloud file storage, learn about a variety of cloud collaboration options, and much more. This practical course will help you make the transition to working in the cloud from any device, anywhere, anytime! Cloud computing offers you unrestricted access to your resources. - Learn about the advantages of using cloud services- Learn about the various cloud services offered today- Know how to make full use of the cloud services for your resources - Understand how you can setup a cloud service for your own use This course is SkillsFuture Credit Eligible.

    Read more...


Content

Introduction

Preview Available

+

Welcome

Course Objectives

Course Structure

What is Access?

New in 2010

Database Basics

Preview Available

+

What is a Database?

Database Types

Database Objects

Tables

Data Types

Primary Key

Indexes

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

Relationships

+

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

Conclusion

+

Course Wrap Up

Resource Files

Credits

+

About the Author

SGD $49.00
(Price excludes GST)
GET ACCESS NOW
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.