You are here

Access Essentials

Access Essentials


NYIM Training
185 Madison Avenue, 11th Floor
New York, NY 10016
Register for Course
Thursday, October 18, 2018 -
10:00am to 5:00pm


The Access Essentials 2-day class concentrates on the most common topics we see NYC businesses using on a daily basis. When you are finished with this Access Essentials class you will be able to create a relational database in Access, define and populate tables, modify table structure and fields, view and maintain data using queries and forms and create summary fields in queries, forms, and reports. This class is perfect to those who are new users to Microsoft Access or users with limited experience and those who plan to utilize, build, and integrate database applications using Access. Materials: Microsoft Office Access 2010: Level 1 Microsoft Office Access 2010: Level 2 Examples databases for in class and after class Shortcut sheet SYLLABUS: Day One: Level 1 Outline Lesson 1: Exploring Access 2010 Environment Overview of database concepts Exploring the User Interface Opening an Existing Database Customizing the Access Environment Lesson 2: Designing a Database Define Database Purpose Review Existing Data Determine Fields Group Fields into Tables Normalize Data Lesson 3: Creating a Relational Database in Access Creating a New Database Creating a Table Manage Tables Create a Table Relationship Saving the Table Structure Save a Database as a Previous Version Lesson 4: Managing Data in a Table Modify Table Data Sort Records Work with Subdatasheets Lesson 5: Querying a Database Filter Records Exploring Query Types Creating and Running a Query Updating Data Using a Query Summarizing Data in a Query Lesson 6: Designing Forms Creating a Form Using the Forms Wizard Changing a Forms AutoFormat Finding Data Using a Form Maintaining Table Data Using a Form Filtering Data in a Form Lesson 7: Working With Reports The Report Window Exploring Report Types Creating a Report Using the Report Wizard Grouping Data within a Report Summarizing Data in a Report Formatting Report Detail and Printing Reports Day Two: Level 2 Outline Lesson 1: Controlling Data Entry Restrict Data Entry Using Field Properties Establish a Pattern for Entering Field Values Create a List of Values for a Field Lesson 2: Joining Tables Create Query Joins Join Unrelated Tables Relate Data Within Table Lesson 3: Creating Flexible Queries Set Select Query Properties Create Parameter and Action Queries Lesson 4: Improving Forms Create a Form Layout Restrict Data Entry in Forms Add a Command Button to a Form Create a Subform Lesson 5: Customizing Reports Organize Report Information Formatting and Setting Report Control Properties Summarize Report Information Create a Mailing Label Report Lesson 6: Sharing Data Across Applications Import Data into Access Export Data Analyze Access Data in Excel Export Data to a Text File Merge Access Data with a Word Document

Register for Course

Additional Sessions