Location

Community Services & Continuing Education - Alexandria

Objectives

• The program aims to:• Understand the structure of the database file and its advantages.• Become comfortable with how the menus and ribbons work.• Learn how you can save all your data in one place.• Learn how to extract only the information you want.• See how to relate tables together and resolve the "1 to Many" problem.• Discover how having separate report formats reduces report prep time.• Learn how to easily create subtotals and do calculations.• View demonstrations of how Macros can be used to automate tasks.• See examples of how the VBA Programming Language can be used.• Learn how Access can work with Other Microsoft Office programs.

Outcomes

By the end of this course, students should be able to:• Understand what a database is and how it is organized and operated.• Create a simple database and view the database content in various modes.• Create a table, define and modify fields and their properties; enter and edit data in a table.• Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database.• Understand what a form is and create a form to enter, modify and delete records and data in records.• Create routine reports and prepare outputs ready for distribution.

Course Contents

Database concept and design Understand what a database is. Understand how a database is organized in terms of tables, records and fields. Understand that each table in a database should contain data related to a single subject type. Understand that field content is associated with an appropriate data type like: text, number, date/time, yes/no. Understand what an index is. Understand that a relationship is built by matching a unique field in one table with a field in another table. Understand the importance of maintaining the integrity of relationships between tables. Understand what an Entity Relationships Diagram (ERD) is. Know that professional databases are designed and created by database specialists. Know that data entry, data maintenance and information retrieval are carried out by users.Working with database Open, close a database application. Open, close a database. Create a new database and save to a location on a drive. Identify different databas