Microsoft Access 2010 Training - Advanced

Upgrading your Microsoft Access skills is a smart move for any professional.

What you'll learn

Execute a set of defined actions and learn to create and modify macros.

Identify best practices for naming objects in an Access 2010 Database.

Learn to collect data from external sources.

Discover the importance of preparing an Access database for distribution and for multi-user access by separating forms.

Distinguish the difference between Word and Excel macros, and the macros and VBA programs that are a part of Access.

Learn best practices for setting-up a new database.

Using VBA for robust error handling and making a handy switchboard.

How to best use the multi-user aspects of Access 2010.

Requirements

Intermediate level Access knowledge

Description

Ideal for those seeking to advance their careers by developing top-notch database skills, the Microsoft Access Training: Learn Microsoft Access 2010 course by Simon Sez IT provides 8 full hours of expert quality training videos. Learn Microsoft Access 2010 - Advanced takes the seemingly overwhelming concept of advanced database management and breaks it into several easy to understand, detailed chapters. A general understanding of previous versions of Microsoft Access will make this Microsoft Access Training: Learn Microsoft Access 2010 course comfortable and will be a great base from which to build. Beyond just getting data into the database, you will be taught to create both form and function. Discover how to create switchboards, autoexec functions, macros, creative reports, custom buttons, deep custom queries for detailed data analysis, and reports that shine—in terms of how they look on paper and the data they provide. Additionally, you will learn best practices to employ during initial design and creation steps. These will help you minimize headaches as the database design evolves, and enable mass distribution as the amount of data and number of users increases. Plus, when you sign up for our class, you’ll also get these 5 BONUSES in addition to the 40 online course videos: Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster. An online quiz (40 questions) - to test what you've learned. Downloadable & printable transcripts (over 160 searchable pages) – to give you another learning option, if you prefer reading but don’t have time to take notes. 8 hours of downloadable MP3s to play on your favorite audio device - to help you learn in the car, while you walk, or in the gym. A certificate of completion to tell everyone you've aced the course. Where else can you find so many extra tools to help you master Access 2010?!?! So start learning today. Because being a technology dinosaur isn’t going to get you a promotion or raise! All of our videos are high-definition videos, therefore, they are best viewed with the HD setting on, and the videos enlarged. What our customers are saying: "Thank you very much for an extraordinaire online tutorial of Access, it has helped me a lot and even enabled me to get a job. Now I work for an asset management bureau in Paris programming and updating databases from Bloomberg on a daily basis!" - Lisa R., France. Take this Microsoft Access Training course now and learn Microsoft Access 2010 advanced level.

Overview

Section 1: Chapter 1 - Introduction

Lecture 1 Introduction to Advanced Access 2010

Lecture 2 READ ME: Essential Information for a Successful Training Experience

Lecture 3 Course transcripts

Lecture 4 Microsoft Access 2010 keyboard shortcuts

Lecture 5 MP3 audio files

Section 2: Chapter 2 - Macros

Lecture 6 Working with Macros

Lecture 7 AutoExec Macro

Section 3: Chapter 3 - Database Options before Distribution

Lecture 8 Database Options

Lecture 9 More Database Options

Section 4: Chapter 4 - Naming

Lecture 10 Renaming Database Objects

Section 5: Chapter 5 - Tables

Lecture 11 Review of Table Basics & Understanding Data Types

Lecture 12 Table Field Properties

Lecture 13 Validation Rules & Text

Section 6: Chapter 6 - Keys and Indexes

Lecture 14 Understanding & Using Keys and Indexes

Section 7: Chapter 7 - Normalization

Lecture 15 Data Normalization

Section 8: Chapter 8 - Relationships

Lecture 16 Types of Relationships

Lecture 17 Maintaining Relationships

Section 9: Chapter 9 - Queries

Lecture 18 Using & Understanding Queries

Lecture 19 Complex Queries

Lecture 20 Creating Queries and Using Join & Sub-Queries

Section 10: Chapter 10 - Datasheet View

Lecture 21 Course Review

Lecture 22 Datasheet View

Section 11: Chapter 11 - Forms

Lecture 23 Creating & Working with Forms

Lecture 24 Using Forms to Maintain Data

Lecture 25 Command Buttons

Lecture 26 Command Buttons Part 2

Lecture 27 Form Features that Need VBA Code

Section 12: Chapter 12 - Visual Basic for Applications

Lecture 28 Understanding When & How to Use VBA

Lecture 29 More about VBA and Using It to Improve Database

Lecture 30 VBA Language Structure & Making a Switchboard

Lecture 31 Error Handling

Section 13: Chapter 13 - Polishing Up

Lecture 32 Cleaning Up Before Distribution

Section 14: Chapter 14 - Security

Lecture 33 Security Techniques

Section 15: Chapter 15 - Import/Export

Lecture 34 External Data & Importing/Exporting Data

Section 16: Chapter 16 - Linking to Data

Lecture 35 Linking to Excel & Linking to Another Database

Section 17: Chapter 17 - Splitting Database

Lecture 36 Separating/Splitting Up Forms, Reports, etc from Database

Section 18: Chapter 18 - Multi-User

Lecture 37 Options for Making Changes When Database is Multi-User

Section 19: Chapter 19 - Reports

Lecture 38 Advanced Features for Reports

Lecture 39 Advanced Features for Reports part 2

Section 20: Chapter 20 - Package & Distribute

Lecture 40 Distributing Application

Section 21: Quiz