CBT Nuggets MOS Series: Access 2003

图书介绍

Turn your desktop computer into a powerful custom database
With Microsoft Access 2003 you can create custom databases that run from your desktop.

This can be a database of common questions and answers for your tech support staff. Or customized inventory tracking for your warehouse. Even a contact management system for your sales team. Pick your own data-related problem that’s just waiting for a simple solution. Microsoft Access makes it easy to create these solutions. Plus Access simplifies the task of building software front-ends for your databases.

In the MOS Series: Access 2003 videos, you’ll learn how to use Access to start creating powerful custom desktop databases — even if you have no prior database experience.

Here’s what you’ll learn in the videos:

Install Office 2003, plus get critical security and stability updates while you install — these updates are more important than you might think. (Video 1)
Discover how relational databases give you power over your data and how to use them in Access — including a security tip to know before you start using Access 2003. (Video 2)
Create a database in one of three ways — use templates, start from scratch, or “borrow” a database and make it your own. Plus go step-by-step through creating a contact management database to see how it’s done. (Video 3)
Create tables inside your database either from scratch or by using the wizard. Learn how primary keys define relationships between the data in different tables. (Video 4)
Take control of your table design using design view — make sure your data is organized in a way that’s easy to access later. Plus understand some simple design tips that make running queries on your data easier and more accurate. (Video 5)
Link pictures, documents, and other files to your data plus display and modify the different data types that you can plug into database fields. Also, learn how ‘lookup’ fields help you keep your data consistent throughout your database. (Video 6)
Use advanced techniques for modifying field properties so you can prevent bad data from being put into your database — including how input masks help you define what users are allowed to input. (Video 7)
Organize, link, identify, filter, and combine your data by defining the relationships between groups of data in your database — this is where the real power of Access comes from. Understand relationship types, how to create relationships in Access, and how enforcing referential integrity protects your database. (Video Use queries to pull data from multiples tables in your database for easy viewing and editing. Learn how to write queries in either the Query Wizard or in design view — then use the one that works better for you. (Video 9)
Use crosstab queries to compile data from multiple sources. Find repeated records in your database with duplicate queries. And use unmatched queries to find records that appear in one place but not in another. (Video 10)
Create forms that let others view and edit data in your database, even if they’re not as smart with Access as you are! This is also a good way to simplify your regular database tasks like adding data to a table or viewing specific query output. (Video 11)
Learn advanced form techniques — including how to create subforms and linked forms to present complex data in an easy to read way. (Video 12)
Export data from your database in reports — including custom formatting letting you easily generate things like invoices, envelope labels, and sales performance or other data-tracking charts. (Video 13)
In business, the reports you hand out must be useful and look good or they can reflect negatively on you. Customize your Access reports to contain all the relevant information you want, and to make them look good to impress your boss. (Video 14)
Create data access web pages that link to your Access databases, so you can connect to your database from any computer with a web browser — including two important considerations to make sure this works correctly and stays secure. (Video 15)
Protect your database from loss by backing it up. Learn to export and import data for sharing between other databases and applications. Plus keep your database healthy by compacting or repairing it as needed. (Video 16)
Secure your database at three different levels — encode data so the files can only be viewed in Access, password protect your database so nobody can see it just by launching Access, and give permissions to people who need limited access by defining workgroups. (Video 17)
Unlock an incredibly powerful way of viewing and presenting your data with Pivot Tables and Pivot Charts. Looking at one table at a time is like viewing a printed page — but using pivot tables and charts is like seeing your data in 3D. (Video 18)
In the last 2 videos in this series, you’ll follow along and watch as a database is built from the ground up to solve a real-world data storage problem. This cements your knowledge and prepares you to go create database solutions on your own. (Videos 19 & 20)

Download:
http://rapidshare.com/files/14190942/v-cmseac.part01.rar
http://rapidshare.com/files/14193832/v-cmseac.part02.rar
http://rapidshare.com/files/14196271/v-cmseac.part03.rar
http://rapidshare.com/files/14217821/v-cmseac.part04.rar
http://rapidshare.com/files/14199734/v-cmseac.part05.rar
http://rapidshare.com/files/14201840/v-cmseac.part06.rar
http://rapidshare.com/files/14208582/v-cmseac.part07.rar
http://rapidshare.com/files/14210328/v-cmseac.part08.rar
http://rapidshare.com/files/14212877/v-cmseac.part09.rar
http://rapidshare.com/files/14214724/v-cmseac.part10.rar
http://rapidshare.com/files/14215162/v-cmseac.part11.rar

password: www.flibrary.org

1. Ebooks list page : 1388
2. CBT Nuggets MOS Series: Access 2003
3. CBT Nuggets MOS Series Access 2003
4. Cbt Nuggets Mos Series Frontpage 2003
5. Cbt Nuggets Mos Series Frontpage 2003
6. CBT Nuggets MCAS Series Microsoft Office Access 2007 -RELOAD
7. CBT Nuggets MCAS Series Microsoft Office Access 2007 -RELOAD
8. CBT Nuggets MCAS Series Microsoft Office Access 2007
9. CBT Nuggets MCAS Series Microsoft Office Access 2007
10. CBT Nuggets MCAS Series Microsoft Office Access 2007
11. CBT Nuggets MCAS Series Microsoft Office Access 2007
12. [request_ebook] CBT Nuggets for LPIC-1
13. CBT Nuggets MOS Excel 2003
14. CBT Nuggets Upgrading Your MCSA 2003 to Server 2008 70-648
15. CBT NUGGETS LINUX SERIES
16. Cbt nuggets linux series
17. CBT Nuggets Linux Series (Biginners)
18. CBT Nuggets Linux Series (Biginners)
19. CBT Nuggets MCAS Series Microsoft Office Powerpoint 2007
20. CBT Nuggets : Linux Series Video Tutorial
21. CBT Nuggets : Linux Series Video Tutorial

• Download Thousands of Books!
• Download millions of Usenet resources!

1. 艺术设计
2. 有声读物
3. 语言文化
4. 家庭生活
5. 法律
6. 音乐歌词
7. 软件相关
8. BT种子
9. 其它图书
10. 所有留言
12. 留言评论
13. Download Thousands of Books two weeks for FREE!
14. Download millions of Usenet resources!
15. Exam1Pass-Latest IT Certification Study Guide for IT Exams
16. Meetexams
17. 640-802
18. Needking
19. Passshope
20. 海淀驾校

• 推荐到 StumbleUpon!
• del.icio.us
• Google书签
•