- Shopping Bag ( 0 items )
Ships from: Chatham, NJ
Usually ships in 1-2 business days
|About Access 2002||1|
|Open Access and Explore the Access Workspace||2|
|Use Access Help||5|
|A Brief Overview of Database Design||12|
|Ch. 1||Core Skill Set I: Creating and Using Databases||15|
|Skill 1.1||Create Access Databases||17|
|Skill 1.2||Open Database Objects in Multiple Views||32|
|Skill 1.3||Move Among Records||44|
|Skill 1.4||Format Datasheets||48|
|Ch. 2||Core Skill Set 2: Creating and Modifying Tables||57|
|Skill 2.1||Create and Modify Tables||58|
|Skill 2.2||Add a Predefined Input Mask to a Field||72|
|Skill 2.3||Create Lookup Fields||77|
|Skill 2.4||Modify Field Properties||82|
|Ch. 3||Core Skill Set 3: Creating and Modifying Queries||95|
|Skill 3.1||Create and Modify Select Queries||97|
|Skill 3.2||Add Calculated Fields to Select Queries||108|
|Ch. 4||Core Skill Set 4: Creating and Modifying Forms||115|
|Skill 4.1||Create and Display Forms||117|
|Skill 4.2||Modify Form Properties||127|
|Ch. 5||Core Skill Set 5: Viewing and Organizing Information||157|
|Skill 5.1||Enter, Edit, and Delete Records||158|
|Skill 5.2||Create Queries||170|
|Skill 5.3||Sort Records||177|
|Skill 5.4||Filter Records||187|
|Ch. 6||Core Skill Set 6: Defining Relationships||201|
|Skill 6.1||Create One-to-Many Relationships||203|
|Skill 6.2||Enforce Referential Integrity||214|
|Ch. 7||Core Skill Set 7: Producing Reports||223|
|Skill 7.1||Create and Format Reports||225|
|Skill 7.2||Add Calculated Controls to Reports||238|
|Skill 7.3||Preview and Print Reports||248|
|Ch. 8||Core Skill Set 8: Integrating with Other Applications||257|
|Skill 8.1||Import Data to Access||258|
|Skill 8.2||Export Data from Access||268|
|Skill 8.3||Create a Simple Data Access Page||273|
Prentice Hall Test Prep Series courseware is anchored in the practical and professional needs of all types of students. The MOUS titles within this series focus on preparing students to sit for the associated Core, Comprehensive, or Expert MOUS exam. Coverage of concepts and how-to steps make each text suitable for general introductory computer courses as well.
The chapters in each MOUS Prep text exactly match the skill sets—and skills being measured within each skill set—published for the associated MOUS exam. As such, it consists of skills that are built around a series of numbered, step-by-step procedures that are clear, concise, and easy to review. The end-of-chapter exercises have likewise been carefully crafted to reinforce skills and to extend what you've learned into areas beyond the explicit scope of the specific skills. Following, you'll find out more about the rationale behind each book element and how to use each to your maximum benefit.
Each MOUS Prep book is organized by chapters-one chapter per core or expert skill set. A skill set consists of numbered skill areas that are related to that topic. Each skill within a numbered skill area presents a specific task or closely related set of tasks in a manageable chunk that is easy to assimilate and retain.
Each element in a MOUS Prep book is designed to maximize your learning experience. Following is a list of the MOUS Prep skill set elements and a description of how each element can help you:
Prentice Hall Test Prep uses the following conventions to make it easier for you to understand the material.
The Web site that accompanies this book is the tool that empowers you to get the most out of this text (see Figure I. I ). It provides access to all the data files for you to use as you work through the step-by-step tutorials, and the Skill Drill and Challenge exercises provided at the end of each skill set.
Accessing Student Data Files on the Companion Website
Data files are provided for each chapter. The filenames correspond to the filenames called for in this book. The files are named in the following manner: The first character indicates the book series (M=MOUS); the second character denotes the application (W=Word, E=Excel, and so forth); and the third character indicates the level (C=Core or Comprehensive and E=Expert). The last four digits indicate the skill set number and the file number within the skill set. For example, the complete name for the first file in Chapter 3 (Core Skill Set 3) in the MOUS Word book is MWCS301. The complete name for the third file in Chapter 14 (Expert Skill Set 7) in the MOUS Excel book is MEE-S703.
Instructor's Resource CD-ROM
The Instructor's Resource CD-ROM that is available contains:
Companion Website www.prenhall.com/phtestprep
For both students and instructors, the Companion Website includes ancillary material to accompany the Prentice Hall Test Prep Series. Instructors will find the data and solution files, PowerPoint slides, and Instructor's Manuals for each application.
Prentice Hall has also formed close alliances with each of the leading online platform providers: WebCT, Blackboard, and our own Pearson CourseCompass.
CourseCompass is a dynamic, interactive online course-management tool powered exclusively for Pearson Education by Blackboard. This exciting product enables you to teach market-leading Pearson Education content in an easy-to-use, customizable format.
Prentice Hall's abundant online content, combined with Blackboard's popular tools and interface, result in robust Web-based courses that are easy to implement, manage, and use—taking your courses to new heights in student interaction and learning.
Course-management tools within WebCT include page tracking, progress tracking, class and student management, gradebook, communication, calendar, reporting tools, and more. GOLD LEVEL CUSTOMER SUPPORT, available exclusively to adopters of Prentice Hall courses, is provided free-of-charge upon adoption and provides you with priority assistance, training discounts, and dedicated technical support.
Train & Assess IT www.prenhall.com/phit
Prentice Hall offers Performance Based Training and Assessment in one product: Train & Assess IT The training component offers computer-based training that a student can use to preview, learn, and review Microsoft Office applications and computer literacy skills. Web- or CD-ROM delivered, the training component offers interactive, multimedia, computer-based training to augment classroom learning. Built-in prescriptive testing suggests a study path based not only on student test results but also on the specific textbook chosen for the course.
The assessment component offers computer-based testing that shares the same user interface and is used to evaluate a student's knowledge about specific topics in Word, Excel, Access, PowerPoint, Windows, Outlook, and the Internet. It does this in a task-oriented environment to demonstrate proficiency as well as comprehension of the topics by the students.