Learn Microsoft Office Access 2007 Review
Learn Microsoft Office Access 2007 Feature
- Learn to create a useful Access database within 24 hours
- Lessons include text, voice, and mouse activities to accommodate the three basic learning styles: reading, hearing, and doing
- The best step-by-step tutorial using the latest eLearning technology
- No prior knowledge of using Access nor Database is necessary
- Database definition is included for your understanding of theory behind database's
Learn Microsoft Office Access 2007 Overview
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.....
Available at Amazon Check Price Now!
*** Product Information and Prices Stored: Dec 10, 2010 19:44:04
ไม่มีความคิดเห็น:
แสดงความคิดเห็น