Learn Microsoft Access database software to manage information, data, and records. Create, edit, and manipulate databases; add tables to organize data; create relationships; perform queries to extract information; create and use forms; develop reports for data analysis and reporting to stakeholders; use settings within Access to ensure efficient and accurate data entry. Prerequisite: Competency in Windows including solid file management skills.
Prior Learning Assessment
- Exam-College Developed Challenge Exam
Develop a databaseAssessment StrategiesThrough actual performance of the skillIn submitted files as specified on the assignment sheetBy specified assignment deadlinesCriteriaImplement database conceptsDescribe the features of the Access windowCreate a databaseCreate tables in Datasheet and Design viewsAdd records to a tableClose a databaseOpen a databasePrint the contents of a tableImport dataCreate and use a queryCreate and use a formCreate and print custom reportsModify a report in Layout ViewPerform special database operationsDesign a database to satisfy a collection of requirements
Query a databaseAssessment StrategiesThrough actual performance of the skillIn submitted files as specified on the assignment sheetBy specified assignment deadlinesCriteriaCreate queries using Design viewInclude fields in the design gridUse text and numeric data in criteriaSave a query and use the saved queryCreate and use parameter queriesUse compound criteria in queriesSort data in queriesJoin tables in queriesCreate a report and a form based on a queryExport data from a query to another applicationPerform calculations and calculate statistics in queriesCreate crosstab queriesCustomize the Navigation Pane
Maintain a databaseAssessment StrategiesThrough actual performance of the skillIn submitted files as specified on the assignment sheetBy specified assignment deadlinesCriteriaAdd, change, and delete recordsSearch for recordsFilter recordsUpdate a table designUse action queries to update recordsSpecify validation rules, default values, and formatsCreate and use single-value lookup fieldsCreate and use multivalued lookup fieldsUse delete queries to delete recordsAdd new fields to an existing reportFormat a datasheetSpecify referential integrityUse a SubdatasheetSort records