MS Access - Level 2, CMP962
Are you ready to learn more advanced features in MS Access 2007? Learn how to control table data entry by changing field properties to match specific criteria and format patterns and expedite entry through the use of lookup tables. Become more proficient in the use of Access Queries that retrieve data from multiple tables by learning how to use query joins, parameter queries, and action queries. Improve the look and ability of forms and reports to facilitate data navigation, entry, and data organization through the use of command buttons and control parameters. Discover how easy it is to share and work with data created in other applications or features such as Microsoft Excel, Word, HTML, and delimited lists.
Prerequisites: MS Access--Level I or equivalent experience.
Classroom Hours:10
Textbook: Purchase at the Rockville Campus Bookstore and bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).
- Course Objectives:
- Modify the design and field properties of a table to streamline data entry and maintain data integrity
- Retrieve data from tables using joins
- Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries
- Enhance the capabilities of a form by grouping form controls and making other aesthetic improvements to make forms work more efficiently and intuitively for the user
- Customize reports to organize the displayed information and produce specific print layouts
- Share data across different applications
Course Content
Lesson 1: Controlling Data Entry
- Restrict Data Entry Using Field Properties
- Establish a Pattern for Entering Field Values
- Create a List of Values for a Field
Lesson 2: Joining Tables
- Create Query Joins
- Join Unrelated Tables
- Relate Data Within a Table
Lesson 3: Creating Flexible Queries
- Set Select Query Properties
- Create Parameter Queries
- Create Action Queries
Lesson 4: Improving Forms
- Design a Form Layout
- Enhance the Appearance of a Form
- Restrict Data Entry in Forms
- Add a Command Button to a Form
- Create a Subform
Lesson 5: Customizing Reports
- Organize Report Information
- Format the Report
- Set Report Control Properties
- Control Report Pagination
- Summarize Report Information
- Add a Subreport to and Existing Report
- Create a Mailing Label Report
Lesson 6: Sharing Data Across Applications
- Import Data into Access
- Export Data
- Analyze Access Data in Excel
- Export Data to a Text File
- Merge Access Data with a Word Document