Access Introduction

Access Introduction

Requirements:
All attendees must be proficient with basic Mouse, Keyboard and Windows skills. If you are new to Microsoft products, we suggest that you spend a little time looking over the basic toolbar and menu options. An understanding of Database concepts is beneficial but not essential.
Getting Started with Access: What Is a Database? What Is a Relational Database? Starting Access. Looking at the Access Database Window. Access Database Objects.
Starting a Database: Planning Content. Planning Structure. Creating a Database Using a Wizard. Saving Databases.
Working with Tables: Looking at Tables. Creating Tables with Wizards. Entering, Editing, and Deleting Data. Formatting Columns and Rows. Moving Columns. Freezing and Hiding Columns. Adding Fields. Using Input Masks. Validating Data Entry. Setting Primary Key Fields. Understanding Data Types. Printing Tables.
Working with Forms: Look at simple Forms. Design Vie- of a Form. Viewing Forms. Deleting Records from Forms. Creating Forms with a Wizard. Formatting Forms.
Finding, Filtering, and Sorting: Choosing Filters or Queries. Finding Records. Finding and Replacing Data. Sorting Query Results. Sorting Table Records.
Working with Queries: Looking at Queries. Creating Ne- Queries with a Wizard. Viewing Queries in Design View. Specifying Query Criteria. Querying with Wildcards.
Working with Reports: Look at Reports. Creating Ne- Reports with a Wizard. Formatting Reports in Design View.