Teach Yourself Access 2010

Description

Now, you have a chance to learn the Office Access 2010 at anytime and anywhere in just few hours.

Use the Access 2010 Windows 8 app to learn about creating tables, forms, queries, relationships, reports, and more.

Windows 8 App Training Outline: Lesson 1: Getting Started with Office Access 2010 •Introduction to Microsoft Access 2010 •Getting familiar with Access 2010 New Interface •Viewing a Sample Database •Creating Databases using Database Templates •Creating a Table using Application parts •Creating a Simple Database using Datasheet View •Creating a Simple Database in Design View •Creating Relationship Between Tables

Lesson 2: Design and Creation of a database: student •Introduction •Designing a database •Creating a sample database: student •Creating datasheet relationships •Creating indexes •Editing field types •Editing Table Structure

Lesson 3: Various Types of Queries •Creating a select query •Creating a parameter query •Creating a cross tab query •Creating a criteria query •Performing calculation using a query •Creating an operation query •Creating an SQL query

Lesson 4: Forms •Command button used to create form •Creating a form using the Form Wizard •Creating forms using the Form Tool •Creating a split form •Using form design view to create and edit a form •Applying controls in the form design view •Creating Command buttons in the Form Design View •Creating a switchboard form

Lesson 5: Reports •Using the Report Tool to create a report •Using the Report Wizard to create a report •Using the Label Wizard to create labels •Creating a report using design view •Editing a report •Sorting and grouping in a report •Printing reports