Unveiling the Power of Microsoft Access
Are you ready to unlock the incredible potential of Microsoft Access? Dive into our one-day foundation course designed to empower individuals from all levels of expertise. Whether you’re a clerk, manager, or tech enthusiast, this course is tailored to broaden your understanding and practical application of Microsoft Access.
Get Started with Ease
In this engaging program, we begin with the basics. Learn what Microsoft Access is and explore its interface. Discover the art of maneuvering through menus, task panes, toolbars, and more. We’ll guide you through setting up your database, understanding records, and creating tables efficiently.
Master the Essentials
Delve deeper into the database world by creating queries with ease. You’ll become proficient in sorting and filtering data, making your information management seamless. And when it’s time to print, we’ve got you covered, teaching you the nuances of printing database objects like a pro.
Join us for a day of interactive learning, where interactive lectures, PowerPoint presentations, discussions, and practical exercises converge to transform you into a Microsoft Access maestro. Don’t miss this opportunity to elevate your skills and boost your productivity with Microsoft Access.
Course Details
Course: ACF-1; Duration: 1 Day; Instructor-led
Audience
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who want to know and understand their knowledge and practical uses of Microsoft Access
Prerequisites
- Able to maneuver with the mouse – Point, Click, Drag and Double Click
- Able to configure the desktop
- Able to use the Control Panel
- Able to move and re-size Application Windows
- Able to switch between task applications
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.
Course Objectives
Upon completion of this program, participants should be able to:
- Understand basic terminology
- Creating a database from a template
- Creating a Table
- Creating a Query with the Wizard
- Sorting and Filtering Data
Outlines
Module 1: Getting Started
Lesson 1.1: Starting Out
- What is Microsoft Access?
- What’s New in Access 2003?
- Basic Terminology
- Opening Microsoft Access
- Interface Overview
- Closing Microsoft Access
Lesson 1.2: Using the Access Interface
- Using the Access Menus
- Using Access Task Panes
- Using Toolbars
- Adding, Removing and Moving Toolbars
- Using the Switchboard
- Using the Database Window
Module 2: Creating A Database
Lesson 2.1: First Steps46
- Planning a Database
- Creating a Blank Database
- Using Database Objects
Lesson 2.2: Records
- What is a Record?
- Adding Records
- Editing Records
- Deleting Records
- Printing Records
Lesson 2.3: Creating A Table
- About Tables
- Creating a Table in Design View
- Creating a Table using the Wizard
- Entering Data into a Table
- Formatting a Table
Module 3: Doing More with Your Database
Lesson 3.1: Creating Queries
- What is a Query?
- Creating a Query with the Wizard
- Using Design View to Modify a Query
- Using Queries
Lesson 3.2: Sorting and Filtering Data
- Using Find and Replace
- Sort Ascending or Descending
- Using Filter by Form
- Using Filter by Selection
- Creating a Filter
Module 4: Basic Printing
Lesson 4.1: Printing A Database Object
- Using the Print Icon
- Using Print Preview
- Using Page Setup