Pre-requisites: 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.

Duration: 1-Day
Start & Finish Times: 10am to 5pm

Objectives: This hands-on course will enable participants to identify and describe the component features that collectively make up the application. Participants will be able to build database objects including Tables, Queries, Simple Forms and Reports.

Who should attend: Our ‘Introduction’ course is designed for busy people who need to know how to get the best from Access from the outset. If you are required to use Access simply for Data Input, or need to progress to build your own Tables and Queries, this course will point you in the right direction.

Overview of Content

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 View 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 New Queries with a Wizard. Viewing Queries in Design View. Specifying Query Criteria. Querying with Wildcards.

Working with Reports: Look at Reports. Creating New Reports with a Wizard. Formatting Reports in Design View.