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.
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.
Thinking about Database Design arrow_forward_ios ✓
Learn what database design elements to consider, as well as how to create an Access database.
Setting up Tables and Fields arrow_forward_ios ✓
Learn how to set up tables and the fields within these tables.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.