-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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