Watch this item

Learn Microsoft Access 2007 Training Tutorial

Item condition:New
Quantity:
9 available
Please enter a quantity of $quantity$ or less
Please enter a quantity of 1
Price:US $19.95
Approximately £11.98
Buy It NowBuy It NowBuy It Now
Postage:US $7.95Standard Int'l Flat Rate PostageSee more services 

Country:
Postcode:
Quantity:
(available quantity 9)
Service and other details:
Service
Estimated delivery*
Price
Standard Int'l Flat Rate Postage
varies
US $7.95
*The estimated delivery time is based on the seller's dispatch time, the postal 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 time varies for items dispatched from an international location
Payments:
PayPal, Visa/MasterCard, Discover | See details
Returns:
Returns accepted | Read details

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.

 
Seller info
99.5% Positive feedback
Other item info
Item number:380134128694
Item location:USA, United States
Post to:United States, Europe, Canada, Australia, Japan
History:3 sold

 

Learn Access 2007 

 

 

Learn to put Access 2007 to work for you in a few 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

Advantages of amazing elearning technology that 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.

Lessons Include:

 Level:  Basic to Intermediate

  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

 

System Requirements:

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

Brand New in shrinkwrapped plastic case

Payment Method/Terms:

  • Paypal, Visa, Mastercard, Discover
  • Please add $4.95 s/h in U.S.A. $5.95 to Canada. $7.95 to Western Europe, Japan and Australia. Insurance is included.
  • 30 day warranty for defective media.
  • We will ship your item(s) within 24 hours of payment (excluding weekends). We will send you an item shipped email to notify you.
  • Payment is due within 10 days of auction completion.
  • By bidding, you will entering into a contract to purchase this item. We humbly request that you bid only if you are certain you wish to purchase this item. 
  • End of Auction:We will email the winning bidder within 24 hours after the auction ends, excluding weekends. We will provide you with complete payment and contact information.

Check out our other items up for bid and save on shipping by combining items.      

(click to view ebay auctions)       

Thanks for looking and have a great day!


Powered by eBay Turbo Lister
The free listing tool. List your items fast and easy and manage your active items.
Postage and packaging
Item location: USA, United States
Dispatches to: United States, Europe, Canada, Australia, Japan
Quantity:
Change country:
Postcode:
 
Postage and packaging
Each additional item
To
Service
Estimated delivery*
US $7.95
US $3.75
United Kingdom
Standard Int'l Flat Rate Postage
varies for items dispatched from an international location
*The estimated delivery time is based on the seller's dispatch time, the postal 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.
Postal insurance
Included (in the postage & packaging cost)
Return policy
Software is not refundable unless returned unopened and still sealed. Returns must be made within 14 days of the date merchandise received. Shipping and handling charges are non-refundable. All returns must be accompanied by the original packaging, software, booklets and pamphlets, etc. in new and resalable condition and free of any markings or damage. The customer will be responsible for shipping charges to return the package.
Payment details
Payment methodPreferred/AcceptedBuyer protection on eBay
Credit or debit card through PayPal
Accepted
Visa/MasterCard, Discover
Accepted
Seller assumes all responsibility for this listing.

About eBay | Announcements | Safety Centre | Partner Centre | VeRO: Protecting Intellectual Property | Policies | Feedback Forum | 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