Training Home | Microsoft Access 2007 Training DVD
Microsoft Access 2007 Training DVD
Take your skills to the next level. This Microsoft Access 2007 training DVD is the ultimate in comprehensive learning for the discerning professional.
The training uses broadcast quality audio and video to deliver concise and informative training right to your desktop. Complete with practical working files and presented via an intuitive, easy-to-use interface, These Microsoft Access 2007 tutorials make learning simple, quick and enjoyable. All training courses are authored by certified professional instructors who have a passion for teaching.
Training Benefits - Learn from the Pros
- Reduce learning time by 80%. Learn from a professional trainer from your own desk.
- Visual training method, offering users increased retention and accelerated learning.
- Breaks even the most complex applications down into simplistic steps, ideal for users who learn faster when shown.
Table of contents : see below. - Try a Free Demo
For evaluation purposes the links below offer an insight into the quality of these Microsoft Access 2007 tutorials. In order for the demo videos to play QuickTime needs to be installed.Introduction to Microsoft Access 2007
1. Getting Started
- Database concepts and terminology
- Starting Access
- The Getting Started window
- The Quick Access toolbar
- Opening an existing Access database
- The work environment
- Customizing the Access environment
2. Creating Databases and Tables
- Planning and designing databases
- Working with fields
- Choosing keys
- Creating tables
- Creating fields
- Working with records
- Working with data
- Checking spelling
3. Working with Fields and Records
- Modifying table design tutorials
- Finding and editing records
- Organizing and sorting records
4. Creating Data Entry Rules
- Setting field properties
- Using input masks in Access
- Setting validation rules
5. Relational Database Techniques
- Creating key fields
- Creating table relationships
- Enforcing referential integrity
- Using subdatasheets
6. Working with Queries
- Creating a query using the wizard
- Creating a query from scratch
- Modifying a query in Design view
- Performing calculations on a group of records
- Creating flexible queries
7. Working with Forms
- Introduction to forms
- Creating forms with the Form wizard
- Creating forms from the Design view
- Modifying a form's design
- Creating subforms
- Adding command buttons to a form
- Sorting and filtering with forms
- Switchboards vs. the Navigation pane
8. Working with Reports - Tutorials
- Using the Report wizard
- Modifying reports in Design view
- Adding custom calculated fields to a report
- Formatting reports
- Summarizing report information
- Creating a mailing label report
- Printing reports
9. Working with Macros
- Creating macros tutorials
- Attaching macros
- Automating data entry with macros
- Validating data with macros
- Creating auto-executing macros
10. Sharing Data with Word and Excel
- Importing data into Access
- Using Package and Sign
- Sharing via email
- Exporting data to Excel
11. Working with Charts in Access 2007
- Working with charts
- Working with pivot charts
Access 2007 Training Essentials
Title Information.
From using predefined Access 2007 database applications to building them from scratch, Access 2007 Training Essentials covers each step of understanding, creating, and modifying databases for custom business purposes in this 5 hour long practical tutorial. Instructor David Rivers shows even the most database-challenged how to utilize this powerful software for creating reports and charts, as well as for business record keeping and analysis. Exercise files accompany the tutorials. Close »
Format : DVD
Price : $49.95 | £24.95 | €32.95
Publisher : lynda.com, Inc.
Duration : 5.5 hours - 57 lessons
Platform : PC or Mac
Closed Captioning : No
Microsoft Access 2007 Related Training Videos :
FileMaker Pro 9 Training DVD | FileMaker Pro 9 Beyond the Basics | Microsoft Word 2008 for Mac Training DVD
FileMaker Pro 9 Training DVD | FileMaker Pro 9 Beyond the Basics | Microsoft Word 2008 for Mac Training DVD
Learn Online - Unlimited Access - Low Price
Giving you amazing freedom to learn at your own pace these online training videos combine high quality professionally created content, broadcast standard high definition video and crystal clear audio, at an extremely cost effective price. The tutorials are presented via an easy to use interface.
You can now access an entire library of professionally created tutorials in High Definition video for the same price as our competitors charge from one DVD.
Users are bound by no constants on the amount of titles that can be viewed, access can be from any location and where available, working files are included at no extra charge.
Comprehensive list of all Online Training Courses included in the online service.
CREATE A TEST ACCOUNT
Sample the quality of this online training with a free online test account. You will have immediate access to the first 20 minutes of all the tutorials in the online learning library.
