Microsoft Access 2013 - Level 1 / Intro
Microsoft Access 2013 - Level 1 / Intro Course Details:
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, which means 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 by creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.
Call (919) 283-1674 to get a class scheduled online or in your area!
Getting Started
- Starting Out
- Using the Getting Started Window
- Getting Help
Opening a Database
- Navigating to the Database
- Pinning a Database for Quick Access
- The Trust Center
The New Interface
- Using the Quick Access Toolbar
- Basics of Tabs
- The Home Tab
- The Create Tab
- The External Data Tab
- The Database Tools Tab
Creating a Database
- Planning a Database
- Creating a Database
- Using Database Options
Working with Records
- What is a Record
- Working with Record
- Modifying Table Data
- Emailing Records
- Printing Records
Formatting Text
- Using Zoom
- Select Data
- Cut, Copy, Paste
- Format Painter
Sort and Filter
- Find and Replace
- Sort Ascending and Descending
- Selection Sort
- Advanced Sort
Tables
- Creating a Table
- Table Properties
- Formatting Fields
- Input Mask
- Entering Data into a Table
- Formatting a Table
Table Relationship
- Create Table Relationship
- Understanding the Relationship
- Enforcing Referential Integrity
- Cascade Update Related Fields
- Cascade Delete Related Records
Forms
- Creating Bound Forms
- Creating Unbound Forms
- Using the Wizard to Create Forms
- Creating Navigation Forms
- Using the Form Design Mode
- Formatting a Form Using the Design Mode
Queries
- What is a Query
- Create a Simple Query
- Create a Multi-Table Query
- Create Action Queries
Reports
- What is a Report
- Create a Report Using a Wizard
- Using a Report
Printing
- The Print Menu
- Print Preview
- Print vs. Export
*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
In this course, you will be given the tools to become an Access 2013 power user. Learn in-depth methods to manage data and data entry, create forms and dialog boxes, split databases, create and use pivot tables and charts, and utilize Add-Ons and SQL.
Students should be familiar with Microsoft Windows and Office.
Individuals and organizations that need to use Access 2013 to collect and manage large amounts of data.