Cantitate/Preț
Produs

GO! with Microsoft Access 2007, Volume 1

Autor Shelley Gaskin, Suzanne Marks, Kris Townsend
en Limba Engleză Mixed media product – 25 iul 2007
The primary goal of this "GO Series "title is to teach Microsoft Access 2007 quickly and easily, with an approach that is based on clearly-defined projects. A key feature of the book is the use of Microsoft procedural syntax: steps begin with "where" the action is to take place, followed by the action itself. The instruction is error-free, clearly written, and logically arranged. This book provides users with the skills to solve business problems using the computer as a tool. "GO " s project-based approach clusters the learning objectives around the projects rather than around software features. Teaches students to solve real problems as they practice and learn the features. "GO with Microsoft Access 2007, Volume 1, 1/e "contains a CD-ROM. This edition covers the following topics: getting started with Access databases and tables; sorting and querying databases; forms, filters and reports; designing and building a rational database; automating data entry; advanced reports. An efficient and handy guide for anyone interested in a comprehensive introduction to Microsoft Access 2007. "
Citește tot Restrânge

Preț: 53177 lei

Preț vechi: 65651 lei
-19% Nou

Puncte Express: 798

Preț estimativ în valută:
10180 10470$ 8445£

Carte indisponibilă temporar

Doresc să fiu notificat când acest titlu va fi disponibil:

Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9780135130407
ISBN-10: 0135130409
Pagini: 532
Dimensiuni: 226 x 272 x 25 mm
Greutate: 1.19 kg
Ediția:1
Editura: Pearson Education
Colecția Prentice Hall
Locul publicării:Upper Saddle River, United States

Descriere

For Introductory Computer courses in Microsoft Office 2007 or courses in Computer Concepts with a lab component for Microsoft Office 2007 applications.
 
Teach the course YOU want in LESS TIME! The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly-defined projects for students and a one of a kind supplements package.

Cuprins

Chapter 1 Getting Started with Access Databases and Tables     PROJECT 1A Create a New Blank Database
        Objective 1 Start Access and Create a New Blank Database
            Activity 1.1 Starting Access, Creating and Naming a Folder, and Creating a Database from a New Blank Database
        Objective 2 Add Records to a Table
            Activity 1.2 Adding Records to a Table
        Objective 3 Rename Table Fields in Datasheet View
            Activity 1.3 Renaming the Fields In a Table in Datasheet View
            Activity 1.4 Changing the Data Type of a Field in Datasheet View
        Objective 4 Modify the Design of a Table
            Activity 1.5 Deleting a Field in Design View
            Activity 1.6 Modifying a Field Size and Description in Design View
            Activity 1.7 Setting a Primary Key and Saving a Table
        Objective 5 Add a Second Table to a Database
            Activity 1.8 Adding a Second Table to a Database
            Activity 1.9 Adding Records to a Second Table
        Objective 6 Print a Table
            Activity 1.10 Adjusting Column Widths and Printing a Table
        Objective 7 Create and Use a Query
            Activity 1.11 Using the Simple Query Wizard to Create a Query
        Objective 8 Create and Use a Form
            Activity 1.12 Creating a Form
        Objective 9 Create and Print a Report
            Activity 1.13 Creating and Printing a Report
        Objective 10 Close and Save a Database
            Activity 1.14 Closing and Saving a Database
     PROJECT 1B Create a Database from a Template
        Objective 11 Create a Database Using a Template
            Activity 1.15 Creating a New Database Using a Template
            Activity 1.16 Building a Table by Entering Records in a Multiple Items Form
        Objective 12 Organize Database Objects in the Navigation Pane
            Activity 1.17 Organizing Database Objects in the Navigation Pane
        Objective 13 Create a New Table in a Database Created with a Template
            Activity 1.18 Creating a New Table and Changing Its Design
        Objective 14 View a Report and Print a Table in a Database Created with a Template
            Activity 1.19 Viewing a Report
            Activity 1.20 Printing a Table
        Objective 15 Use the Access Help System
            Activity 1.21 Using the Access Help System
 
Chapter 2 Sort and Query a Database     PROJECT 2A Sort and Query a Database
        Objective 1 Open an Existing Database
            Activity 2.1 Renaming and Opening an Existing Database
            Activity 2.2 Opening an Existing Database and Resolving Security Alerts
        Objective 2 Create Table Relationships
            Activity 2.3 Creating Table Relationships and Enforcing Referential Integrity
            Activity 2.4 Printing a Relationship Report
        Objective 3 Sort Records in a Table
            Activity 2.5 Sorting Records in a Table in Ascending or Descending Order
            Activity 2.6 Sorting Records in a Table on Multiple Fields
        Objective 4 Create a Query in Design View
            Activity 2.7 Creating a New Select Query in Design View
            Activity 2.8 Running, Saving, Printing, and Closing a Query
        Objective 5 Create a New Query from an Existing Query
            Activity 2.9 Creating a New Query From an Existing Query
        Objective 6 Sort Query Results
            Activity 2.10 Sorting Query Results
        Objective 7 Specify Criteria in a Query
            Activity 2.11 Specifying Text Criteria in a Query
            Activity 2.12 Specifying Criteria Using a Field Not Displayed in the Query Result
            Activity 2.13 Using Is Null Criteria to Find Empty Fields
     PROJECT 2B Create a Database Table from an Excel Spreadsheet and Create Complex Queries
        Objective 8 Create a New Table by Importing an Excel Spreadsheet
            Activity 2.14 Opening an Existing Database and Preparing to Import an Excel Spreadsheet
            Activity 2.15 Creating a New Table by Importing an Excel Spreadsheet
        Objective 9 Specify Numeric Criteria in a Query
            Activity 2.16 Specifying Numeric Criteria in a Query
            Activity 2.17 Using Comparison Operators
            Activity 2.18 Using the Between. . . And Comparison Operator
        Objective 10 Use Compound Criteria
            Activity 2.19 Using AND Criteria in a Query
            Activity 2.20 Using OR Criteria in a Query
        Objective 11 Create a Query Based on More Than One Table
            Activity 2.21 Creating a Query Based on More Than One Table
        Objective 12 Use Wildcards in a Query
            Activity 2.22 Using a Wildcard in a Query
        Objective 13 Use Calculated Fields in a Query
            Activity 2.23 Using Calculated Fields in a Query 
       Objective 14 Group Data and Calculate Statistics in a Query
            Activity 2.24 Using the MIN, MAX, AVG and SUM Functions in a Query
            Activity 2.25 Grouping Data in a Query
 
Chapter 3 Forms, Filters, and Reports
    PROJECT 3A Create Forms to Enter and Display Data in a Database
        Objective 1 Create a Form
            Activity 3.1 Creating a Form
        Objective 2 Use a Form to Add and Delete Records
            Activity 3.2 Adding Records to a Table by Using a Form
            Activity 3.3 Deleting Records from a Table by Using a Form
            Activity 3.4 Printing a Form
        Objective 3 Create a Form by Using the Form Wizard
            Activity 3.5 Creating a Form Using the Form Wizard
        Objective 4 Modify a Form in Design View and in Layout View
            Activity 3.6 Modifying a Form in Design View
            Activity 3.7 Adding, Resizing, and Moving Controls in Layout View
            Activity 3.8 Formatting and Aligning Controls in Layout View
        Objective 5 Filter Records
            Activity 3.9 Filtering Data by Selection on One Field
            Activity 3.10 Using Filter by Form
     PROJECT 3B Create Reports to Display Database Information
        Objective 6 Create a Report by Using the Report Tool
            Activity 3.11 Creating and Modifying a Report by Using the Report Tool and Layout View
        Objective 7 Create a Report by Using the Blank Report Tool
            Activity 3.12 Creating a Report by Using the Blank Report Tool
        Objective 8 Create a Report by Using the Report Wizard
            Activity 3.13 Creating a Report by Using the Report Wizard
        Objective 9 Modify the Design of a Report
            Activity 3.14 Modifying a Report in Layout View
            Activity 3.15 Modifying a Report in Design View
        Objective 10 Print a Report and Keep Data Together
            Activity 3.16 Keeping Data Together and Printing a Report
 
Chapter 4 Designing and Building a Relational Database
    PROJECT 4A Classes
        Objective 1: Customize Table Fields
            Activity 4.1 Adding Captions to Fields
            Activity 4.2 Creating a Yes/No Field and Set a Default Value
            Activity 4.3 Creating and populating an Attachment Field
        Objective 2: Structure Data Input
            Activity 4.4 Creating a Lookup Field from a Typed List
            Activity 4.5 Creating a Lookup Field from a Table
            Activity 4.6 Creating an Input Mask Using a Wizard
            Activity 4.7 Creating a Custom Input Mask
        Objective 3: Validate Data Input
            Activity 4.8 Classifying Fields as Required
            Activity 4.9 Assigning Default Values to Fields
            Activity 4.10 Setting Validation Properties
            Activity 4.11 Testing a Validation System in a For
     PROJECT 4B Registration
        Objective 4: Create Indexes and Change Sort Order
            Activity 4.12 Creating an Index to Optimize Sorting
            Activity 4.13 Creating an Index to Maintain Data Integrity
        Objective 5: Create Relationships between Tables
            Activity 4.14 Establishing a One-to-One Relationship
            Activity 4.15 Working with Related Tables
            Activity 4.16 Creating a One-to-Many Relationship
            Activity 4.17 Creating a Many-to-Many Relationship
        Objective 6: Create Forms and Reports with Related Tables
            Activity 4.18 Creating a Relationships Report
            Activity 4.19 Creating a Query Using Related Tables
            Activity 4.20 Creating a Form Using Related Tables
 
Chapter 5 Automate Data Entry with Forms     PROJECT 5A - Sales Force
        Objective 1: Create Forms with Subforms
            Activity 5.1 Creating One-to-Many Relationships
            Activity 5.2 Creating a Form and Subform using the Form Wizard
            Activity 5.3 Creating a Form Using the Blank Form Tool
            Activity 5.4 Adding a Subform using the Subform Control
            Activity 5.5 Formatting a Form and Subform in Layout View
        Objective 2: Create Forms with Special Views
            Activity 5.6 Creating a Split Form
            Activity 5.7 Creating a Multiple Items Form
            Activity 5.8 Creating a From with Tabbed Pages
     PROJECT 5B - Opportunities
        Objective 4: Build a Form in Design View
            Activity 5.9 Building a Form in Design View
            Activity 5.10 Aligning Controls Using Arrange Tools
            Activity 5.11 Creating a Combo Box with Data from a Related Table
            Activity 5.12 Adding a List Box and a Combo Box
            Activity 5.13 Adding a Calculated Control
            Activity 5.14 Adding an Option Button Group
            Activity 5.15 Adding a Command Button
            Activity 5.16 Inserting a Chart
        Objective 5: Use Advanced Formatting Tools
            Activity 5.17 Applying Conditional Formatting
            Activity 5.18 Applying Rich Text Formatting to Data
 
Chapter 6 Customize Data Output with Reports (The Petite Book)
    PROJECT 6A Orders
        Objective 1: Build Reports Based on Queries
            Activity 6.1 Building a Select Query
            Activity 6.2 Building a report Based on a Select Query
            Activity 6.3 Adding Line Numbers and a Record Count
            Activity 6.4 Optimizing a Report for Black and White Printing
            Activity 6.5 Building and Modifying Queries Using Copy and Paste
            Activity 6.6 Building and Modifying Reports Using Copy and Paste
        Objective 2: Export a Report and Create a Labels Report
            Activity 6.7 Exporting Reports as Web Pages
            Activity 6.8 Creating an Aggregate Function Query
            Activity 6.9 Creating a Labels Report
    PROJECT 6B Sales
        Objective 4: Create a Subreport Using Design Tools
            Activity 6.10 Creating a Report Using Report Design
            Activity 6.11 Creating a Subreport using the SubReport Wizard
            Activity 6.12 Formatting a Report and Subreport
            Activity 6.13 Adding Calculated Controls
        Objective 5: Summarize Report Data
            Activity 6.14 Creating a Summary Report
            Activity 6.15 Inserting a Chart
            Activity 6.16 Editing a Chart
            Activity 6.17 Filtering and Printing a Report
        Objective 6: Create a Report with an Interactive Filter
            Activity 6.18 Building a Daily Sales Report
            Activity 6.19 Creating a Filter That Asks for User Input
 

Notă biografică

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois   University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.

Caracteristici noi

Sequential chapter numbering: In addition to sequential page numbering GO! chapters are now numbered 1 through 22 instead of Word Chapter 1, Excel Chapter 1, etc. This makes the text even easier to navigate.
 
Project-Based Approach: GO!’s project-based approach clusters the learning objectives around the projects rather than around software features. Teaches students to solve real problems as they practice and learn the features.
  • Texts are now organized by objectives and student learning outcomes and there are always two instructional projects per chapter
“There’s More You Can Do” feature
 
·        Try It! exercises teach students additional skills or new office features that are not  included within the instructional portion of the chapter.
 
Workshop feature for Excel and PowerPoint chapters help students better understand the uses of these applications.
 
·        The Excel Workshop teaches formulas and other basic math skills and a separate PowerPoint Workshop teaches essential presentation skills
 
End-of-Chapter organized into two sections: Content–Based Assessments and Outcomes-Based Assessments.
  • Now your content-based or defined-solution assessments that can be graded with a solution file or GO! Highlighted Overlays are separated from your non-defined solution assessments that can be graded with the GO! Rubric. 
End-of-Chapter assessments provide even more options for quizzing and review.
 
·        GO! with Help teaches the student to work with the Help feature in Office as a project.
·        Group Business Running Case is a project that runs through entire textbook and designed to be assigned to group of students.
 
Audio/Video Expert Demonstration Documents (A/V-EDDs) are multimedia versions of the GO! Expert Demonstration Documents that provide an alternative scripted lecture scenario of each chapter project in the text.
 
·        Provided in Flash file format for easy delivery, these are ideal for online, lecture reinforcement, and lecture replacement.
 
Assignment Tags for Problem Solving assessments provide task-specific scoring checklists that save time in grading open-ended assessments (assessments without defined solutions).
 
GO!-Specific instructional content in the new myitlab assessment and training software for Office 2007!
 
  • New MyITLab training scenarios deliver the exact same step-by-step content as the projects in the GO! textbook while the assessment provides two additional scenarios of each GO! project.  

Textul de pe ultima copertă

The primary goal of this "GO! Series "title is to teach Microsoft Access 2007 quickly and easily, with an approach that is based on clearly-defined projects. A key feature of the book is the use of Microsoft procedural syntax: steps begin with "where" the action is to take place, followed by the action itself. The instruction is error-free, clearly written, and logically arranged. This book provides users with the skills to solve business problems using the computer as a tool. "GO!"'s project-based approach clusters the learning objectives around the projects rather than around software features. Teaches students to solve real problems as they practice and learn the features. "GO! with Microsoft Access 2007, Volume 1, 1/e "contains a CD-ROM. This edition covers the following topics: getting started with Access databases and tables; sorting and querying databases; forms, filters and reports; designing and building a rational database; automating data entry; advanced reports. An efficient and handy guide for anyone interested in a comprehensive introduction to Microsoft Access 2007.