 | Book Title | : | Microsoft® Access® 2010: Complete SHELLY CASHMAN SERIES |
| Author | : | Gary B. Shelly; Philip J. Pratt; Mary Z. Last | |
| Publisher | : | Course Technology, Cengage Learning | |
| Year | : | 2011 | |
| Language | : | English | |
| Page | : | 564 | |
| File Format | : | ||
| File Size | : | 33.97 MB |
Free download ebook - Microsoft® Access® 2010: Complete.
Microsoft Access 2010: Complete is intended for a six- to nine-week period in a course that teaches Access 2010 in conjunction with another application or computer concepts. No experience with a computer is assumed, and no mathematics beyond the high school freshman level is required. The objectives of this book are:
- To offer an in-depth presentation of Microsoft Access 2010
- To expose students to practical examples of the computer as a useful tool
- To acquaint students with the proper procedures to create databases suitable for coursework, professional purposes, and personal use
- To help students discover the underlying functionality of Access 2010 so they can become more productive
- To acquaint students with the proper procedures to create databases suitable for coursework, professional purposes, and personal use
- To develop an exercise-oriented approach that allows learning by doing
Microsoft Access 2010: Complete offers a number of new features and approaches, which improve student understanding, retention, transference, and skill in using Access 2010. The following enhancements will enrich the learning experience:
- Offi ce 2010 and Windows 7: Essential Concepts and Skills chapter presents basic Offi ce 2010 and Windows 7 skills.
- Streamlined fi rst chapter allows the ability to cover more advanced skills earlier.
- Chapter topic redistribution offers concise chapters that ensure complete skill coverage.
- New pedagogical elements enrich material creating an accessible and user-friendly approach.
- Break Points, a new boxed element, identify logical stopping points and give students instructions regarding what they should do before taking a break.
- Within step instructions, Tab | Group Identifi ers, such as (Home tab | Bold button), help students more easily locate elements in the groups and on the tabs on the Ribbon.
- Modifi ed step-by-step instructions tell the student what to do and provide the generic reason why they are completing a specifi c task, which helps students easily transfer given skills to different settings.
Contents at a Glance
Microsoft Office 2010 and Windows 7
Offi ce 2010 and Windows 7: Essential Concepts and Skills
Objectives
Office 2010 and Windows 7
Introduction to the Windows 7 Operating System
Introduction to Microsoft Offi ce 2010
Starting and Using a Program
Saving and Organizing Files
Screen Resolution
Additional Common Features of Offi ce Programs
Moving, Renaming, and Deleting Files
Microsoft Offi ce and Windows Help
Chapter Summary
Learn It Online
Apply Your Knowledge
Extend Your Knowledge
Make It Right
In the Lab
Cases and Places
Microsoft Access 2010
CHAPTER ONE: Databases and Database Objects: An Introduction
Objectives
Introduction
Project — Database Creation
Designing a Database
Creating a Database
The Access Window
Creating a Table
Previewing and Printing the Contents of a Table
Creating Additional Tables
Importing Data from Other Applications to Access
Additional Database Objects
Database Properties
Special Database Operations
CHAPTER TWO: Querying a Database
Objectives
Introduction
Project — Querying a Database
Creating Queries
Sorting
Joining Tables
Creating a Form for a Query
Exporting Data from Access to Other Applications
Adding Criteria to a Join Query
Calculations
Crosstab Queries
CHAPTER THREE: Maintaining a Database
Objectives
Introduction
Project — Maintaining a Database
Updating Records
Filtering Records
Changing the Database Structure
Mass Changes
Validation Rules
Changing the Appearance of a Datasheet
Multivalued Fields in Queries
Referential Integrity
Ordering Records
CHAPTER FOUR: Creating Reports and Forms
Objectives
Introduction
Project — Project — Reports and Forms
Report Creation
Multitable Reports
Form Creation
Mailing Labels
CHAPTER FIVE: Multitable Forms
Objectives
Introduction
Project — Multitable Forms
Adding Special Fields
Updating the New Fields
Joining Tables
Multitable Form Techniques
Object Dependencies
Date/Time, Memo, and Yes/No Fields in Queries
Datasheets in Forms
Creating a Multitable Form Based on the Many Table
CHAPTER SIX: Advanced Report Techniques
Objectives
Introduction
Project — Advanced Report Techniques
Additional Tables
Creating Reports in Design View
CHAPTER SEVEN: Using SQL
Objectives
Introduction
Project — Using SQL
SQL Background
SQL Queries
Grouping
Joining Tables
Comparison with Access-Generated SQL
Updating Data through SQL
Appendices
APPENDIX A: Project Planning Guidelines
Using Project Planning Guidelines
Summary
APPENDIX B: Publishing Offi ce 2010 Web Pages Online
Index
Quick Reference Summary
