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

  • FL Studio 10: Know how to work with audio

    FL Studio 10: Know how to work with audio

    SGD $54.00

    Course Description

    Version 10 is the game changer that FL Studio users have been waiting for. This new version builds on the long tradition of FL Studio excellence while bringing meaningful new tools to the platform. In this VTC course, author Sam McGuire helps FL Studio users navigate the FL Studio application, focusing on real-world workflow and example projects. In addition to discussing the basic FL Studio interface and functionality, Sam will delve into the exciting new Pitcher and Newtone plugins. Building on the FL Studio 9 course, this new material is designed to sharpen your skills and provide the means to be a master user of the software. Sharpen your skills in digital audio with FL Studio. - Know about FL Studio and what it does - Understand how you can use FL Studio to edit your audio files- Learn about the different connections in audio systems- Learn how to use different sound mixers using FL StudioThis course is SkillsFuture Credit Eligible.

    Read more...

  • Getting Started with Office 365 for Business

    Getting Started with Office 365 for Business

    SGD $45.00

    Course Description

    Office 365 for business provides a cloud-based service that gives users access to email, calendars, files and programs on a variety of platforms. In this course students will learn how to manage an Office 365 organization. Students will work with basic online applications such as Word, Excel, PowerPoint and OneNote and learn how to collaborate with others on files created in those programs. Students will learn how to utilize the extensive options within Outlook, OneDrive, Lync and create public sites or team sites. Organization administrators will understand how to work with the many settings and tools in the online Office 365 Admin Center, Exchange Admin Center, Lync Admin Center & SharePoint Admin Center.Get a head start on your tasks with Office 365!- Learn about the different products in Office 365- Know more about each of their purpose and functions- Improve your productivity by adopting Office 365 - Be fluent in Office 365 and accomplish your tasks effectively 

    Read more...

  • Know how to Code with Microsoft C# 2010

    Know how to Code with Microsoft C# 2010

    SGD $49.00

    Course Description

    C# is the Microsoft flagship programming language. It is a simple, powerful, type-safe, and object-oriented language. The many innovations of C# enable rapid application development while retaining the expressiveness and elegance of C-style languages. Since its introduction in the early 2000s as a competitor to Java, C# has steadily developed a very strong identity and is outpacing all competitors as a platform for mission critical applications. In this VTC course, author Mark Long will teach you how to program with C#. He will explain the language's features, quirks, and functionalities in a way that is easy to follow and understand. From simple variable declaration to understanding delegates and events, you'll learn a lot about developing with C#. Pick up a new programming language into the mix of new skills!- Learn a new programming language - Increase your employability with an extra language under your belt - Learn how the different languages work to develop web site and applications - Be able to create cutting edge applications with this course

    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.