Microsoft® Access 2013 Level II
Open Enrollment Course Dates: TBA
Course Length: 1 day
Delivery: Instructor Led/Group Live
PMI Activity ID# 000330
Prerequisites: Microsoft® Access 2013 Level I or equivalent knowledge
Course Level: Intermediate
Course Fee: $345
Course Hours: 8:30-4:15
Course Description: This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft® Office Access program. The target student may also include individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft® Office Word or Excel.
- Streamline data entry and maintain data integrity.
- Join tables to retrieve data from unrelated tables.
- Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
- Improve forms.
- Customize reports to organize the displayed information and produce specific print layouts.
- Share data between Access and other applications
Lesson 1: Controlling Data Entry
Constrain Data Entry Using Field Properties
Establish Data Entry Formats for Entering Field Values
Create a List of Values for a Field
Lesson 2: Joining Tables
Create Query Joins
Join Tables with No Common Fields
Relate Data Within a Table
Lesson 3: Creating Flexible Queries
Set the Select Query Properties
Retrieve Records Based on Input Criteria
Create Action Queries
Lesson 4: Improving Forms
Restrict Data Entry in Forms
Organize Information with Tab Pages
Add a Command Button to a Form
Create a Subform
Display a Summary of Data in a Form
Change the Display of Data Conditionally
Lesson 5: Customizing Reports
Organize Report Information
Control Report Pagination
Summarize Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report
Lesson 6: Sharing Data Across Applications
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge
Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.
For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22
Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Concerns regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.