|
ms201-ver12.7-sg
Microsoft Office Access 2007 - Level 1 (1 day)
Description
This Microsoft Office courseware training guide book will teach students to use Microsoft Office Access 2007 to manage, manipulate, and print reports on your data. During this course, you will understand basic database theory and begin creating a simple Microsoft Office Access 2007 database.
PrerequisitesStudents should be familiar with:
• Using personal computers and have used a mouse and keyboard
• The Windows environment and be able to use Windows to manage information on your computer.
• Launching and closing programs; navigate to information stored on the computer; and manage files and folders.
Supplemental Instructor ResourcesInstructor class workshop files are available for download after purchasing this product.
Course OutlineLesson 1: Relational Database Design Theory • The Three Types of Databases • Effective Table Design • What makes the second design better? • Tips on Dividing Large Tables into Smaller Tables
Lesson 2: Getting Started • What is Access 2007? • What Does Access 2007 Do? • Start Microsoft Access 2007 • Understand the Access 2007 Interface • Open a Table • Understand the Anatomy of the Table • Use Table Navigation • Search Text Box • Use Field Quick Filter • Exit Access 2007
Lesson 3: Creating a Database • Database Terminology • Create a New Database • Create a New Table • Work with Table Views • Use the Table Design View • Understand Field Components and Field Properties • Understand Field Data Types • Use the Datasheet View • Enter Data in the New Table • Save the Table • Use the Lookup Wizard
Lesson 4: Working with the Table • Add Records to a Table • Use the Record Selector • Cancel an Entry or Edit • Enter Data in the Memo Field • Use Shortcut Keys • Find Data • What is the Find Dialog Box? • Work with Wildcards • Delete Records • Alter the Table Appearance • Change Column Widths • Hide and Unhide Columns • Change the Font • Save the Table Layout • Filter Data
Lesson 5: Querying Data • Understand Query Types • Use the Query Wizard • Create Select Queries • Use the Query Design Window • Work with Buttons for Query Design, Execution, and Saving • Use the Field List • Use the QBE Grid • Place Fields in the QBE Grid • Run Queries • Understand the Dynaset • Enter Criteria • Use Multi-Table Queries
Lesson 6: Working With Forms • What are my Form Options? • Create a New Form • Use the Form Auto Form, Split Form Auto Form and Multiple Items Auto Form • Use the Form Wizard • Enter Data and Navigate in a Form • Work with the Form Design Window • Work the Design View Ribbon • Use Controls • Work with Bound and Unbound Controls • Select, Move, Resize and Delete Controls • Change Labels • Use the Form Layout Window • Change the Format
Lesson 7: Working with Reports • An Overview of Reports • Report Design Issues • Create a Report • Create Simple Reports Using Auto Report • Use the Report Wizard • Work with the Report Design Window • How Do Bands Work?
|
|
|
|
