- Explore an Access 2010 Database
- Create Databases and Simple Tables
- Create Simple Forms
- Display Data
- Create Simple Reports
- Maintain Data Integrity
- Create Custom Forms
- Create Queries
- Create Custom Reports
- Import and Export Data
- Make Databases User Friendly
- Protect Databases
- Customize Access
1: Explore an Access 2010 Database
- Working in Access 2010
- Understanding Database Concepts
- Exploring Tables
- Exploring Forms
- Exploring Queries
- Exploring Reports
- Previewing and Printing Access Objects
2: Create Databases and Simple Tables
- Creating Databases from Templates
- Creating Databases and Tables Manually
- Manipulating Table Columns and Rows
- Refining Table Structure
- Creating Relationships Between Tables
3: Create Simple Forms
- Creating Forms by Using the Form Tool
- Changing the Look of Forms
- Changing the Arrangement of Forms
4: Display Data
- Sorting Information in Tables
- Filtering Information in Tables
- Filtering Information by Using Forms
- Locating Information That Matches Multiple Criteria
5: Create Simple Reports
- Creating Reports by Using a Wizard
- Modifying Report Design
- Previewing and Printing Reports
6: Maintain Data Integrity
- Restricting the Type of Data
- Restricting the Amount of Data
- Restricting the Format of Data
- Restricting Data by Using Validation Rules
- Restricting Data to Values in Lists
- Restricting Data to Values in Other Tables
7: Create Custom Forms
- Modifying Forms Created by Using a Wizard
- Adding Controls
- Adding Subforms
- Using E-Mail Forms to Collect Data
8: Create Queries
- Creating Queries by Using a Wizard
- Creating Queries Manually
- Using Queries to Summarize Data
- Using Queries to Perform Calculations
- Using Queries to Update Records
- Using Queries to Delete Records
9: Create Custom Reports
- Creating Reports Manually
- Modifying Report Content
- Adding Subreports
10: Import and Export Data
- Importing Information
- Exporting Information
- Copying to and from Other Office Programs
11: Make Databases User Friendly
- Creating Navigation Forms
- Creating Custom Categories
- Controlling Which Features Are Available
12: Protect Databases
- Assigning Passwords to Databases
- Splitting Databases
- Securing Databases for Distribution
- Preventing Database Problems
13: Customize Access
- Changing Default Program Options
- Customizing the Ribbon
- Customizing the Quick Access Toolbar