Explores the essential features of Microsoft Access and databases. Studies how to create and modify databases, create queries and forms, create reports and charts, add graphics to forms and reports, import and export data, create macros and command buttons to run macros, and integrate databases.
Goals, Topics, and Objectives
a. Create databases.
b. Create tables.
c. Create input masks.
d. Create lookup fields.
e. Format field values.
f. Use spell check.
g. Compact and repair a database.
h. Find and replace data.
a. Create a primary field and foreign key.
b. Define and enforce referential integrity.
c. Use cascade update and cascade delete options.
- Queries and Filters
a. Create queries.
b. Sort fields in a query.
c. Specify multiple criteria for a query.
d. Refine a query using filter by selection and filter by form.
e. Create and apply advanced filters.
f. Join two tables in a query.
g. Perform calculations in a query.
h. Create find-duplicate, parameter, and action queries.
a. Create forms.
b. Add titles and graphics to a form.
c. Create a calculated control.
- Reports and Charts
a. Create reports and charts.
b. Sort and group records in a report.
c. Add graphics to a report.
d. Use the total and average functions.
e. Embed a sub-report.
- Data Importing and Exporting
a.Export data from a table.
b. Import data into a table.
- Access Tools
a. Assign user-level security.
b. Encode and decode a database.
c. Set startup options.
d. Create macros.
e. Create command buttons that run macros.
- Database Applications
a.Use the database splitter wizard.
b. Link an external table.
c. Make a local table from a linked table.
- Date Integration
a. Export records to Microsoft Excel.
b. Present data in a chart.
c. Link an Excel workbook to an Access database.
d. Create a data access page.
e. Create a lookup field to use sorted data in another table.
This course is being deactivated because the only program that it is required for is the Computer Software Applications Certificate, which is being deactivated. Students currently in need of this course will have a completion plan written.
Assessment and Requirements
Credit for Prior College-Level Learning
Microsoft Office Specialist - Access