This class is intended for Access 2013 users that have a basic understanding of the application and wish to gain intermediate level skills. Anyone who needs to construct relational databases, perform database maintenance, create advanced queries and reports, and integrate Access with other programs will find this course useful.
In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users.
Knowledge of the Microsoft Windows operating system, minimizing and maximizing windows, opening, saving and closing files. Completion of the course Access Introduction or equivalent knowledge.
Upon successful completion of the course, participants will be able to:
- Design a relational database
- Join tables to retrieve data from unrelated tables
- Organize a database for efficiency, performance, and to maintain data integrity
- Share data among Access and other applications
- Customize reports to organize the displayed information
Lesson 1 - Designing a Relational Database
Topic A: Relational Database Design
Topic B: Create a Table
Topic C: Create Table Relationships
Lesson 2 - Joining Tables
Topic A: Create Query Joins
Topic B: Join Tables That Have No Common Fields
Topic C: Relate Data within a Table
Topic D: Work with Subdatasheets
Topic E: Create Subqueries
Lesson 3 - Organizing a Database for Efficiency
Topic A: Data Normalization
Topic B: Create a Junction Table
Topic C: Improve Table Structure
Lesson 4 - Sharing Data Across Applications
Topic A: Import Data into Access
Topic B: Export Data to Text File Formats
Topic C: Export Access Data to Excel
Topic D: Create a Mail Merge
Lesson 5 - Advanced Reporting
Topic A: Organize Report Information
Topic B: Format Reports
Topic C: Include Control Formatting in a Report
Topic D: Add a Calculated Field to a Report
Topic E: Add a Subreport to an Existing Report
This course is available online. Please call 216.687.6957 or email firstname.lastname@example.org if you are interested.
Competency-based Professional Development: Our programs increase learner retention through application, which results in a more productive workforce. Students demonstrate their competence by successfully completing a course assessment.
Digital credentials: Digital credentials give employers, clients and colleagues the ability to instantly verify student mastery of learning and see what the earned credential qualifies the student to do.
All Inclusive: Each course delivered at CSU includes materials, pre-test and post-test, coffee, snacks, lunch and convenient, on-site parking.
Educated and Experienced Instructors: Our instructors bring years of real-world, classroom and CPA, CFA, SHRM, PhD and MBA experience. Many hold leadership positions in northeast Ohio organizations and have taught at the graduate and undergraduate levels.
Cost-effective: The course is designed to minimize travel expenses and time away from work.
Networking Opportunities: Learn from instructors and colleagues who have a variety of industry experiences to share.
Audit option: Students have the option to audit a course they have already attended at no charge within one academic year. Interested students must notify the ProDev office requesting to audit a course a minimum of 10 business days prior to the course start date to ensure there is enough seating. Audit students are responsible for their own parking and lunches. New materials will not be provided.
No refunds will be issued if notification is not received seven business days prior to the first day of class. Registrants who cancel will receive a refund, less a $50 processing fee, if we receive written notification a minimum of seven business days prior to the first day of class.