10103145Access
Course Information
Description
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. 
Total Credits
1
Prior Learning Assessment
  • Exam-College Developed Challenge Exam

Course Competencies
  1. Develop a database
    Assessment Strategies
    Through actual performance of the skill
    In submitted files as specified on the assignment sheet
    By specified assignment deadlines
    Criteria
    Implement database concepts
    Describe the features of the Access window
    Create a database
    Create tables in Datasheet and Design views
    Add records to a table
    Close a database
    Open a database
    Print the contents of a table
    Import data
    Create and use a query
    Create and use a form
    Create and print custom reports
    Modify a report in Layout View
    Perform special database operations
    Design a database to satisfy a collection of requirements

  2. Query a database
    Assessment Strategies
    Through actual performance of the skill
    In submitted files as specified on the assignment sheet
    By specified assignment deadlines
    Criteria
    Create queries using Design view
    Include fields in the design grid
    Use text and numeric data in criteria
    Save a query and use the saved query
    Create and use parameter queries
    Use compound criteria in queries
    Sort data in queries
    Join tables in queries
    Create a report and a form based on a query
    Export data from a query to another application
    Perform calculations and calculate statistics in queries
    Create crosstab queries
    Customize the Navigation Pane

  3. Maintain a database
    Assessment Strategies
    Through actual performance of the skill
    In submitted files as specified on the assignment sheet
    By specified assignment deadlines
    Criteria
    Add, change, and delete records
    Search for records
    Filter records
    Update a table design
    Use action queries to update records
    Specify validation rules, default values, and formats
    Create and use single-value lookup fields
    Create and use multivalued lookup fields
    Use delete queries to delete records
    Add new fields to an existing report
    Format a datasheet
    Specify referential integrity
    Use a Subdatasheet
    Sort records