By the end of the course you will be able to :

• Create Tables, Queries, Forms and Reports
• Effectively use and distinguish key built in tools available in Access

Database Concepts

• Database concepts and terminology
• Exploring the Access environment
• Getting help
• Closing a database and Access

Planning and designing databases (Concepts)

• Primary key
• Relationships
• Design and relationship concepts

Creating Databases and Tables

• Creating a table
• 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

Queries

• Creating and using queries
• Modifying query results and queries
• Using calculations in queries
• Using the Autosum feature

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 and Excel objects
• Exporting Access objects
• Linking Access objects