MOAC

Microsoft Access 2010 Training

posted Mar 19, 2014, 10:59 AM by Endrit Xhina



Introduction

This training provides you with the skills and knowledge required to create, customize, use, and share Access 2010 databases. 

Topics covered in this training include:

·         Database Basics

·         Creating a Database

·         Defining a Primary Key

·         Creating Datasheet Relationships

·         Creating a Complex Query

·         Using Lookup Fields

·         Creating and Editing a Query in SQL View

·         Creating a Report

·         Creating Pivot Objects

·         Creating and Editing a Macro

·         Handling Errors in a Macro

·         Creating and Editing a Module

·         Packaging a Database

·         Sharing a Database

 

Program

Module 1: Course 10382: Beginner Skills in Microsoft Access 2010

Students will be able to:

o    Create and edit a database.

o    Create and use a query.

o    Create and edit a report.

o    Create and edit a form.

 

Lessons

Course Overview

Module Overview

Navigation Overview

Navigation Overview

Course Information

Course Information

Lab Information

Lab Information

Beginner Skills in Access 2010

Module Overview

Creating and Editing a Database

Introduction

Exploring the Access 2010 Interface

Database Basics

Reviewing Access 2010 Fundamentals

Creating a Database

Viewing a Database

Importing and Exporting Data

Editing and Formatting Table Data

Creating and Managing Indexes

Creating an Events Database

Self Test

Creating and Using a Query

Introduction

Creating a Query by Using Query Wizard

Creating an Expression by Using Expression Builder

Creating a Criteria-Based Query

Performing Calculations by Using a Query

Creating a Query

Self Test

Working with a Report

Introduction

Creating a Report

Creating a Label

Grouping and Sorting Data in a Report

Performing Calculations in a Report

Creating and Editing a Report

Self Test

Creating and Editing a Form

Introduction

Creating a Form by Using Form Wizard

Creating a Form by Using the Form Tool

Editing a Form in Design View

Creating a Form

Self Test

Module Summary

Module Summary

Glossary

Glossary

 

Module 2: Course 10383: Intermediate Skills in Microsoft Access 2010

Students will be able to:

o    Modify a database

o    Create complex queries to extract and process specific information

Lessons

Course Overview

Module Overview

Navigation Overview

Navigation Overview

Course Information

Course Information

Lab Information

Lab Information

Intermediate Skills in Access 2010

Module Overview

Modifying a Database

Introduction

Creating a Table

Modifying a Table

Defining a Primary Key

Reviewing Table Fundamentals

Creating Datasheet Relationships

Validating Data in a Table

Using Lookup Fields

Creating a Default Database Template

Compacting a Database

Editing a Database

Self Test

Working with Complex Queries

Introduction

Creating a Complex Query

Creating a Totals Query

Creating and Editing a Query in SQL View

Creating Pivot Objects

Creating and Editing Complex Queries

Self Test

Module Summary

Module Summary

Glossary

Glossary

 

Module 3: Course 10384: Advanced Skills in Microsoft Access 2010

Students will be able to:

o    Create programmed elements to automate tasks and add functionality to database objects and controls.

o    Share and distribute database information.

Lessons

Course Overview

Module Overview

Navigation Overview

Navigation Overview

Course Information

Course Information

Lab Information

Lab Information

Advanced Skills in Access 2010

Module Overview

Creating Programmed Elements

Introduction

Exploring the Macro Environment

Creating and Editing a Macro

Creating an Embedded Macro

Handling Errors in a Macro

Creating and Editing a Module

Creating a Macro

Self Test

Sharing Database Information

Introduction

Creating an Execute-Only Database

Encrypting a Database

Using the Access 2010 Runtime Program

Packaging a Database

Synchronizing a Database with a SharePoint List

Importing Data from and Exporting Data to SharePoint Lists

Sharing a Database

Self Test

Module Summary

Module Summary

Glossary

Glossary

70-562:Microsoft .NET Framework 3.5, ASP.NET Application Development

posted Mar 18, 2014, 5:13 AM by Endrit Xhina   [ updated Mar 19, 2014, 10:58 AM ]



Introduction

This training is for students preparing to become certified for the 70-562, Microsoft .NET Framework 3.5, ASP.NET Application Development exam. The Microsoft Official Academic Course (MOAC) lessons correlate and are mapped to this Microsoft Certified Professional Developer (MCPD) 70-562 certification exam


This training course is about through mastery of:

  • Configuring and deploying web applications 
  • Consuming and creating server controls 
  • Working with data and services 
  • Troubleshooting and debugging web applications 
  • Working with ASP.NET AJAX and client-side scripting 
  • Targeting mobile devices Programming web applications



Course Content

  • Module 1: Introducing ASP.NET 3.5
  • Module 2: Creating and Configuring Server Controls
  • Module 3: Working with User Controls and Web Parts
  • Module 4: Manipulating Data Using ADO.NET
  • Module 5: Using XML and LINQ
  • Module 6: Working with ASP.NET AJAX
  • Module 7: Programming the Web Application
  • Module 8: Implementing Globalization, Personalization, and Accessibility
  • Module 9: Enhancing Security and Performance of the Web Application
  • Module 10: Working with Services, Windows Communication Foundation, and ASP.NET Extensions
  • Module 11: Working with Mobile Applications
  • Module 12: Troubleshooting and Debugging Web Applications
  • Module 13: Deploying and Publishing Web Applications Appendix A Introducing Object-oriented Programming

1-2 of 2