Access Basic

Course Syllabus

Database Concepts Database concepts and terminology Exploring the Access environment Planning and designing databases Getting help Closing a database and Access Access Basics Exploring tables Examining queries Exploring reports Creating Databases Creating a database Using the table wizard Working in design view Working with Fields and Records Changing the design of a table Adding and deleting records Finding and editing records Sorting and filtering records Querying Tables Creating and using queries Modifying query results and queries Using calculations in queries

Creating and Using Forms Creating forms by using AutoForm Using the form wizard Using design view Finding, sorting and filtering records Creating and Using Reports Using the report wizard and queries Creating, modifying and printing reports Importing, Exporting and Linking Objects Importing Access objects Exporting Access objects Linking Access objects