MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Microsoft Access 2013

Course Summary

Managing and Analyzing Big Data


  • +

    Course Syllabus

    • Welcome
      • Introduction
      • Course Overview
      • What Access Is
      • New in 2013
      • Access Grows Up
      • The Future of Access
      • Access Alternatives
    • Database 101
      • 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
      • 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
    • Credits
      • About the Author


Course Fee:
USD 89

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top