The focus of this class is the design of an Access database. You will learn how to create tables and basic forms, basic queries, and basic reports. We will cover planning a database, finding records, editing data, and using sorting and filters. Input masks and validation will be covered to help get correct information into your database.Class OutlineUnit 1: Getting startedTopic A:Â OrientationTopic B:Â Create a simple Access databaseTopic C:Â Get help and configure optionsUnit 2: Working with Table DataTopic A:Â Modify table dataTopic B:Â Sort and filter recordsUnit 3: Querying a DatabaseTopic A:Â Create basic queriesTopic B:Â Sort and filter data in a queryTopic C:Â Perform calculations in a queryUnit 4: Using FormsTopic A:Â Create basic Access formsTopic B:Â Work with data on Access formsUnit 5: Generating ReportsTopic A:Â Create a reportTopic B:Â Add controls to a reportTopic C:Â Enhance the appearance of a reportTopic D:Â Prepare a report for printTopic E:Â Organize report informationTopic F:Â Format reports
Overview
Taught by
Computer Training Source, Inc.
