Access 2007 Essential Training

16th
DEC

From using predefined Access 2007 database applications to building them from scratch, Access 2007 Essential Training covers each step of understanding, creating, and modifying databases for custom business purposes. 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.

Table of contents
Introduction
Welcome 0:47 0.9 MB
1. Getting Started with Access
Database concepts and terminology 10:12 17.4 MB
Starting Access 5:15 7.5 MB
The Getting Started window 4:42 6.8 MB
The Quick Access toolbar 3:51 6.7 MB
Opening an existing Access database 2:51 5.2 MB
The work environment 9:38 14.4 MB
Customizing the Access environment 6:48 11.2 MB
2. Creating Databases and Tables
Planning and designing databases 2:38 2.7 MB
Working with fields 5:31 3.9 MB
Choosing keys 3:42 2.8 MB
Creating tables 3:10 4.5 MB
Creating fields 6:30 6.6 MB
Working with records 5:05 5.6 MB
Working with data 7:15 9.8 MB
Checking spelling 5:32 7.4 MB
3. Working with Fields and Records
Modifying table design 6:08 8.6 MB
Finding and editing records 3:39 5.3 MB
Organizing and sorting records 4:58 7.4 MB
4. Creating Data Entry Rules
Setting field properties 5:32 7.3 MB
Using input masks 5:36 7.3 MB
Setting validation rules 8:26 12.4 MB
5. Relational Database Techniques
Creating key fields 4:56 6.6 MB
Creating table relationships 5:58 7.2 MB
Enforcing referential integrity 4:17 4.8 MB
Using subdatasheets 4:24 5.5 MB
6. Working with Queries
Creating a query using the wizard 5:15 6.3 MB
Creating a query from scratch 6:34 8.3 MB
Modifying a query in Design view 4:41 5.7 MB
Performing calculations on a group of records 2:37 3.2 MB
Creating flexible queries 7:27 9.7 MB
7. Working with Forms
Introduction to forms 2:08 1.9 MB
Creating forms with the Form wizard 6:27 7.2 MB
Creating forms from the Design view 5:00 6.3 MB
Modifying a form’s design 8:09 15.8 MB
Creating subforms 6:19 9.9 MB
Adding command buttons to a form 5:57 9.4 MB
Sorting and filtering with forms 6:17 8.1 MB
Switchboards vs. the Navigation pane 11:20 16.7 MB
8. Working with Reports
Using the Report wizard 6:09 7.5 MB
Modifying reports in Design view 7:30 12.8 MB
Adding custom calculated fields to a report 7:11 11.1 MB
Formatting reports 9:49 17.3 MB
Summarizing report information 7:58 12.3 MB
Creating a mailing label report 6:26 8.9 MB
Printing reports 4:34 6.9 MB
9. Working with Macros
Creating macros 4:57 6.2 MB
Attaching macros 5:01 8.1 MB
Automating data entry with macros 7:49 10.1 MB
Validating data with macros 7:16 9.3 MB
Creating auto-executing macros 2:55 3.5 MB
10. Sharing Data with Word and Excel
Importing data into Access 6:14 8.7 MB
Using Package and Sign 5:28 8 MB
Sharing via email 4:29 6.7 MB
Exporting data to Excel 4:37 7.8 MB
11. Working with Charts
Working with charts 7:14 14.3 MB
Working with pivot charts 5:21 7.4 MB
download links:

http://rapidshare.com/files/173828267/Access.07.part2.rar

http://rapidshare.com/files/173828278/Access.07.part1.rar

http://rapidshare.com/files/173828343/Access.07.part3.rar

Login [This hidden content is only available for our VIP member]. Become VIP Member NOW

Password default : netbks.us

Donate to become VIP member

Add this page to your favorite Social Bookmarking websites

Report Dead Link Please leave a comment to report dead links, so that someone else may update new links.

If you enjoyed this post, make sure you subscribe to my RSS feed!

Related Ebooks

Reader's Comments

kirk | March 1st, 2009 at 5:37 pm
iso file
damage..
only few
media can
be played..
can u re
upload
gaquay..
kirk | March 1st, 2009 at 5:40 pm
error:failed to render the file
can u help gaquay
rajib | November 11th, 2009 at 7:13 pm
plz admin refresh the link
IDM | November 11th, 2009 at 7:47 pm
it work for me, plz download try again
brymacmd | January 16th, 2010 at 9:03 am
Tried to extract files and I’m getting a CRC error…any ideas?