|
![]() |
|||
|
||||
OverviewTimothy and Linda O'Leary and the Computer Information Technology Team at McGraw-Hill Higher Education offer your students a fully integrated learning program with time-tested quality and reliability. Office 2010: A Case Approach offers running case study throughout the text to help students understand the material in a consistent, relevant environment. Through this theme of “Making Office Relevant,” this text helps students understand why they need this course and these skills. Student success is assured through clear step-by-step instruction, plentiful screen captures and conceptual explanations. Each Lab, designed to be covered in 1 hour of class time, combines conceptual coverage with detailed software-specific instructions. Each Lab opens with a running case study that highlights real-world applications of each software program and leads students from problem to solution. The O'Leary Series helps students learn specific applications skills along with those that cross all Office applications, which is especially important in mastering this version of Office. The O'Leary Series also correlates with SimNet Online, our online training and assessment program for Office 2010. Full Product DetailsAuthor: Timothy O'Leary , Linda O'LearyPublisher: McGraw-Hill Education - Europe Imprint: McGraw-Hill Professional Dimensions: Width: 20.10cm , Height: 2.50cm , Length: 28.50cm Weight: 1.331kg ISBN: 9780077331351ISBN 10: 0077331354 Pages: 688 Publication Date: 16 December 2011 Audience: General/trade , General Format: Paperback Publisher's Status: Out of Print Availability: Awaiting stock ![]() Table of ContentsAccess 2010 Complete Lab 1 Creating a Database Designing a New Database Creating a New Database Creating a Table Modifying Field Properties Entering and Editing Records Changing Column Width Navigating Among Records Deleting Records Creating a Table in Design View Creating Relationships Setting Database and Object Properties Previewing and Printing a Table Closing and Opening a Database Exiting Access Lab 2 Modifying and Filtering a Table and Creating a Form Customising Fields Hiding and Redisplaying Fields Creating a Lookup Field Searching, Finding and Replacing Data Sorting Records Formatting the Datasheet Filtering a Table Creating a Simple Form Modifying a Form Using a Form Organising the Navigation Pane Previewing and Printing a Form Identiying Object Dependencies Lab 3 Querying Tables and Creating Reports Refining the Database Design Defining and Modifying Relationships Creating a Query Displaying a Totals Row Creating Reports Preparing Reports for Printing Compacting and Backing Up the Database Working Together 1 Exporting Data Exporting Data Lab 4 Importing and Querying Tables Importing Data Controlling Field Input Using Action Queries Using Memo Fields Adding a Multivalued Field Using Calculations in Tables and Queries Creating a Top-Values Query Creating a Crosstab Query Lab 5 Creating Custom Forms Creating a Split Form Creating a Datasheet Form and Subform Creating a Form for Multiple Tables Changing Control Properties Adding Label Controls Enhancing Form Controls Aligning and Spacing Controls Adding Subforms Setting Tab Order Using Command Buttons Creating Page Headers and Footers Previewing a Form Deleting a Form Lab 6 Creating Custom Reports, Charts, Pivot Charts and Mailing Lables Creating a Grouped Report Using the Report Wizard to Create a Grouped Report Customising the Report Layout Enhancing the Report Changing the Record Source Using Calculated Controls in a Report Applying Conditional Formatting Printing a Grouped Report Creating a Chart in a Report Using Pivot Chart View Creating Mailing Labels Creating a Startup Display Form Securing a Database Working Together 2: Linking and Splitting Databases Linking to External Data Sources Splitting a DatabaseReviewsAuthor InformationTim O'Leary has taught courses at Stark Technical College in Canton, Ohio, and at Rochester Institute of Technology in upstate New York. He currently is a professor emeritus at Arizona State University. Linda O'Leary offered her expertise at Arizona State University for several years as an academic advisor. She also presented and developed materials for major corporations, such as Motorola, Intel, Honeywell, and AT&T, as well as various community colleges in the Phoenix area. Tab Content 6Author Website:Countries AvailableAll regions |