10106240Business Information Management
Course Information
Description
Concentrates on the fundamentals of managing the record and information life cycle; rules for paper and electronic filing systems; charge-out procedures; retention schedules; transfer methods; control measurements; imaging systems and information security. Incorporates database skills using Microsoft Access including how to plan, create, and manage data; modify a database structure; relate tables; find, filter, query and sort data; create forms and reports; and import, export and link database properties. This course offers the opportunity to earn a badge in Records and Information Life Cycle. This course will use Microsoft Office 365/Access 2019.
Total Credits
3
Prior Learning Assessment
  • Exam-College Developed Challenge Exam
Course Competencies
  1. Investigate the field of records and information management
    Assessment Strategies
    Through actual performance of the skill
    In submitted documents as specified on the unit learning plan
    In an assessment with the use of reference materials
    Criteria
    Examine how records and information are essential for business
    Compare record types and values
    Look at the records and information life cycle
    Review records formats
    Examine programs for managing records
    Explore common record system problems and challenges
    Analyze legal considerations for records management
    Study careers in records management

  2. Apply indexing rules for alphabetic filing
    Assessment Strategies
    Through actual performance of the skill
    In submitted documents as specified on the unit learning plan
    In an assessment with the use of reference materials
    Criteria
    Index personal and business names following the alphabetic filing rules
    Code personal and business names following the alphabetic filing rules
    Arrange personal and business names following the alphabetic filing rules
    Prepare cross-references for personal and business names
    Arrange cross-references for personal and business names

  3. Design a database
    Assessment Strategies
    Through actual performance of the skill
    In submitted documents as specified on the unit learning plan
    In an assessment with the use of reference materials
    Criteria
    Use 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 Lay Out View
    Perform special database operations
    Database satisfies a collection of requirements

  4. Analyze electronic records file management and electronic media and image records
    Assessment Strategies
    Through actual performance of the skill
    In submitted documents as specified on the unit learning plan
    In an assessment with the use of reference materials
    Criteria
    Analyze the electronic records life cycle
    Classify electronic records
    Explain retention and maintenance of electronic records
    Examine disposition of electronic records
    Explore the safety and security of electronic files and media records
    Manage information on mobile devices

  5. 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 cross-tab queries
    Customize the Navigation Pane

  6. 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
    Use delete queries to delete records
    Specify validation rules, default values, and formats
    Create and use single-value lookup fields
    Create and use multivalued lookup fields
    Add new fields to an existing report
    Format a datasheet
    Specify referential integrity
    Use a sub-datasheet
    Sort records

  7. Demonstrate records storage, retrieval, and transfer
    Assessment Strategies
    Through actual performance of the skill
    In submitted files as specified on the assignment sheet
    By specified assignment deadlines
    Criteria
    Investigate records storage
    Analyze records retrieval
    Explain records transfer
    Review records center control procedures

  8. Apply indexing rules for subject, numeric, and geographic filing
    Assessment Strategies
    Through actual performance of the skill
    In submitted documents as specified on the unit learning plan
    In an assessment with the use of reference materials
    Criteria
    Summarize subject, numeric, and geographic records management
    Give examples of situations and records appropriate for subject, numeric, and geographic records management
    Summarize advantages and disadvantages of storing and retrieving records by subject, by number, and by geographic location
    Compare the dictionary and encyclopedic subject file arrangements
    Examine the guides, folders, and labels used for subject, numeric, and geographic records storage
    Describe consecutive, nonconsecutive, and other numeric coding systems
    Analyze subject, numeric, and geographic indexes

  9. Create reports and forms
    Assessment Strategies
    Through actual performance of the skill
    In submitted files as specified on the assignment sheet
    By specified assignment deadlines
    Criteria
    Create reports and forms using wizards
    Modify reports and forms in La t view
    Group and sort data in a report
    Conditionally format controls
    Resize columns
    Filter records in reports and forms
    Print reports and forms
    Apply themes
    Add a field to a report or form
    Add a date
    Change the format of a control
    Move controls
    Create and print mailing labels

  10. Create a multiple-table form
    Assessment Strategies
    Through actual performance of the skill
    In submitted files as specified on the assignment sheet
    By specified assignment deadlines
    Criteria
    Add Yes/No, Long Text, OLE Object, and Attachment fields
    Use the Input Mask Wizard
    Update fields and enter data
    Change row and column size
    Create a form with a sub-form in Design view
    Modify a sub-form and form design
    Enhance a form title
    Change tab stops and tab order
    Use the form to view data and attachments
    View object dependencies
    Use Date/Time, Long Text, and Yes/No fields in a query
    Create a form with a datasheet

  11. Implement advanced report techniques
    Assessment Strategies
    Through actual performance of the skill
    In submitted files as specified on the assignment sheet
    By specified assignment deadlines
    Criteria
    Create and relate additional tables
    Create queries for reports
    Create reports in Design view
    Add fields and text boxes to a report
    Format report controls
    Group and ungroup report controls
    Update multiple report controls
    Add and modify a subreport
    Modify section properties
    Add a title, page numbers, and date to a report
    Preview, print, and publish a report
    Add totals and subtotals to a report
    Include a conditional value in a report