Free Access 2007 Tutorial at GCFGlobal

Understanding Database Concepts

1

Why Do I Need a Database? ✓

Learn what an Access database does and how to decide whether you need one to manage your information.
2

Exploring an Access Database ✓

Learn the parts of an Access database, how to start using Access, and how to navigate the Access window.
3

Thinking about Database Design ✓

Learn what database design elements to consider, as well as how to create an Access database.

Building the Database

4

Setting up Tables and Fields ✓

Learn how to set up tables and the fields within these tables.
5

Building Table Relationships ✓

Learn how table relationships bring important information together so you can analyze relevant data and create a strong Access database.
6

Entering and Editing Data in Tables ✓

Learn how to work within tables to add new records, as well as how to edit existing records using commands like copy and paste and find and replace.
7

Creating and Using Forms ✓

Learn how to set up a basic form for your Access 2007 database, as well as how to use the form to populate and edit the data in it.
8

Making Forms More Usable with Controls ✓

Learn how to use form properties to limit the actions your form users can take, as well as how to hide fields and add command buttons.
9

Making Forms Attractive ✓

Learn how to modify a form layout, including how to add a logo and apply an Auto Format to a form.

Analyzing and Reporting Data