Access Beginning

Beginning Access is for people concentrating on data entry, queries, and reports. Learn a number of ways to filter data using different types of queries. This full-day hands-on course provides a clear overview of Microsoft Access for anyone who wishes to create a simple database. Learn about the four most common Objects in a database: tables, forms, queries, and reports. See how they relate to one another and become familiar with data entry and filtering. If you’re only interested in learning how to extract and filter data, register for our Access Queries class which focuses exclusively on that subject.

Topics Covered:

• Create and edit tables
• Create and edit forms
• Customize table settings
• Customize form settings
• Navigate forms and tables
• Quick Sort orders data by text, dates, or values
• Filter by Selection filters data by a specific field
• Create, rename, and delete queries
• Multiple Criteria narrow a search
• Wildcards
• Calculated Fields
• Parameter Queries ask users for input to narrow results
• Unmatched Records Queries locate records not found in related table
• Duplicate Records Queries find duplicate records
• Append Queries add records
• Delete Queries remove records
• Update Queries update records
• Make Table Queries create new tables based on existing tables
• Summary Queries summarize large amounts of data in rows
• Cross Tab Queries summarize data in columns and rows