close
search
search
menu
Topics
close
I want to...
Get started with computers
Learn Microsoft Office
Apply for a job
Improve my work skills
Design nice-looking docs
More...
Microsoft
Office 2019
|
2016
|
2013
Word
Excel
PowerPoint
Access
Excel Formulas
More...
Basic Skills
Computers
Smartphones & Tablets
Typing Tutorial
Windows
More...
Internet Skills
Internet
Online Safety
Social Media
Email
Search Better
More...
Google
Gmail
Google Docs
Google Sheets
More...
Work & Career
Career Planning
Resume Writing
Cover Letters
Job Search and Networking
Business Communication
More...
Skills for Today
Adapting to Change
3D Printing
Wearables
Freelance Work
Personal Finance
Sharing Economy
Decision-Making
More...
Creativity & Design
Graphic Design
Creativity
Photography
Image Editing
Photoshop
More...
Core Skills
Math
Reading
Grammar
Language Learning
More...
For Educators
Translations
Staff Picks
All Topics
English
expand_more
expand_less
English
expand_more
expand_less
Español
Português
search
menu
All Topics
My Account
About Us
FAQ
Contact Us
EN
ES
PT
search
55e87d2b7a2cbde81af62187
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.