Teach Yourself Access 2000 in 21 Days

Description

Sams Teach Yourself Microsoft Access 2000 in 21 Days is a hands-on tutorial for users who want to learn Access by working through solid examples. This book shows you how to develop solid databases from start to finish. Focusing on Access databases on the desktop, the book also addresses implementing Access in a networked or client/server environment. Key topics included relational databases and the Access 2000 architecture, designing, building, and maintaining full feature database applications, implementing Data Access Pages, working with Visual Basic for Applications and the Visual Basic Editor, and publishing Access content to the WWW or intranet.
·

Real world examples and tasks walk you through the learning process and allow you to apply this knowledge to your individual projects
·

Work through Access sample databases on the CD to build robust databases
·

CD-ROM contains samples needed to work through the examples in the book, and an Access 97 database for conversion practice

Table of Contents
INTRODUCTION
Behind This Book
Who Should Buy This Book
WEEK 1 - AT A GLANCE
DAY 1 - UNDERSTANDING RELATIONAL DATABASE CONCEPTS
Data Isn’t Information
The Nature of Access Data
The Theory of Database Structure
The Practice of Database Structure
Access’ Mission
Hardware Requirements
Maintaining Access Databases
Summary
Q&A
Workshop

DAY 2 - FROM IDEA TO PROJECT
The Access User Interface
Views, Opening, and Closing Objects
Global Options
The Parts of Access
Analysis of Your Project
Getting Help–The Office Assistant
Toolbars
Using the Database Wizard to Create an Application
Summary
Q&A
Workshop

DAY 3 - EXPLORING THE DATA FOUNDATIONS–THE TABLE
The Nature of a Table
Creating Your First Table
Analyzing the Wizard’s Table
Linking Fields–The Heart of the Relationship
The Outcome of a Relationship
Table and Field Properties
Indexing and More on Key Fields
Sorting and Filtering in Tables
Finding Data
Summary
Q&A
Workshop

DAY 4 - USING QUERIES FOR DATA RETRIEVAL
The Query in Access
A First Query
The Simple Query Wizard
Filtering and Sorting in Queries
Query Criteria
Multitable Queries
Multitable Queries Without Existing Links
Intermediate Criteria
Summary
Q&A
Workshop

DAY 5 - CREATING SIMPLE FORMS FOR DATA ACCESS
The Purpose of Forms in a Database
Creating a First Form
Form Design View
Form Headers and Footers
Other Form Format Properties
Tab Order
Finding, Filtering, and Sorting in Forms
Summary
Q&A
Workshop

DAY 6 - GENERATING BASIC REPORTS
Reports in Access
The AutoReport Wizard
Report Wizard
The Report Design View
Grouping in Reports
Mailing Labels
Page Layout Settings
Sums, Subtotals, and Running Sums
Summary
Q&A
Workshop

DAY 7 - AUTOMATING YOUR ACCESS APP: A MACRO PRIMER
Macros and Access
Elements of a Macro
Macros and Events
Commonly Used Macro Actions
Conditional Macros
Summary
Q&A
Workshop
WEEK 1 - IN REVIEW
WEEK 2 - AT A GLANCE
CHAPTER DAY 8 - DATA ACCESS PAGES
Access and the Web
Data Access Page Creation
The Need for Data Access Pages
The Design of Data Access Pages
Applied Data Access Pages
Summary
Q&A
Workshop

DAY 9 - REFINING YOUR TABLES
Tables and Data Integrity
Data Validation in Tables
Data Lookup in Tables
Input Masks
Using OLE Objects and Hyperlinks in Tables
Saving Tables as HTML
Summary
The Millennium Bug
Q&A
Workshop

DAY 10 - DESIGNING CUSTOMIZED FORMS
Making Attractive Forms
Using Colors in Forms
3D Effects and Object Order
Formats and System Tools
Adding Artwork
Summary
Q&A
Workshop

DAY 11 - SORTING DATA WITH QUERIES AND JOINS
General Math in Queries
Date and Time Math in Queries
Out of Order Sorting
Joins
Using Ranges in Queries
Summary
Q&A
Workshop

DAY 12 - DEVELOPING REPORTS WITH GRAPHICS AND EXPRESSIONS
Examining Complex Reports
Exploring the Report Property Sheet
Adding Images to Reports
Using Expressions in Reports
Working with Subreports
Creating Reports with Multiple Columns
Summary
Q&A
Workshop

DAY 13 - INTRODUCING VBA
Understanding VBA
Exploring Uses for VBA
Introducing the Control Wizards
Examining the Structure of VBA
Exploring the Visual Basic Editor
Introducing Language Elements
Getting Help
Summary
Q&A
Workshop

DAY 14 - UNDERSTANDING SQL
What Is SQL?
Understanding the Structure and Syntax of SQL
Exploring the Simple SELECT Statement
Using the WHERE Clause
Summary
Q&A
Workshop
WEEK 2 - IN REVIEW
WEEK 3 - AT A GLANCE
DAY 15 - EXAMINING SPECIAL-USE QUERIES
Understanding Action Queries
Using Crosstab Queries
Understanding SQL-Specific Queries
Examining Query Properties
Creating Parameter Queries
Getting Criteria for Queries from Forms
Summary
Q&A
Workshop

DAY 16 - IMPLEMENTING ADVANCED FORM CONCEPTS
Using Multiple-Table Forms
Constructing Forms with Subforms
Using Combo and List Boxes
Automating Forms by Using Control Wizards
Using SQL to Restrict a Form’s Recordset
Creating Custom Menus and Toolbars
Summary
Q&A
Workshop

DAY 17 - DEVELOPING PROFESSIONAL-QUALITY REPORTS
Exploring Advanced Report Properties
Formatting Sections
Creating Special First and Last Page Headers and Footers
Developing Parameter Reports
Handling the Null (No Data) Report Event
Creating Crosstab Reports
Publishing Your Report on the Web
Exporting a Report to HTML
Summary
Q&A
Workshop

DAY 18 - EXAMINING VBA
Reviewing the Purpose of VBA
Learning About Objects
Learning About Program Flow and Loops
Learning About Statements and Functions
Learning About Debugging and Error Handling
Summary
Q&A
Workshop

DAY 19 - WORKING WITH VBA
Using VBA to Manipulate Objects
Using VBA to Automate Data Entry
Using VBA to Work with Data Directly
Using VBA to Modify the Database
Examining the cmdExport_Click Procedure
Creating Switchboards
Summary
Q&A
Workshop

DAY 20 - UNDERSTANDING ACCESS SECURITY
Understanding the Structure of Access Security
Setting a Database Password
Using User-Level Security
Managing Passwords
Using the Security Wizard
Closing Security Holes with MDE and ADE
Summary
Q&A
Workshop

DAY 21 - DEVELOPER CONSIDERATIONS
Examining Multiuser Considerations
Splitting a Database
Using External Data Sources
Accessing the Win32 API
Adding Help to Your Applications
Setting the Database Startup Properties
Summary
Q&A
Workshop
WEEK 3 - IN REVIEW

http://rapidshare.com/files/11477792/tyacc2kin21d.rar

or

http://rapidshare.com/files/9707742/0672312921.zip

Disclaimer:
Contents of this page are indexed from the Internet. All actions are under your responsability. Email us to report illegal contents or external links and we'll remove them immediately.

Please check the description for download links if any or do a search to find alternative books.

Can't Download?
Please search mirrors if you can't find download links for "Teach Yourself Access 2000 in 21 Days" in "Description" and someone else may update the links. Check the comments when back to find any updates.

Search Mirrors
Maybe some mirror pages will be helpful, search this book at top of this page or click here to find more info.

1. Ebooks list page : 382
2. Teach Yourself Access 2000 in 21 Days
3. Sams Teach Yourself Microsoft Access 2000 in 21 Days
4. Sams Teach Yourself Microsoft Access 2000 in 24 Hours
5. Sams Teach Yourself Microsoft Access 2000 in 24 Hours
6. Sams Teach Yourself Microsoft Access 2000 in 24 Hours
7. Sams Teach Yourself Java 2 in 21 Days (Teach Yourself in 21 Days Series)
8. Grover Park George on Access: Access 2000, Access 2002, Access 2003 (On Office s
9. Teach Yourself Java in 21 Days: Professional Reference Edition (Sams Teach Yourself)
10. Teach Yourself Corba in 14 Days (Teach Yourself...)
11. Teach Yourself Borland C 5 in 21 Days (Sams Teach Yourself)
12. Teach Yourself Illustrator in 7 Days (Sams Teach Yourself)
13. Teach Yourself Borland C 5 in 21 Days (Sams Teach Yourself)
14. Teach Yourself Ole Db and Ado in 21 Days (Sams Teach Yourself)
15. Sams Teach Yourself Java 2 in 21 Days (4th Edition) (Sams Teach Yourself)
16. Teach Yourself SQL in 21 Days