Access 2007

Understanding Database Concepts

• 1

  Why Do I Need a Database? arrow_forward_ios ✓ Learn what an Access database does and how to decide whether you need one to manage your information.
• 2

  Exploring an Access Database arrow_forward_ios ✓ Learn the parts of an Access database, how to start using Access, and how to navigate the Access window.
• 3

  Thinking about Database Design arrow_forward_ios ✓ 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 arrow_forward_ios ✓ Learn how to set up tables and the fields within these tables.
• 5

  Building Table Relationships arrow_forward_ios ✓ 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 arrow_forward_ios ✓ 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 arrow_forward_ios ✓ 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 arrow_forward_ios ✓ 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 arrow_forward_ios ✓ 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

  Sorting Records arrow_forward_ios ✓ Learn how to sort text-based and numerical data using common sorting commands, as well as how to clear sorts.
• 11

  Filtering Records arrow_forward_ios ✓ Learn how to filter records using common filter commands and use the toggle button to switch between filtered and unfiltered results.
• 12

  Using Queries to Make Data Meaningful - Part 1 arrow_forward_ios ✓ 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 arrow_forward_ios ✓ 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 arrow_forward_ios ✓ Learn how to create reports in Access so others can understand the data you're presenting.