Access 2007
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
-
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
-
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
-
10
-
11
-
12
Using Queries to Make Data Meaningful - Part 1 ✓
Learn how to plan a query using a three-question planning process, use the Query Design command to run a query, and modify and save queries.
-
13
Using Queries to Make Data Meaningful - Part 2 ✓
Learn how to run a query that includes a Totals function to group and count the records in the results.
-
14
Using Reports to Make Data Meaningful to Others ✓
Learn how to create reports in Access so others can understand the data you're presenting.