Microsoft Access

At the end of this course, students will be able to: Organize data efficiently by using a database management system; Plan and create a database; Modify a table design; Set field properties; Create queries, and sort and filter the results; modify queries; and perform operations in queries; Create, modify, and work with forms; and use them to sort and filter records; Create, modify, and print reports; and add summary fields to a report; Normalize tabs, analyze tables, and view object dependencies; implement referential integrity between related tables; and set cascading deletes and updates; Create lookup fields and multi-valued fields; Create join queries; create calculated fields in a query; Add unbound controls, split forms; and create multiple-item forms; Add headers and footers in a report; Create and modify ; Create and modify PivotTables, and create PivotTable forms Use SQL statements in Access; Create crosstab queries to summarize grouped data; Create and run macros to automate tasks; attach macros to the events of database objects; Create data validation and data entry macros; Import Access objects from another Access database; Save databases in file formats for previous versions of Access, split, compact, repair, and back up databases.