Spindustry News

Azure For IT Professionals

Learn more about implementing Azure as part of your infrastructure.

Staying Sharp on Microsoft Office Can Save Time & Money

Learning the latest Microsoft Office tips and tricks can benefit you greatly.

"How do I determine if this new technology is for real?"

Michael Bird explains how to navigate new technology waters.
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

Microsoft Office Access 2013: Level 1

Course Code: FC1-AC2013
Length: 1 Day
Tuition: $179.00

Schedule for this Course

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

Course Description:

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, like 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 such as time reporting or recording a sale. But virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft® Office Access® 2013 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 learn how to use Access 2013 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2013.

Target Student:

This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2013, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Prerequisites

To ensure success, students should be familiar with using personal computers, and should have experience using a keyboard and mouse. Students should be comfortable in the Windows® 8.1 environment, and be able to use Windows 8.1 to manage information on their computers. Specific tasks the students should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.

Course Outline:

ACCESS 2013 LESSON 1:

  • Defining Access Databases
    • What Is a Database?
    • Purpose of Databases
    • Database Management Software
  • Exploring the Access Environment
    • Starting Access
    • Opening an Existing Database
    • Identifying Features of the Database Window
  • Introducing Access Objects
    • Tables
    • Forms
    • Deleting Records Using a Form
    • Queries
    • Reports
  • Closing a Database and Exiting Access

ACCESS 2013 LESSON 2: DESIGNING A DATABASE AND CREATING TABLES

  • Designing a Relational Database
    • What Is a Relational Database?
    • Gathering Data
    • Importance of Good Database Design
  • Normalizing Databases
    • Planning Related Tables
  • Linking Tables with Primary and Foreign Keys
    • Primary Keys
    • Foreign Keys
    • Identifying Relationship Types
    • Developing an Entity Relationship Diagram
    • Defining Data Types
  • Creating Access Tables in a New Database
    • Creating a New Database
    • Creating Tables in Design View
  • Retrieving Data
    • Sorting Records
    • Sorting Records Using Multiple Fields
    • Filtering Records
    • Filtering Records by Form
    • Update Records with Find and Replace

ACCESS 2013 LESSON 3: WORKING WITH FORMS

  • Exploring Form Design
    • Examining Form Views
    • The Property Sheet
  • Creating Forms
    • Identifying a Record Source
    • Using the Form Wizard
    • Working with Form Controls
    • Deleting Controls
    • Arranging Controls
    • Applying Themes to Forms
  • Modifying Form Controls
    • Editing Labels
    • Using Design Font Tools
    • Using the Property Sheet
    • Using the Fill Color Palette
  • Modifying Form Layout
    • Displaying Form Header and Form Footer
    • Adding Unbound Controls to a Form
    • Setting Additional Form Properties
    • Setting a Form Tab Order
    • Creating Multiple Items Forms
    • Creating Split Forms
  • Using Help

ACCESS 2013 LESSON 4: QUERYING A DATABASE

  • Creating Select Queries
    • Reviewing Query Features
    • Identifying Tools for Creating Select Queries
    • Creating a Select Query Using Query Design
    • Designing a Query Using Multiple Tables
    • Choosing Fields to Include in a Query
    • Selecting a Field that Appears in Multiple Tables
  • Setting Query Criteria
    • Adding Criteria to a Query
    • Using Wildcards
    • Setting AND and OR Criteria
    • Entering Date Criteria
  • Sorting a Query and Limiting Results
    • Setting a Query Sort Order
    • Limiting Number of Results Displayed
  • Performing Calculations in Queries
    • Identifying Parts of a Calculated Field
    • Creating and Formatting a Calculated Field
    • Using a Function in a Query Expression
  • Creating Special Types of Queries
    • Creating a Crosstab Query
    • Creating Unmatched and Duplicates Queries

back to top