Essentials of Access: Creating Tables and Forms
3 Hours
Versions 2003 or 2007
Below is a pre-designed course for Creating Tables and Forms in Microsoft Access.
This 3-hour course introduces users to Microsoft Access and demonstrates how to create and edit tables, define relationships between tables, and create forms to help enter data.
Understanding the Basics of a Database
What is a Database?
Opening a Database
Review Important Screen Elements
Understanding the Main Database Objects
Table
Form
Query
Report
Steps for Designing a Database
Creating a Database
Creating a New Database
Creating New Tables and Defining Fields
Defining Fields
Creating New Tables
Opening Tables
Modifying Table Structures
Relating and Linking Tables |
Entering Data and Working with Tables
Adding New Records
Using Data Entry Shortcuts
Editing Information and Undoing Changes
Customizing the Datasheet
Entering Data into Related Tables
Deleting Records
Creating Forms to Work With Data
Reviewing Multi-table Forms
Creating Forms Using the Wizard
Closing Forms
Opening Forms
Customizing Forms
Understanding Form Sections
Widening the Overall Form Size
Working With Layouts and Fields
Formatting Objects
Working With Labels
Navigating Between Records
Navigating Between Fields
Adjusting Tab Order
Adding Records in Form View
Deleting Records
|
|