Sams Teach Yourself Microsoft Access 2000 in 24 Hours

Name: Sams Teach Yourself Microsoft Access 2000 in 24 Hours
Availability: OutOfStock
ISBN: 9780672312892

ISBN-10: 0672312891

ISBN-13: 9780672312892

Edition: 1999

Authors: Timothy Buchanan, Craig Eddy

List price: $24.99

30 day, 100% satisfaction guarantee!

Out of stock

We're sorry. This item is currently unavailable.

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Aimed at the user of the new Access 2000, this title discusses the main features, without going on to discuss more advanced features. Readers will be able to create simple databases, and the main issues regarding data management are covered.

Book details

List price: $24.99
Copyright year: 1999
Publisher: Sams
Publication date: 4/29/1999
Binding: Paperback
Pages: 432
Size: 7.25" wide x 9.00" long x 1.25" tall
Weight: 1.584
Language: English



Introduction



Introduction to Access 2000



Introduction to Relational Databases


Access 2000: Not Just a Desktop Database Anymore


What Is a Relational Database, Anyway?


The How and Why of Indexes


Components of an Access Database


The Limitations of Access 2000's Data Store


What's New in Access 2000


Summary


Workshop



A Quick Tour of Access 2000


Before You Install Access 2000


Installing Access 2000


Choosing Your Database Platform


Starting Access 2000 and Opening a Database


The Access Window


The Seven Main Access Database Objects


Relationships


Saving, Backing Up Databases, and Exiting Access


Summary


Workshop



Getting Help with Help Systems


Examining Ways to Get Help


Using the Office Assistant


Using the Help Topics Dialog Box


ToolTips


Summary


Workshop



Editing Data in an Existing Database



Understanding Someone Else's Database


Viewing the Splash Screen


Opening a Microsoft SQL Server Database


Looking at the Types of Security


Working with Encrypted Databases


Examining Relationships


Using the Database Documenter


Summary


Workshop



Using the Datasheet View


An Overview of the Datasheet Windows


Toolbars Used


Sorting the Datasheet


Finding and Filtering Records


Working with Records in the Datasheet


Data Entry Shortcuts


Working with Subdatasheets


Formatting the Datasheet


Printing the Datasheet


Closing the Datasheet


Summary


Workshop



Using an Existing Table


Opening Tables


Using the Design and Datasheet Views


Examining the Basic Structure of Tables


Examining Table Properties


Summary


Workshop



Using Existing Queries


Opening Queries


Using Queries in Datasheet View


Using Queries in Design View


Looking at the Basic Structure of Queries


Using Toolbars


Closing Queries


Summary


Workshop



Editing Data in Forms


Understanding Forms


Using Forms Versus Using Datasheets


Viewing Forms


Working with Data in Forms


Finding Records Using Forms


Printing Data from Forms


Closing and Saving Forms


Summary


Workshop



Displaying Data in Reports


Examining Report Fundamentals


More Ways to Open and View Reports


Printing Reports


Closing and Saving Reports


Summary


Workshop



Modifying an Existing Database



Modifying an Existing Table


Changing the Table Design


Understanding Primary Keys and Indexes


Saving the Table Design


Editing Table Relationships


Summary


Workshop



Modifying and Using Existing Queries


Using the Field List


Using the Design View's Grid


Specifying the Sort Order and Showing Fields


Specifying Criteria


Querying Multiple Tables


Setting Join Properties


Saving Queries


Summary


Workshop



Modifying an Existing Form Design


Using Form Controls


Using Advanced Control Types


Using Control Properties


Customizing Forms


Using Subforms


Summary


Workshop



Modifying an Existing Report


The Report Window


The Report Components


Report Properties


Using Expression in Reports


Summary


Workshop



Creating a Database Using Wizards



Creating a Database Using Wizards


Planning a Simple Database


Using the Database Wizard


Using the Table Wizard


The Table Analyzer Wizard


Summary


Workshop



Adding Additional Components to a Database Using Wizards


Using the Table Wizard


Using the Form Wizard


Using AutoForm to Create a Form


Using Query Wizards


Using Report Wizards


Using AutoReport to Create a Report


Using Database Wizards


Summary


Workshop



Creating a Database From Scratch



Planning and Designing Your Database


Relational Databases


The Three Types of Keys


Referential Integrity


The Three Types of Relationships


Steps to Creating a Relational Database


Choosing a Back-End Database: The Integrated Store or SQL Server


Summary


Workshop



Creating Tables


Many Means to the Same End


Creating a New Table


Data Types


Field Properties


Creating Table Indexes


Setting Relationships Between Tables


Summary


Workshop



Creating Queries


Ways to Create Queries


The Query Design View


Steps in Creating a Query


Using Advanced Selection Options in Queries


Creating Queries that Accept Parameters


Adding Calculated Fields


Additional Query Features


Summary


Workshop



Creating Forms


Types of Forms


Types of Controls


Adding Controls


Summary


Workshop



Creating Reports


Designing Reports


Designing and Creating a New Report


Summary


Workshop



Creating Macros


What Is a Macro?


The Macro Window


Creating and Editing Macros


Running Macros


Conditional Macros


Debugging Macros


Events


Integrating Macros and Forms


Summary


Workshop



Additional Topics



Exchanging Data with Word 2000, Excel 2000, and Other Applications


Using Access Data for Microsoft Word Mail Merges


Publishing Access Components Using Microsoft Word


Analyzing Access Data Using Microsoft Excel


Using the Label Wizard to Produce Labels


Exporting Data to Other Sources


Summary


Workshop



Database Administration


Compacting a Database


Repairing a Database


Backing Up a Database


Encrypting and Decrypting a Database


Converting a Database


Securing a Database


Summary


Workshop



Advanced Topics



Access 2000 and the Web


Setting Up a Web Server on Your Computer


Introducing Web Folders


Exporting Data to an HTML File


Creating Dynamic Web Pages


Data Access Pages


Summary


Workshop



Appendix



Quiz Answers


Hour 1


Hour 2


Hour 3


Hour 4


Hour 5


Hour 6


Hour 7


Hour 8


Hour 9


Hour 10


Hour 11


Hour 12


Hour 13


Hour 14


Hour 15


Hour 16


Hour 17


Hour 18


Hour 19


Hour 20


Hour 21


Hour 22


Hour 23


Hour 24


Index