Quick, Simple Microsoft Access 2000
Published on 10. August 1999
Book
Spiral bound
248 pages
978-0-13-081320-6 (ISBN)
Description
For short, introductory courses on Windows/98 and Office 2000. Supported by numerous exercises and projects designed to appeal to a wide range of students, these practical and informative texts offer a step-by-step, hands-on guide to learning the software. Ericksen fills a much-needed void in the market. *Full, four-color, spiral-bound texts on the latest releases of Microsofts best-selling applications. *Gives students up-to-date information on current applications in an attractive, and easy-to-use format. *Completely visual, hands-on in orientation with minimal reading; the focus is on doing. Explains each task in detail, concluding with a practice exercise students can perform. Presents numerous screen shots, including dialog boxes and results of the exercises. *Gives students opportunities to practice tasks, and provides visual reinforcement. *Concise, task-oriented objectives, guided exercises, and end-of-chapter summaries. *Helps keep students on track. *Unique "What/How/Why/Tips" organization. *Streamlines tasks for students, making skill mastery easy.
*End-of-chapter independent practice exercises, objective reviews, and key terms lists as well as end-of-part integrated Check Point activities. *Enables students to apply what they learn. *Also available: SkillCheck skills-based assessment software (applications simulated testing. *Supported by interactive, CD-ROM based tutorials developed by CBT Systems, these tutorials may be value packed with any text in the series. *Each text in the Ericksen series is part of the Prentice Hall custom binding program, the Right PHit. *All supplements for this series, including Instructors Manual, Solutions Disk, PowerPoint, and Data Disks as well as the Computerized Testing System, are available on one CD.
*End-of-chapter independent practice exercises, objective reviews, and key terms lists as well as end-of-part integrated Check Point activities. *Enables students to apply what they learn. *Also available: SkillCheck skills-based assessment software (applications simulated testing. *Supported by interactive, CD-ROM based tutorials developed by CBT Systems, these tutorials may be value packed with any text in the series. *Each text in the Ericksen series is part of the Prentice Hall custom binding program, the Right PHit. *All supplements for this series, including Instructors Manual, Solutions Disk, PowerPoint, and Data Disks as well as the Computerized Testing System, are available on one CD.
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
Dimensions
Height: 276 mm
Width: 220 mm
Thickness: 15 mm
Weight
507 gr
ISBN-13
978-0-13-081320-6 (9780130813206)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Content
1. Getting Started.
Introduction to Databases. Starting the Software. The Interface. Exploring the Database Window. Opening a Table. Using Help. Closing a Database. Exiting Access and Shutting Down Windows.
2. Creating a Database.
Creating a Table. Creating a Table in Datasheet View. Assigning Field Properties. Creating a Primary Key. Creating Relationships between Tables. Printing the Table Design. Saving and Compacting the Database.
3. Working with Data in the Database.
Adding Records. Editing Records. Inserting Records. Deleting Records. Moving Records. Finding Records. Sorting Records. Printing the Records in Datasheet View.
Check Point 1.
4. Querying the Database.
Filtering Data in the Database. Using the Simple Query Wizard. Sorting the Query Results. Creating a Query using Query Design. Printing the Query Results. Editing a Query. Saving a Query.
5. Creating Forms.
Using the Form Wizard to Create a Form. Using Form Design to Create a Form. Using AutoForm. Editing a Form. Adding Controls to a Form. Entering Data Using a Form. Printing Forms.
6. Creating Database Reports.
Using AutoReport to Create a Report using a Table. Using AutoReport to Create a Report based on a Query. Using the Report Wizard to Create a Report. Using the Label Wizard to Create Mailing Labels. Editing a Report. Saving a Report. Printing a Report.
Check Point 2.
7. Enhancing the Database.
Editing the Table Structure. Having Access Enter Default Data. Learning More about Table Relationships. Creating a Junction Table.
8. Using Access with the Internet and Other Programs.
Using the Publish to Web Wizard. Creating Hyperlink. Using Access with Microsoft Word. Using Access with Microsoft Excel.
Check Point 3.
Appendix A: Alphabetized list of Tasks.
Introduction to Databases. Starting the Software. The Interface. Exploring the Database Window. Opening a Table. Using Help. Closing a Database. Exiting Access and Shutting Down Windows.
2. Creating a Database.
Creating a Table. Creating a Table in Datasheet View. Assigning Field Properties. Creating a Primary Key. Creating Relationships between Tables. Printing the Table Design. Saving and Compacting the Database.
3. Working with Data in the Database.
Adding Records. Editing Records. Inserting Records. Deleting Records. Moving Records. Finding Records. Sorting Records. Printing the Records in Datasheet View.
Check Point 1.
4. Querying the Database.
Filtering Data in the Database. Using the Simple Query Wizard. Sorting the Query Results. Creating a Query using Query Design. Printing the Query Results. Editing a Query. Saving a Query.
5. Creating Forms.
Using the Form Wizard to Create a Form. Using Form Design to Create a Form. Using AutoForm. Editing a Form. Adding Controls to a Form. Entering Data Using a Form. Printing Forms.
6. Creating Database Reports.
Using AutoReport to Create a Report using a Table. Using AutoReport to Create a Report based on a Query. Using the Report Wizard to Create a Report. Using the Label Wizard to Create Mailing Labels. Editing a Report. Saving a Report. Printing a Report.
Check Point 2.
7. Enhancing the Database.
Editing the Table Structure. Having Access Enter Default Data. Learning More about Table Relationships. Creating a Junction Table.
8. Using Access with the Internet and Other Programs.
Using the Publish to Web Wizard. Creating Hyperlink. Using Access with Microsoft Word. Using Access with Microsoft Excel.
Check Point 3.
Appendix A: Alphabetized list of Tasks.