Access 2010 Core Skills
Learn how to
- Design and create tables
- Enter and manipulate data in tables
- Use Access queries to select and analyze information in a table
- Create data forms for viewing and inputting data
- Create reports that summarize and group data
- Perform database maintenance procedures
Content
Overview of Access 2010
Introduction to Database Concepts and Terminology
An Introduction to Access 2010
The Access 2010 Interface
Database Planning and Design
Creating a Database
Principles of Table Design
Normalizing Data
Normalizing Data for Fourth and Fifth Normal Forms
Analyzing Table Relationships
Establishing and Testing Referential Integrity
Creating Tables
Examining a Table
Access Data Types
Creating a Table with the Table Wizard
Creating a Table in Design View
Types of Primary Keys
Working with Tables
Adding Records
Modifying the Table Design
Finding and Editing Records
Deleting, Adding, and Copying Records and Values
Filtering and Sorting the Data Sheet
Data Integrity
Preventing Blanks
Preventing Duplicates
Creating Input Masks
Validation Rules
Using a Lookup
Using Select Queries
Selecting Fields and Sorting Records
Refining the Results of a Query
Using Queries to Perform Calculations
Joining Tables in a Query
Query Joins and Crosstab Queries
Joining Tables and Working with Join Properties
Creating Crosstab Queries
Editing Limitations in Query Datasheets
Changing Data with Queries
Update Queries
Append Queries
Delete Queries
Creating and Using Forms
Creating a Form
Modifying the Form Design
Using a Form to Locate and Organise Information
Multiple-Table Forms
Performing Calculations on a Form
Adding Combo Boxes to a Form
Adding Unbound Controls
Using Advanced Form Techniques
Organising Field Placement
Using Functions to Control Data Entry
Adding an Option Group to a Form
Using a Form as the User Interface
Creating a Form that Contains a Subform
Creating a Navigation System
Creating and Using Reports
Creating a Report
Creating a Report that Contains Totals
Working with Subreports
Working with Groups
Maintaining a Database
Managing a Database and its Objects
Database Maintenance
Securing a Database