| Core Services |
| Course Agendas |
| Register/Schedule |
| Cancel/Reschedule |
| Quote Request |
| Assessments |
| Student Resources |
| Classroom Rentals |
| Software Tips |
| Directions |
| Feedback Form |
| Contact Us |
Microsoft Access Introduction
1 Day
Versions 2007 and 2010(View Version 2003 Agenda)
Course Description
This instructor-led course, through lecture and hands-on exploration, will explain the basics of a database. Students will learn how to create a simple relational database, define tables, create data-entry forms, add and edit records, create queries to extract information, and design basic reports in Microsoft Access.
Prerequisites
In order to successfully complete this course, we recommend that you first take Softek’s Introduction to Windows course or have equivalent knowledge. You should feel comfortable using a mouse and have a working knowledge of the Windows environment.
Understanding the Basics of Databases Understanding Databases Examining Important Screen Elements Opening Databases Understanding the Main Database Steps for Designing Databases Creating Databases, Tables, and Relationships Creating Blank Databases Understanding Fields and Data Types Creating and Modifying Tables Customizing the Navigation Pane Opening Tables in Datasheet View Switching between Datasheet and Design Views Closing Tables Establishing Relationships between Tables Entering Data and Working with Adding Records Using Data Entry Shortcuts Editing Information and Undoing Saving Layout Changes to Tables Entering Data into Related Tables Deleting Records Creating Forms to Facilitate Data Entry Creating Forms Using the Form Command Closing Forms Opening Forms Switching between Form Views Understanding Form Sections Widening Forms Working with Layouts and Fields Navigating Between Fields Adding Records in Form View Deleting Records
|
Finding, Sorting, and Filtering Navigating Through Tables and Forms Searching for Specific Records Sorting Records Filtering Records Creating Queries to Extract Creating Queries in Design View Adding Query Fields Reviewing Data Types and Criteria Examples Writing Criteria For Queries Running the Query Saving and Closing Queries Modifying Queries Sorting Query Results Deleting Query Fields Printing Query Results Using “AND” Criteria Using “OR” Criteria Creating Multi-Table Queries Creating Basic Reports Creating Reports Using the Wizard Closing Reports Switching between Report Views Opening Reports Customizing Reports Working with Layouts Saving Reports Changing Page Setup Options Printing Reports Creating Mailing Labels |
Related Courses
Access - VBA Programming Agenda
Not Sure What Level to Take?
Before taking the Intermediate or Advanced level class for this application, we ask that you take our free assessment to determine whether you are comfortable with the topics covered in the Introductory level class. Or, feel free to contact our office at (202) 747-5000 to speak with a representative to discuss the prerequisites.
Are you interested in a class for one or a few students? Consider taking a public class. View our public training schedule for dates.
Or, are you interested in scheduling a private group class at your office or at Softek? Learn more about our private group training.
©2008 Softek Services, Inc. All Rights Reserved. - 1156 15th Street, NW Suite 100, Washington, DC 20005 - (202) 747-5000