Microsoft Access Introduction
1 Day
Versions XP, 2003 and 2007
Course Description
This instructor-led, hands-on course teaches the basic skills needed to create a 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
This course is designed for users that are new to Microsoft Access or are self-taught. 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 a Database What is a Database? Opening a Database Important Screen Elements Understanding the Main Database Objects Steps for Designing a Database Creating a Database Creating a New Database Creating New Tables and Defining Fields Opening Tables Modifying Table Structures Relating and Linking Tables Entering Data and Working with Tables Adding New Records Using Data Entry Shortcuts Editing Information and Undoing Changes Customizing the Datasheet Entering Data into Related Tables Deleting Records Creating Forms to Work With Data Reviewing Multi-table Forms Creating Forms Using the Wizard Closing Forms Opening Forms Customizing Forms Navigating Between Records Navigating Between Fields Adjusting Tab Order Adding Records in Form View Deleting Records |
Finding, Sorting, and Filtering Records Navigating Through Tables Searching Records Sorting Records Filtering Records Creating Queries to Extract Information Building Queries Specifying Query Fields Reviewing Data Types and Criteria Examples Writing Criteria in Yes/No Fields Viewing or Running the Query Saving and Closing Queries Opening or Modifying Queries Sorting Query Results Deleting Query Fields Printing Query Results Specifying Criteria in Text Fields Using Wildcards When Specifying Criteria Writing Criteria in Numeric Fields Writing Criteria in Date/Time Fields Using “AND” Criteria Using “OR” Criteria Creating Basic Reports Creating Reports Using the Wizard Closing Reports Opening Reports Customizing Reports Understanding Report Sections Saving Reports Previewing and Printing Reports Creating Mailing Labels
|
Is this the right level for you? Take our free assessment! Please contact our office at (202) 747-5000 if you have any questions.
Other Helpful Links
Access - VBA Programming Agenda
Find us
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 intersted 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