Course length: 1 day
Prerequisites: Windows Introduction or equivalent knowledge.
Overview: You will learn how to create and use databases to organize your information.

Course content

Lesson 1: : Introduction to Databases

• Database Basics
• Opening a Database
• Using a Database
• Browsing Records
• Entering Records Manually
• Viewing a Database as a Form, List, or Table
• Finding Records
• Changing Layouts
• Sorting Records
  

Lesson 2: Creating a Database

• Defining a New Database
• Creating a New Database
• Creating Fields
• Editing Field Names
• Advanced Field Options
• Applying Auto-Entry Field Options
• Creating Calculation Fields
• Applying Validation Field Options
• Creating a Pop-Up Menu Value List
• Creating a Radio Buttons Value List
• Applying Check Box Value Lists
• Importing Records
• Importing Records from Other Sources
• Replacing Field Information

Lesson 3: Complex Find Requests

• Advanced Single Criterion Searches
• Performing Searches Using Logical Operators
• Performing Range Searches
• Finding Blank Fields
• Omitting Records
• Multiple Criteria Searches
• Performing an AND Search
• Performing an OR Search

Lesson 4: Designing Layouts

• Modifying the Default Layout
• Resizing Fields
• Deleting and Changing Field Labels
• Moving Fields
• Drawing Basic Shapes
• Applying Fill Colors
• Formatting Numeric Fields
• Grouping Layout Items
• Changing the Layout Name
• Creating New Layouts
• Creating a Columnar Report
• Viewing Layout Parts
• Formatting Layout Fields
• Creating Mailing Labels
• Using Merge Fields
• Creating a Blank Layout
• Inserting the Date Symbol
• Inserting Merge Fields
• Importing Graphics

Lesson 5: Summarizing Data

• Using Grand Summaries
• Creating a Summary Field
• Creating Leading Grand Summary Parts
• Using Subsummaries
• Creating Subsummary Parts
• Formatting Items in Subsummary Parts
• Duplicating Fields
• Displaying Summary Information for Found Records
  

Return to Courses