Access 2013: Part 2

COURSE OUTLINE:

Description Your training and experience using Microsoft® Access® 2013 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. 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 2013 will result in a robust, functional database for your users.

Audience
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

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

,b>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

Appendix A: Additional Reporting Options

RELATED COURSES

Database Training
Microsoft Access

Relational Database Design

At work, storing and accessing data are part of a person’s day-to-day activities. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a simple relational database application and its associated tools. You have used databases to store and retrieve data. Now, you may want to plan and design your own database. A well-designed database allows easy maintenance and quick access of data. In this course, you will plan, design, and create a functional and efficient relational database. You can create effective database designs by applying relational database design techniques.
Course Objective: You will design and create a relational database.

Database Training
Microsoft Access

Access 2016/2019/365: Part 1

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.
Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data.
A relational database application such as Microsoft® Office Access® 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Database Training
Microsoft Access

Microsoft Access VBA – Programming

VBA is the programming Interface for Access. It allows you to automate tasks and even control other applications such as PowerPoint and Word.

Database Training
Microsoft Access

Relational Database Design, Tools and Techniques

Relational databases often drive company-critical and web-enabled applications; therefore, creating a database design that accurately captures user requirements is vital for success. This course provides a foundation for designing, building and working with relational databases, enabling you to effectively develop and use relational databases in your environment.