Learn Microsoft Office Access 2007

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.....