Learn Microsoft Office Access 2007

UPC: 00634910005222

Description
Specification

Level: Beginner to Advanced Lesson 1: Getting Started with Office Access 2007 * Opening up Access 2007 * Getting started with access options and tools * Getting started with templates * Getting started with blank databases and recent databases * The Function Area * The Navigation pane * Tabbed documents * The status bar Lesson 2: Design and Creation of a database: student * Design a database * Create a sample database: student * Create datasheet relationships * Create indexes * Edit field types * Edit table structure * Format datasheets Lesson 3: Various Types of Queries * Create a select query * Create a parameter query * Create a cross tab query * Create a criteria query * Perform calculation using a query * Create an operation query * Create an SQL query Lesson 4: Forms * Command button used to create form * Create a form using the Form Wizard * Create forms using the Form Tool * Create a split form * Use form design view to create and edit a form * Applying controls in the form design view * Create a switchboard form Lesson 5: Reports * Use the Report Tool to create a report * Use the Report Wizard to create a report * Use the Label Wizard to create labels * Create a report using design view * Editing a report * Sorting and grouping in a report * Calculations in a report * Printing reports Lesson 6: Importing and Exporting Data * Importing Access files * Importing Excel files * Importing SharePoint lists * Importing text files * Importing XML files * Linking to Access files * Linking to Excel files * Exporting a table as an Excel worksheet * Exporting to a SharePoint site * Exporting as . PDF or other type of file Lesson 7: Use of Macros to automate tasks * Create a macro using 1st method * Create a macro using 2nd method * Editing a macro * Create a macro group * Create a conditional macro and more. . . . . Brand: Amazing eLearning. Binding CD-ROM. Platform(s): Windows XP Windows Vista Windows 2000 Windows NT. Publisher(s): Amazing eLearning, LLC. Label: Amazing eLearning, LLC. Format: CD-ROM. Level: Beginner to Advanced Lesson 1: Getting Started with Office Access 2007 * Opening up Access 2007 * Getting started with access options and tools * Getting started with templates * Getting started with blank databases and recent databases * The Function Area * The Navigation pane * Tabbed... MORE...

Manufacturer:
Part Number:
Lowest Price (CAD):	$26.13
No specifications available

Learn Microsoft Office Access 2007

SHOP FOR

ALSO ON YAHOO! CANADA

THINGS TO DO