- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
For introductory computer courses on Microsoft Access 2010 or courses in computer concepts with a lab component on Access.Teach the course YOU want in LESS TIME! The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation. This approach is based on clearly defined projects for students and a one-of-a-kind supplements package for instructors.
Contents
GO! with Microsoft Access 2010 IntroTable of Contents Common Features Chapter 1 Using the Common Features of Office 2010Scenario: Oceana Palm GrillProject 1A: Menu PlanObjective 1 Use Windows Explorer to Locate Files and FolderActivity 1.01 Using Windows Explorer to Locate Files and FoldersObjective 2 Locate and Start a Microsoft Office 2010 ProgramActivity 1.02 Locating and Starting a Microsoft Office 2010 ProgramObjective 3 Enter and Edit Text in an Office ProgramActivity 1.03 Entering and Editing Text in an Office ProgramObjective 4 Perform Commands From a Dialog BoxActivity 1.04 Performing Commands From a Dialog BoxObjective 5 Create a Folder, Save a File, and Close a ProgramActivity 1.05 Creating a Folder, Saving a File, and Closing a ProgramObjective 6 Print a FileActivity 1.06 Printing a FileProject 1B: MemoObjective 7 Open an Existing File and Save it With a New NameActivity 1.07 Opening an Existing File and Saving it With a New NameObjective 8 Explore Application OptionsActivity 1.08 Viewing Application OptionsObjective 9 Perform Commands from the RibbonActivity 1.09 Performing Commands from the RibbonActivity 1.10 Minimizing and Using the Keyboard to Control the RibbonObjective 10 Apply Formatting in Office ProgramsActivity 1.11 Formatting and Viewing PagesActivity 1.12 Formatting TextActivity 1.13 Using the Office Clipboard to Cut, Copy, and PasteObjective 11 Use the Microsoft Office 2010 Help SystemActivity 1.14 Using the Microsoft Office 2010 Help System in ExcelObjective 12 Compress FilesActivity 1.15 Compressing FilesChapter 1 Getting Started with Access DatabasesScenario: Capital Cities Community CollegeProject 1A: Contact InformationObjective 1: Identify Good Database DesignActivity 1.01 Using Good Design Techniques to Plan a DatabaseObjective 2: Create a Table and Define Fields in a New Blank DatabaseActivity 1.02 Starting with a New Blank DatabaseActivity 1.03 Creating Fields in a TableActivity 1.04 Renaming Field in a TableActivity 1.05 Adding a Record to a TableActivity 1.06 Assigning the Data Type of a Field in Datasheet ViewActivity 1.07 Adding Additional Records to a TableActivity 1.08 Importing Data from an Excel Workbook to an Existing Access TableObjective 3: Add and Change the Structure of TablesActivity 1.09 Deleting a Table Field in Design ViewActivity 1.10 Modifying a Field Size and Description in Design ViewActivity 1.11 Setting a Primary Key and Saving a TableActivity 1.12 Adding a Second Table to a Database by Importing an Excel SpreadsheetActivity 1.13 Adjusting Column WidthsActivity 1.14 Printing a TableObjective 4: Create and Use a Query, a Form, and a ReportActivity 1.15 Using the Simple Query Wizard to Create a QueryActivity 1.16 Creating a FormActivity 1.17 Creating, Modifying, and Printing a ReportObjective 5: Save, Close, and Change the Properties of a DatabaseActivity 1.18 Changing Database PropertiesActivity 1.19 Closing and Saving a DatabaseProject 1B: Student WorkshopsObjective 6: Create a Database Using a TemplateActivity 1.20 Creating a New Database Using a TemplateActivity 1.21 Building a Table by Entering Records in a Multiple Items FormObjective 7: Organize Database Objects in the Navigation PaneActivity 1.22 Organizing Database Objects in the Navigation PaneObjective 8: Create a New Table in a Database Created with a TemplateActivity 1.23 Creating a New Table and Changing Its DesignObjective 9: View a Report and Print a Table in a Database Created with a TemplateActivity 1.24 Viewing a ReportActivity 1.25 Printing a TableChapter 2 Sort and Query a DatabaseScenario: Capital Cities Community CollegeProject 2A: Instructors and CoursesObjective 1: Open an Existing DatabaseActivity 2.01 Opening and Renaming an Existing DatabaseActivity 2.02 Resolving Security Alerts and Renaming TablesObjective 2: Create Table RelationshipsActivity 2.03 Creating Table Relationships and Enforcing Referential IntegrityActivity 2.04 Printing a Relationship ReportObjective 3: Sort Records in a TableActivity 2.05 Sorting Records in a Table in Ascending or Descending OrderActivity 2.06 Sorting Records in a Table on Multiple FieldsObjective 4: Create a Query in Design ViewActivity 2.07 Creating a New Select Query in Design ViewActivity 2.08 Running, Saving, Printing, and Closing a QueryObjective 5: Create a New Query from an Existing QueryActivity 2.09 Creating a New Query from an Existing QueryObjective 6: Sort Query ResultsActivity 2.10 Sorting Query ResultsObjective 7: Specify Criteria in a QueryActivity 2.11 Specifying Text Criteria in a QueryActivity 2.12 Specifying Criteria Using a Field Not Displayed in the Query ResultsActivity 2.13 Using Is Null Criteria to Find Empty FieldsProject 2B: Athletic ScholarshipsObjective 8: Specify Numeric Criteria in a QueryActivity 2.14 Opening an Existing Database and Importing a SpreadsheetActivity 2.15 Creating Table RelationshipsActivity 2.16 Specifying Numeric Criteria in a QueryActivity 2.17 Using Comparison OperatorsActivity 2.18 Using the Between . . . And Comparison OperatorObjective 9: Use Compound CriteriaActivity 2.19 Using AND Criteria in a QueryActivity 2.20 Using OR Criteria in a QueryObjective 10: Create a Query Based on More Than One TableActivity 2.21 Creating a Query Based on More Than One TableObjective 11: Use Wildcards in a QueryActivity 2.22 Using a Wildcard in a QueryObjective 12: Use Calculated Fields in a QueryActivity 2.23 Using Calculated Fields in a QueryObjective 13: Calculate Statistics and Group Data in a QueryActivity 2.24 Using the MIN, MAX, AVG, and SUM Functions in a QueryActivity 2.25 Grouping Data in a QueryChapter 3 Forms, Filters, and ReportsScenario: Capital Cities Community CollegeProject 3A: Students and MajorsObjective 1: Create and Use a Form to Add and Delete RecordsActivity 3.01 Creating a FormActivity 3.02 Adding Records to a Table by Using a FormActivity 3.03 Deleting Records from a Table by Using a FormActivity 3.04 Printing a FormObjective 2: Create a Form by Using the Form WizardActivity 3.05 Creating a Form by Using the Form WizardObjective 3: Modify a Form in Design View and in Layout ViewActivity 3.06 Modifying a Form in Design ViewActivity 3.07 Adding, Resizing, and Moving Controls in Layout ViewActivity 3.08 Formatting and Aligning Controls in Layout ViewObjective 4: Filter RecordsActivity 3.09 Filtering Data by Selection on One FieldActivity 3.10 Using Filter By FormProject 3B: Job OpeningsObjective 5: Create a Report by Using the Report ToolActivity 3.11 Creating a Report by Using the Report ToolActivity 3.12 Modifying a Report in Layout ViewObjective 6: Create Reports by Using the Blank Report Tool or the Report WizardActivity 3.13 Creating a Report by Using the Blank Report ToolActivity 3.14 Creating a Report by Using the Report WizardObjective 7: Modify the Design of a Report Activity 3.15 Modifying a Report in Layout ViewActivity 3.16 Modifying a Report in Design ViewObjective 8: Keep Data Together in a Printed ReportActivity 3.17 Keeping Data Together and Printing a ReportChapter 4 Enhancing TablesScenario: City of Westland PlainsProject 4A Maneuver Data and Enforce Data IntegrityObjective 1 Manage Existing TablesActivity 4.01 Backing Up a DatabaseActivity 4.02 Adding File Locations to Trusted LocationsActivity 4.03 Copying a Table and Modifying the StructureActivity 4.04 Appending Records to a TableActivity 4.05 Splitting a Table into Two TablesActivity 4.06 Appending Records from Another Database Objective 2 Modify Existing TablesActivity 4.07 Finding and Deleting Records Activity 4.08 Finding and Modifying Records Activity 4.09 Adding and Moving Fields in Design View and Datasheet ViewActivity 4.10 Checking Spelling Objective 3 Create and Modify Table RelationshipsActivity 4.11 Creating Table Relationships and Testing Referential Integrity Activity 4.12 Setting and Testing Cascade OptionsProject 4B Format Tables and Validate Data EntryObjective 4 Create a table in design viewActivity 4.13 Creating a Table in Design ViewObjective 5 Change Data typesActivity 4.14 Changing Data Types Objective 6 Create a Lookup Field Activity 4.15 Creating a Lookup Field Based on a List of ValuesActivity 4.16 Creating a Lookup Field Based on Data in Another TableObjective 7 Set Field PropertiesActivity 4.17 Creating an Input Mask using the Input Mask WizardActivity 4.18 Creating an Input Mask using the Input Mask Properties BoxActivity 4.19 Specifying a Required FieldActivity 4.20 Setting Default Values for FieldsActivity 4.21 Indexing Fields in a TableObjective 8 Create Data Validation Rules and Validation TextActivity 4.22 Creating Data Validation Rules and Validation TextActivity 4.23 Testing Table Design and Field PropertiesObjective 9 Attach Files to RecordsActivity 4.24 Attaching a Word Document to a RecordChapter 5 Enhancing QueriesScenario: Board Anywhere Surf and Snowboard ShopProject 5A Create Special-Purpose QueriesObjective 1 Create Calculated Fields in a QueryActivity 5.01 Creating a Calculated Field Based on Two Existing FieldsActivity 5.02 Creating a Calculated Field Based on One Existing Field and a NumberObjective 2 Use Aggregate Functions in a QueryActivity 5.03 Adding a Total Row to a QueryActivity 5.04 Creating a Totals QueryObjective 3 Create a Crosstab QueryActivity 5.05 Creating a Select Query as the Source for a Crosstab QueryActivity 5.06 Creating a Crosstab QueryObjective 4 Find Duplicate and Unmatched RecordsActivity 5.07 Finding Duplicate RecordsActivity 5.08 Finding Unmatched RecordsObjective 5 Create a Parameter QueryActivity 5.09 Creating a Parameter Query Using One CriteriaActivity 5.10 Creating a Parameter Query Using Multiple CriteriaProject 5B Create Action Queries and Modify Join TypesObjective 6 Create a Make Table QueryActivity 5.11 Creating a Select QueryActivity 5.12 Converting a Select Query to a Make Table QueryObjective 7 Create an Append QueryActivity 5.13 Creating an Append Query for a Table in the Current DatabaseActivity 5.14 Creating an Append Query for a Table in Another DatabaseObjective 8 Create a Delete QueryActivity 5.15 Creating a Delete QueryObjective 9 Create an Update QueryActivity 5.16 Creating an Update QueryActivity 5.17 Creating an Update Query with an ExpressionObjective 10 Modify the Join TypeActivity 5.18 Viewing the Results of a Query Using an Inner JoinActivity 5.19 Changing the Join Type to an Outer JoinChapter 6 Customizing Forms and ReportsScenario: Wild Islands BreezeProject 6A Customize FormsObjective 1 Create a Form in Design ViewActivity 6.01 Creating a Form in Design ViewActivity 6.02 Adding Sections to the FormObjective 2 Change and Add ControlsActivity 6.03 Changing Controls on a FormActivity 6.04 Adding Controls to a FormObjective 3 Format a FormActivity 6.05 Adding a Background ColorActivity 6.06 Adding a Background Picture to a FormActivity 6.07 Modifying the Borders of ControlsObjective 4 Make a Form User FriendlyActivity 6.08 Adding a Message to the Status BarActivity 6.09 Creating Custom ControlTipsActivity 6.10 Changing the Tab OrderProject 6B Customize ReportsObjective 5 Create a Report Based on a Query Using a WizardActivity 6.11 Creating a Report Using a WizardActivity 6.12 Modifying a Report Created Using a WizardObjective 6 Create a Report in Design ViewActivity 6.13 Creating a Report in Design viewActivity 6.14 Modifying the Sections of a ReportObjective 7 Add Controls to a ReportActivity 6.15 Adding Label and Text Box Controls to a ReportActivity 6.16 Adding an Image Control and a Line Control to a ReportObjective 8 Group, Sort, and Total Records in Design ViewActivity 6.17 Adding a Grouping and Sort Level to a ReportActivity 6.18 Adding Calculated Controls to a Report
