Bidding has ended on this item. The seller has relisted this item or one like this.
Item:Learn Microsoft Access 2007 - Training Tutorial

Learn Microsoft Access 2007 - Training Tutorial

Item condition:New
Ended:Nov 17, 200909:59:58 PST
Bid history:0 bids
Starting bid:US $14.95
Shipping:$5.95US Postal Service First Class Mail See more services 

Country:
ZIP Code:
Service and other details:
Service
Estimated delivery*
Price
US Postal Service First Class Mail
4-7 business days
$5.95
US Postal Service Priority Mail
4-5 business days
$8.95
*The estimated delivery time is based on the seller's handling time, the shipping service selected, and the payment method selected. Sellers are not responsible for shipping service transit times. Transit times may vary, particularly during peak periods.

 See discounts 

 |  See all details
Estimated delivery within 4-7 business days
Returns:
30 day money back, buyer pays return shipping | Read details
Coverage:
Pay with and your full purchase price is covered | See terms

A reserve price is the minimum price the seller will accept. This price is hidden from bidders. To win, a bidder must have the highest bid and have met or exceeded the reserve price.

 
99.6% Positive feedback
Get fast shipping and excellent service from eBay Top-rated sellers.
  • Consistently receives highest buyers' ratings
  • Ships items quickly
  • Has earned a track record of excellent service
Other item info
Item number:230398014525
Item location:Burlingame, CA, United States
Ships to:Worldwide
Payments:
PayPal, Visa/MasterCard, Amex, Discover See details


Learn Microsoft Access 2007





 BRAND-NEW Microsoft Office Access 2007 Training Course

Put Microsoft Office Access 2007 to work for you in a 24 hours!

  • Get to know the interface and new features of New Microsoft Office Access 2007
  • Learn to create a sample Access database within 24 hours (student database)
  • 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 database theory

    Why our amazing elearning technology allows you to learn Access 2007 in a few hours?
     

  • Each step comes with voice, text, highlighted box, and mouse activity.
  • Crystal clear audio delivered by professional narrator.
  • Texts are written and edited by professional editor.
  • Mouse motion to draw your attention.
  • Highlighted box to show you exactly where to click.
  • Easy navigation to each topic.
  • Playback controller to move a slide forward, backward and stop.
  • Full-size screen display for maximum viewing (1024 x 768)
  • Side-by-side learning and doing - best for using the Excel 2007 and tutorial at the same time.
  • Click here to see a demo (it will take a few minutes to download the actual lesson)

Level: Beginner to Advanced

Microsoft Office Access 2007 Training Outline:

 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

 

Lesson 8:  Use of VBA and Modules

  • Introduction to VBA and Modules
  • Create a class module
  • Create a standard module
  • Creating and debugging procedure
  • Editing a module

Lesson 9:  Database Management and Security

  •  Backup a database
  • Compacting and repairing a database
  • Data Analysis
  • Setup Passwords
  • The Trust Center
  • Saving as an .accde file (Execute-only Database)

 

Appendix: Database Concept and definitions

Content: CD-ROM for Windows

Packaging: Sealed DVD case as sold in major retail store

System Requirements:

 Windows:

  • Windows 9x/ME/NT/2000/XP/VISTA
  • Pentium 133 Mhz or higher 
  • 32MB RAM  
  • 10MB free disk space  
  • 24x CD-ROM

 

 

View My Feedback

 





On Oct-15-09 at 08:20:09 PDT, seller added the following information:


On Oct-15-09 at 08:31:44 PDT, seller added the following information:

Every buyer gets a MyStoreRewards invitation for cash back
Shipping and handling
Item location: Burlingame, CA, United States
Shipping to: Worldwide
Change country:
ZIP Code:
 
Shipping and handling
To
Service
Estimated delivery*
US $5.95
United States
US Postal Service First Class Mail®
4-7 business days
US $8.95
United States
US Postal Service Priority Mail®
4-5 business days
*The estimated delivery time is based on the seller's handling time, the shipping service selected, and when the seller receives cleared payment. Sellers are not responsible for shipping service transit times. Transit times may vary, particularly during peak periods.
Domestic handling time
Sales tax
Will usually ship within 2 business days of receiving cleared payment.
Seller charges sales tax for items shipped to: CA(9.25%) .
Return policy
Item must be returned within
Refund will be given as
Return policy details
30 days after the buyer receives it
Money Back
Full refunds (less shipping and handling) will be issued provided that the merchandise is not opened and the merchandise is returned within 30 days of the ship date on your invoice (receipt). No return for all viewed online courses.

Before returning any merchandise for a refund or exchange, please email us at sales@amazingelearning.com. We will provide you with information necessary for the return or exchange.

Damaged/Defective Item: Damaged or defective merchandise should be reported to us as soon as possible. We will arrange for the return and/or replacement for items that were received either defective or damaged. Open CD's, CD-ROMs, or DVD's will be replaced with same title only.

Non-received/Received Wrong Item: If your order was incomplete or if you received something that you did not order, please contact us immediately. We will need to know what item(s) you received in error, if any, and what item(s) were missing from your order. We will make all necessary arrangements to correct your order.

Exchanges: If you would like to exchange any of the items that you ordered, you must contact us within 30 days from the ship date on your invoice (receipt). Open CD's, CD-ROMs, or DVD's may not be exchanged unless defective or damaged. Freight charges will be applied to any exchange and must be paid in full before exchanged merchandise is shipped.

Refunds: Refunds (less shipping and handling (15%) will be issued for the full purchase price for returned merchandise provided that the software is not opened nor used when it is returned and that the merchandise is returned within 30 days of the ship date on your invoice (receipt). Sale/clearance items and items sold "AS IS" are not refundable. All online courses are not refundable once it is viewed. Special purchase items may have refund restrictions; the Store must be contacted for approval prior to the return of such purchases. Please include a copy of your invoice with your return.

Contact Information

Phone: 650-579-6662 (9:00 am - 5:00 pm PST)

Fax: 650.579.6668

E-mail: sales@amazingelearning.com

Mail:
Amazing eLearning, LLC.
Attn: Return Department
500 Airport Blvd suite 100, Burlingame, CA 94010
The buyer is responsible for return shipping costs.

Payment details
Payment methodPreferred/AcceptedBuyer protection on eBay
Credit or debit card through PayPal
Accepted
Pay with and your full purchase price is covered | See terms
Visa/MasterCard, Amex, Discover
Accepted
See your credit card issuer's terms
Seller's payment instructions
Discounted Shipping prices on multiple purchases. We at Amazing eLearning appreciate your business and we are dedicated to manufacturing the finest training product on the market today.
Seller assumes all responsibility for this listing.

About eBay | Announcements | Security Center | Resolution Center | eBay Toolbar | Policies | Government Relations | Site Map | Help
Copyright © 1995-2009 eBay Inc. All Rights Reserved. Designated trademarks and brands are the property of their respective owners. Use of this Web site constitutes acceptance of the eBay User Agreement and Privacy Policy.
eBay official time