Access 2010

To Download the Student Exercise Files to your Flash Drive, visit the website by clicking here

*Note: Your instructor most likely already did this for you in class.

Lesson 8: Accessing Raritan Clinic East

By the end of the lesson, students will be able to:

• Define Access Databases
• Identify Elements of the Access Window
• Use Database Templates
• Create a Blank Database
• Design a Database
• Use the Navigation Pane
• Create Tables in Datasheet View
• Work with Tables
• Identify Field Data Types
• Navigate Tables & Enter Data
• Preview & Print Data
• Check Data Accuracy
• Close a Database & Exit Access

Office Essentials 2010

When you are completed with all 8 lessons in the "Silver Book" (Welcome to Microsoft Office 2010), you will complete JUST the Access section of the "Orange Book" (Office Essentials 2010).

Lesson 21: Exploring Access 2010

By the end of the lesson, students will be able to:

• Understand what a database is
• Launch Access 2010
• Create a Blank Database
• Design a Database
• Use the Navigation Pase
• Create Tables in Datasheet View
  • Work with Tables
  • Identify Table Guidelines
  • Identify Field Data Types
  • Navigate Tables & Enter Data
  • Work with Tabs & Close Database Objects
• Preview & Print Data
• Close & Exit Access

Lesson 22: Building a Database

By the end of the lesson, students will be able to:

• Design a Database
• Plan a Database Design
• Open a Database
  • Enable Macro Controlling Database Security
• Save a Database as a New File
  • Use the Save As Command
  • Open Existing Database Objects
  • Navigate Records in a Table Datasheet
• Create Database Objects
  • Forms
  • Reports
• Create Tables Using Design View
• Manage Database Objects