Microsoft Access 2007 Introduction

Microsoft Access Introduction

Access Basics

Query use and design
•Exploring the Access window
•Understanding the role of the query
•Understanding database terminology
•Modifying a query
•Viewing an existing database
•Creating a new query
•Understanding Access objects: Tables / Queries / Forms / Reports
•Looking at relationships within a databaseForm Creation
•Understanding the function of the Primary Key
•Creating a new form
•Keyboard Shortcuts and Menu Items
•Editing data within a form
•Modifying the design of a form Database Tables
•Understanding the difference between fields and records

Report Design
•Entering and editing data
•Creating a new report
•Moving and copying data
•Modifying the design of a report
•Sorting and filtering data
•Finding and replacing data
•Looking at data types
•Designing a new table
•Printing data from a table