{"@id":"https://credentialengineregistry.org/resources/ce-d830b90e-1932-4227-9173-27c2ee5d45da","@type":"ceterms:Certificate","@context":"https://credreg.net/ctdl/schema/context/json","ceterms:ctid":"ce-d830b90e-1932-4227-9173-27c2ee5d45da","ceterms:name":{"en-US":"Microsoft Access Level 3"},"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 and Microsoft Access Level 2"},"ceterms:targetCompetency":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:targetNodeName":{"en-US":"Upon successful completion of this course, students will be able to:  -Restructure data into appropriate tables to ensure data dependency and minimize redundancy  -Write advanced queries to analyze and summarize data  -Create and revise Microsoft Office Access macros  -Customize reports by using various Microsoft Office Access features  -Maintain their databases using Microsoft Office Access tools"}}]}],"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":"7985"},{"@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":"9 - Pikes Peak 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 - No"},"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 - No"},"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 - Yes"},"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 - Yes"},"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":"Your training from Access Level 1 and Level 2 has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft Office Access. You have worked with the various Access objects, such as tables, queries, forms, and reports.  Now it's time to extend what you can with your database application.    In this class, you will advance your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros (automation), enhancing forms and reports, and maintaining the database."},"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."}}]}