{"@id":"https://credentialengineregistry.org/resources/ce-85df7f89-9f64-4d43-b278-f74183c617f1","@type":"ceterms:Certificate","@context":"https://credreg.net/ctdl/schema/context/json","ceterms:ctid":"ce-85df7f89-9f64-4d43-b278-f74183c617f1","ceterms:name":{"en-US":"Microsoft Access Level 2"},"ceterms:ownedBy":["https://credentialengineregistry.org/resources/ce-36adee66-17a0-41f6-b862-d0d49c1a595c"],"ceterms:requires":[{"@type":"ceterms:ConditionProfile","ceterms:name":{"en-US":"Entry Conditions"},"ceterms:creditValue":[{"@type":"ceterms:ValueProfile","schema:value":7.0,"ceterms:creditUnitType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CreditUnit","ceterms:targetNode":"creditUnit:ContactHour","ceterms:frameworkName":{"en-US":"Credit Unit"},"ceterms:targetNodeName":{"en-US":"Contact Hour"},"ceterms:targetNodeDescription":{"en-US":"Credit that is issued or accepted as being related to one or more temporal hours of instruction presented to students."}}]}],"ceterms:description":{"en-US":"Microsoft Access Level 1"},"ceterms:targetCompetency":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:targetNodeName":{"en-US":"Upon successful completion of this course, students will be able to:  -Modify the design and field properties of a table to streamline data entry and maintain data integrity.  -Retrieve data from tables using joins.  -Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.  -Enhance the capabilities of a form by grouping form controls and making other aesthetic improvements to make forms work more efficiently and intuitively for the user.  -Customize reports to organize the displayed information and produce specific print layouts.  -Share data across different applications."}}]}],"ceterms:offeredBy":["https://credentialengineregistry.org/resources/ce-36adee66-17a0-41f6-b862-d0d49c1a595c"],"ceterms:identifier":[{"@type":"ceterms:IdentifierValue","ceterms:identifierTypeName":{"en-US":"Program_System_ID"},"ceterms:identifierValueCode":"7983"},{"@type":"ceterms:IdentifierValue","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"1 - Adams County Workforce \u0026 Business Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"11 - Pueblo Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"1 - Adams County Workforce \u0026 Business Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"2 - Arapahoe/Douglas Works!"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"3 - Broomfield Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"4 - \"Denver Workforce Center - Office of Economic Development, Divison of Workforce Development\""},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"5 - Larimer County Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"6 - Employment Service-Weld County"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"7 - Jefferson County Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"8 - Workforce Boulder County"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"9 - Pikes Peak Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"10 - Mesa County Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"11 - Pueblo Workforce Center"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"12 - Mountain - Rural Resort"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"13 - Northwest Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"14 - Upper Arkansas Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"15 - Southwest Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"16 - Western Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"17 - Southeast Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - Yes"},"ceterms:identifierValueCode":"18 - Eastern Region - Colorado Rural Workforce Consortium"},{"@type":"ceterms:IdentifierValue","ceterms:identifierType":"colorado:ETPL_WIOA_Funding","ceterms:identifierTypeName":{"en-US":"WIOA Funded - No"},"ceterms:identifierValueCode":"19 - Southcentral Region - Colorado Rural Workforce Consortium"}],"ceterms:inLanguage":["en"],"ceterms:availableAt":[{"@type":"ceterms:Place","ceterms:name":{"en-US":"Primary Address"},"ceterms:latitude":39.76894230000001,"ceterms:longitude":-104.981099,"ceterms:postalCode":"80216","ceterms:addressRegion":{"en-US":"Colorado"},"ceterms:streetAddress":{"en-US":"3327 Brighton Blvd. Suite 130"},"ceterms:addressCountry":{"en-US":"United States"},"ceterms:addressLocality":{"en-US":"Denver"}},{"@type":"ceterms:Place","ceterms:name":{"en-US":"Digital Workshop Center - Main Location"},"ceterms:latitude":40.5833173,"ceterms:longitude":-105.0750346,"ceterms:postalCode":"80524","ceterms:addressRegion":{"en-US":"Colorado"},"ceterms:streetAddress":{"en-US":"324 Remington Street, Suite 130"},"ceterms:addressCountry":{"en-US":"United States"},"ceterms:addressLocality":{"en-US":"Fort Collins"}}],"ceterms:description":{"en-US":"You have the basic skills needed to work with Microsoft Office Access databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills.    In this class, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications."},"ceterms:estimatedCost":[{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Cost Profile"},"ceterms:price":649.0,"ceterms:currency":"US Dollar","ceterms:costDetails":"https://digitalworkshopcenter.com","ceterms:description":{"en-US":"This is the summary of the costs associated with this credential."},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:Tuition","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Tuition"},"ceterms:targetNodeDescription":{"en-US":"Cost for teaching and instruction."}}},{"@type":"ceterms:CostProfile","ceterms:name":{"en-US":"Cost Profile"},"ceterms:price":649.0,"ceterms:currency":"US Dollar","ceterms:costDetails":"https://digitalworkshopcenter.com","ceterms:description":{"en-US":"This is the summary of the costs associated with this credential."},"ceterms:directCostType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CostType","ceterms:targetNode":"costType:AggregateCost","ceterms:frameworkName":{"en-US":"Cost Type"},"ceterms:targetNodeName":{"en-US":"Aggregate Cost"},"ceterms:targetNodeDescription":{"en-US":"Sum of direct costs."}}}],"ceterms:occupationType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://www.onetcenter.org/taxonomy.html","ceterms:targetNode":"https://www.onetonline.org/link/summary/15-1141.00","ceterms:codedNotation":"15-1141.00","ceterms:frameworkName":{"en-US":"Standard Occupational Classification"},"ceterms:targetNodeName":{"en-US":"Database Administrators"},"ceterms:targetNodeDescription":{"en-US":"Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases."}}],"ceterms:subjectWebpage":"https://digitalworkshopcenter.com","ceterms:audienceLevelType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/AudienceLevel","ceterms:targetNode":"audLevel:PostSecondaryLevel","ceterms:frameworkName":{"en-US":"Audience Level"},"ceterms:targetNodeName":{"en-US":"Post-Secondary Level"},"ceterms:targetNodeDescription":{"en-US":"Intended for those who have completed secondary level school programs or equivalent."}}],"ceterms:estimatedDuration":[{"@type":"ceterms:DurationProfile","ceterms:exactDuration":"PT7H"}],"ceterms:credentialStatusType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CredentialStatus","ceterms:targetNode":"credentialStat:Active","ceterms:frameworkName":{"en-US":"Credential Status"},"ceterms:targetNodeName":{"en-US":"Active"},"ceterms:targetNodeDescription":{"en-US":"Awards of the credential are ongoing."}},"ceterms:learningDeliveryType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/Delivery","ceterms:targetNode":"deliveryType:BlendedDelivery","ceterms:frameworkName":{"en-US":"Delivery Type"},"ceterms:targetNodeName":{"en-US":"Blended Delivery"},"ceterms:targetNodeDescription":{"en-US":"Delivery includes significant levels of both in person and online."}}],"ceterms:instructionalProgramType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://nces.ed.gov/ipeds/cipcode/Default.aspx?y=56","ceterms:targetNode":"https://nces.ed.gov/ipeds/cipcode/cipdetail.aspx?y=56\u0026cip=11.0802","ceterms:codedNotation":"11.0802","ceterms:frameworkName":{"en-US":"Classification of Instructional Programs"},"ceterms:targetNodeName":{"en-US":"Data Modeling/Warehousing and Database Administration"},"ceterms:targetNodeDescription":{"en-US":"A program that prepares individuals to design and manage the construction of databases and related software programs and applications, including the linking of individual data sets to create complex searchable databases (warehousing) and the use of analytical search tools (mining). Includes instruction in database theory, logic, and semantics; operational and warehouse modeling; dimensionality; attributes and hierarchies; data definition; technical architecture; access and security design; integration; formatting and extraction; data delivery; index design; implementation problems; planning and budgeting; and client and networking issues."}}]}