Maxtrain.com - info@maxtrain.com - 513-322-8888 - 866-595-6863
Microsoft Access Part 1: Foundations
Description
Microsoft Access Part 1: Foundations Introduction
Welcome to the introductory course of Microsoft Access Part 1: Foundations, which serves as your initial step on the path to becoming proficient in Microsoft Access and its core principles.
Whether you are a novice embarking on your first exploration of Access or seeking to enhance your existing knowledge, this course has been meticulously designed to provide you with a robust foundational understanding. In today’s digital age, expertise in data management is of paramount importance, and Microsoft Office Access is a powerful tool that can empower you to master this critical skill.
This course represents the first segment of a comprehensive three-course series devoted to the intricacies of database design and development using Microsoft Access. By the conclusion of this series, you will have acquired the essential skills and knowledge required to effectively construct, manage, and optimize databases. These skills will not only broaden your horizons but also enable you to excel in various professional domains where data plays a pivotal role.
We invite you to join us on this journey of discovery and practical application as we delve into the realm of Microsoft Access and the art of database management.
Prerequisites
- Basic end-user skills with any current version of Windows.
- Proficiency in tasks like starting programs, switching between programs, locating and saving files, and using a web browser.
- You can acquire these skills through courses like Using Microsoft Windows or “Microsoft Windows: Transition from a previous version.
Audience
- Beginners seeking a foundational understanding of Microsoft Office Access.
- Individuals needing to create and manage personal or professional databases.
- Anyone looking to acquire database design and development skills.
Microsoft Access Part 1: Foundations Outline
Getting Started with Access:
- Launch Access and Open a Database
- Use Tables to Store Data
- Use Queries to Combine, Find, Filter, and Sort Data
- Use Forms to View, Add, and Update Data
- Use Reports to Present Data
- Get Help and Configure Options in Microsoft Access
Creating Tables:
- Plan an Access Database
- Start a New Access Database
- Create a New Table
- Establish Table Relationships
Creating Queries:
- Create Basic Queries
- Perform Calculations in a Query
- Sort and Filter Data in a Query
Creating Forms:
- Start a New Form
- Enhance a Form
Creating Reports:
- Start a New Report
- Enhance Report Layout
$350.00
|
1 Day Course |