Microsoft Access

This workshop will teach you how to create Access database for anything from managing inventory to tracking research data. Class discussion and hands-on exercises explain how to —

• Organize your data into fields and records,

• Create a table, define new fields and change the attributes of existing fields,

• Decide what data type a field should be, for example Text, Number, Date and Time or AutoNumber,

• Choose which field to make the Primary Key,

• Enter and edit data, and navigate between records,

• Use filters to find and sort records,

• Create a form, add fields and labels to it, and format the form and data displayed through it,

• Create and format a report, and have the report sort and group records,

• Make calculations on a form or report,

• Import external data, and

• Create a Query and make it the record source for a form or report.