This course covers the establishment and effective use of a database using Access: design, screen forms and data-entry, queries, updating, linking related tables, report generation, and export/import to other programs. It also presents the design and application of spreadsheets using Excel: formatting, ranges, built-in functions, user-defined formulas, array formulas, table-lookups, summaries by pivot tables, graphing, linking, and macros. Some mathematical background is assumed.
Semester Offered
Fall