After taking this course, the learner will be able to work with a database application to create a database, create, use, and change a data entry form, retrieve information, and create reports.
Objectives:
Open, close, create, and update a database
Revise and save records
Create, use, and revise a data entry form
Create and refine a query
Select and sort data
Create and edit a report
Topics:
Database concepts
Opening and closing a database application
Adjusting settings
Defining table fields
Finalizing tables
Creating table relationships
Adding and revising records
Working with forms
Searching records
Filtering and sorting records
Queries
Advanced query functions
Creating reports
Working with reports
Printing information
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.