GO! with Microsoft Access 2010 Introductory

GO! with Microsoft Access 2010 Intro<br>Table of Contents <p>Common Features Chapter 1 Using the Common Features of Office 2010<br>Scenario: Oceana Palm Grill<br><u>Project 1A: Menu Plan</u></p> <p>Objective 1 &nbsp;&nbsp; Use Windows Explorer to Locate Files and Folder<br>Activity 1.01 &nbsp; Using Windows Explorer to Locate Files and Folders</p> <p>Objective 2 &nbsp;&nbsp; Locate and Start a Microsoft Office 2010 Program<br>Activity 1.02 &nbsp; Locating and Starting a Microsoft Office 2010 Program</p> <p>Objective 3 &nbsp;&nbsp; Enter and Edit Text in an Office Program<br>Activity 1.03 &nbsp; Entering and Editing Text in an Office Program</p> <p>Objective 4 &nbsp;&nbsp; Perform Commands From a Dialog Box<br>Activity 1.04 &nbsp; Performing Commands From a Dialog Box</p> <p>Objective 5 &nbsp;&nbsp; Create a Folder, Save a File, and Close a Program<br>Activity 1.05 Creating a Folder, Saving a File, and Closing a Program</p> <p>Objective 6 &nbsp;&nbsp; Print a File<br>Activity 1.06 Printing a File</p> <p><u>Project 1B: Memo</u></p> <p>Objective 7 &nbsp;&nbsp; Open an Existing File and Save it With a New Name<br>Activity 1.07 Opening an Existing File and Saving it With a New Name</p> <p>Objective 8 &nbsp;&nbsp; Explore Application Options<br>Activity 1.08 Viewing Application Options</p> <p>Objective 9 &nbsp;&nbsp; Perform Commands from the Ribbon<br>Activity 1.09 Performing Commands from the Ribbon<br>Activity 1.10 Minimizing and Using the Keyboard to Control the Ribbon</p> <p>Objective 10&nbsp;&nbsp; Apply Formatting in Office Programs<br>Activity 1.11 &nbsp; Formatting and Viewing Pages<br>Activity 1.12 Formatting Text<br>Activity 1.13 &nbsp; Using the Office Clipboard to Cut, Copy, and Paste</p> <p>Objective 11&nbsp;&nbsp; Use the Microsoft Office 2010 Help System<br>Activity 1.14 Using the Microsoft Office 2010 Help System in Excel</p> <p>Objective 12&nbsp;&nbsp; Compress Files<br>Activity 1.15 Compressing Files</p> <p>Chapter 1 Getting Started with Access Databases<br>Scenario: Capital Cities Community College<br><u>Project 1A: Contact Information</u></p> <p>Objective 1: Identify Good Database Design<br>Activity 1.01 Using Good Design Techniques to Plan a Database</p> <p>Objective 2: Create a Table and Define Fields in a New Blank Database<br>Activity 1.02 Starting with a New Blank Database<br>Activity 1.03 Creating Fields in a Table<br>Activity 1.04 Renaming Field in a Table<br>Activity 1.05 Adding a Record to a Table<br>Activity 1.06 Assigning the Data Type of a Field in Datasheet View<br>Activity 1.07 Adding Additional Records to a Table<br>Activity 1.08 Importing Data from an Excel Workbook to an Existing Access Table</p> <p>Objective 3: Add and Change the Structure of Tables<br>Activity 1.09 Deleting a Table Field in Design View<br>Activity 1.10 Modifying a Field Size and Description in Design View<br>Activity 1.11 Setting a Primary Key and Saving a Table<br>Activity 1.12 Adding a Second Table to a Database by Importing an Excel Spreadsheet<br>Activity 1.13 Adjusting Column Widths<br>Activity 1.14 Printing a Table</p> <p>Objective 4: Create and Use a Query, a Form, and a Report<br>Activity 1.15 Using the Simple Query Wizard to Create a Query<br>Activity 1.16 Creating a Form<br>Activity 1.17 Creating, Modifying, and Printing a Report</p> <p>Objective 5: Save, Close, and Change the Properties of a Database<br>Activity 1.18 Changing Database Properties<br>Activity 1.19 Closing and Saving a Database<br><br></p> <p><u>Project 1B: Student Workshops</u></p> <p>Objective 6: Create a Database Using a Template<br>Activity 1.20 Creating a New Database Using a Template<br>Activity 1.21 Building a Table by Entering Records in a Multiple Items Form</p> <p>Objective 7: Organize Database Objects in the Navigation Pane<br>A</p>