Maximize your Database with Microsoft Access 2013


  • Maximize your Database with Microsoft Access 2013, Singapore SKillsFuture elarning online course
  • Maximize your Database with Microsoft Access 2013, Singapore SKillsFuture elarning online course
  • Maximize your Database with Microsoft Access 2013, Singapore SKillsFuture elarning online course
  • Maximize your Database with Microsoft Access 2013, Singapore SKillsFuture elarning online course
  • Maximize your Database with Microsoft Access 2013, Singapore SKillsFuture elarning online course
  • Maximize your Database with Microsoft Access 2013, Singapore SKillsFuture elarning online course

Course Description

Microsoft Access 2013 is the latest version of the number one database application in the world, and this is a big release. Access 2013 brings quite a few changes, all designed to make database applications easier to design and implement. The ability to quickly create Web Applications that run in the user's browser, regardless of which device they use, is one of the major changes in the latest release. In this VTC course, author Mark Long takes you step by step through Access 2013 to quickly get you up to speed on these changes. Access is everywhere, from small one-person businesses up to the largest corporations in the world. It's where most data first gets stored before progressing to SQL Server, cloud delivery, and enterprise data services. Understanding Access is vital to real world database creation/maintenance/design and this course will show you what you need to get there.

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

  • FileMaker Pro 12: Advanced

    FileMaker Pro 12: Advanced

    SGD $63.00

    Course Description

    FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical ’how to’ course by FileMaker expert John Mark Osborne starts from advanced level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 features and techniques including: Ultimate Find, saving a found set of records for future retrieval, saving find criteria for future use, text parsing to create features, making new requests easier for users, parsing web form generated emails, five methods for deleting duplicates, recursive phone filter, creating preferences in a single-user and multi-user scenario, web-like back and forward buttons, conditional buttons, custom form letters, changing text attributes with scripts, script triggers and many more techniques with an emphasis on adaptive scripting and calculations. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning. Discover how data can be managed efficiently. - Find out how you can manage your database- Learn ways to fully utilize your data's potential - Know how queries can be implemented to run the data better - Understand an effective solution to optimize your database's productivity This course is SkillsFuture Credit Eligible.

    Read more...

  • Avid Pro Tools 10: Know how to work with audio

    Avid Pro Tools 10: Know how to work with audio

    SGD $49.00

    Course Description

    VTC's Avid Pro Tools 10 course introduces the new features in this latest release of the audio recording and music production powerhouse. From clip gain and disk caching to new plug-ins and workflows, this version of ProTools is both powerful and exciting. Sam McGuire covers these new features and also explores many of the traditional features using real world examples and practical demonstrations. Whether you are a novice or a seasoned professional, you will find this course both insightful and entertaining.Learn how to work with audio files using Avid Pro Tools. - Know how Avid Pro Tools handles audio - Learn how to edit your own audio files with Avid Pro Tools- Discover the potential of Avid Pro Tools with your audio files- Master audio editing with all the right tools and techniques in Avid Pro ToolsThis course is SkillsFuture Credit Eligible.

    Read more...

  • Discover More of Your Data with Microsoft Excel

    Discover More of Your Data with Microsoft Excel

    SGD $40.00

    Course Description

    Microsoft Excel is one of the most popular programs to use for analyzing, extracting, and cleaning the tremendous amounts of data that we have collected. Learn how Microsoft Excel can manage and summarize your data with PowerPivot and Pivot Tables, automation and coding, along with the standard features of Arrays, functions such as MATCH and INDEX, and the Data Analysis Tools. Understand speed and file size limitations while appreciating the art of data cleaning and manipulation. Explore how the What If Analysis tools can help with plans and forecasts and consolidate and link data for interactive reports. This course will allow you to unleash the power of Excel to make accurate decisions based on your data and Excel's power.Realise the full potential of your data with Microsoft Excel. - Learn about the functions in Excel that can help your understand data better - Know the different ways of vizualising your data with Excel- Pick up the knowledge of utilizing Excel for better understanding your data- Learn how you can stretch your data for optimum analysis This course is SkillsFuture Credit Eligible.

    Read more...


Content

Welcome

Preview Available

+

Introduction

Course Overview

What Access Is

New in 2013

Access Grows Up

The Future of Access

Access Alternatives

Database 101

Preview Available

+

What a Database Is

Database Types

Database Organization

Understanding Tables

Understanding Data Types pt. 1

Understanding Data Types pt. 2

Primary Key Basics

Understanding Indexes pt. 1

Understanding Indexes pt. 2

Database Design 101

+

Database Design Options

Understanding Normalization

Understanding Relationships

Relationship Types pt. 1

Relationship Types pt. 2

Understanding Integrity

Getting Started with Access 2013

+

Where to Start

Introducing Office 365

Access Database Objects

Installing Access 2013 pt. 1

Installing Access 2013 pt. 2

Creating a Database

Access Interface Tour

Database Backups

Working with Tables

Preview Available

+

Creating Our Database

Datasheet or Design

Creating Tables pt. 1

Creating Tables pt. 2

Data Types pt. 1

Data Types pt. 2

Editing Table Structures

Date/Time Formats pt. 1

Date/Time Formats pt. 2

Using Input Masks

Deleting Rows

Required Fields

Adding a Primary Key

Creating an Index

Deleting a Table

Access Relationships

+

Identifying Relationships

Design Meets Relationships

Creating a Relationship pt. 1

Creating a Relationship pt. 2

Creating a Relationship pt. 3

Managing Relationships

Viewing Object Dependencies

Data Retrieval

+

Understanding Queries

Access and SQL

Query Types

Creating Queries pt. 1

Creating Queries pt. 2

Make Table Queries

Understanding Join Queries

Union Queries

Top Queries

Distinct Queries

Query Filters

Append Queries

Delete Queries

Data Management Options

Data Forms and Reports

+

Understanding Forms

Why Use Forms

Using AutoForm

Using the Form Wizard

Forms from Scratch

Design or Layout

Working with Controls

Setting the Tab Order

Using External Data

+

Data Here and There

Exporting Data

Importing Data

Data Linking

Data Linking Example

Access Gets Friendly

+

What SharePoint Is

A Budding Relationship

Goodbye ADP

Access and the Web

+

Understanding Web Apps

SharePoint Foundation 2013

SharePoint System Requirements

Getting Setup for Web Apps

Creating a Web App

Conclusion

+

Course Wrap Up

Resource Files

Credits

+

About the Author

SkillsFuture Credit Eligible
SGD $40.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.