{"product_id":"access-2016-expert","title":"Access 2016 Expert","description":"\u003cdiv class=\"ebsi-team-licence-note\"\u003e\u003cp\u003e\u003cstrong\u003eBuying for a team?\u003c\/strong\u003e\u003cbr\u003eChoose 5 or 10 licences to purchase access for multiple learners at a reduced per-person rate. After purchase, eBSI will contact you to confirm the learner details and arrange course access for each participant.\u003c\/p\u003e\u003c\/div\u003e\n\u003c!-- ebsi-sales-wrapper --\u003e\u003cdiv class=\"ebsi-sales-wrapper\"\u003e\n\u003cp\u003e\u003cstrong\u003eDevelop practical knowledge and confidence in Access 2016 Expert.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eAccess 2016 Expert Objectives: This two hour course will help learners to design databases at an expert level or improve existing Access databases. Also, advanced conversion of databases made in other applications and spreadsheet (flat file) databases.\u003c\/p\u003e\n\u003ch3\u003eWhy this course matters\u003c\/h3\u003e\n\u003cp\u003eThis course turns the subject into practical, structured learning you can apply in real business and workplace situations. It is designed to help you move beyond definitions and understand how the ideas, tools and decisions covered in the course fit together.\u003c\/p\u003e\n\u003ch3\u003eWhat you will gain\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eUse the key features and workflows covered in Access 2016 Expert with greater confidence.\u003c\/li\u003e\n\u003cli\u003eApply the tools and techniques to practical business tasks.\u003c\/li\u003e\n\u003cli\u003eRecognise common mistakes and work more efficiently in day-to-day use.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eWho is this course for?\u003c\/h3\u003e\n\u003cp\u003eThis course is suitable for business users, administrators, managers and professionals who want to work more efficiently with everyday digital tools.\u003c\/p\u003e\n\u003ch3\u003eCourse at a glance\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eFormat:\u003c\/strong\u003e self-paced online learning.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProfessional development:\u003c\/strong\u003e CPD course.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cp\u003e\u003cstrong\u003eAccess 2016 Expert\u003c\/strong\u003e\u003cbr\u003eObjectives: This two hour course will help learners to design databases at an expert level or improve existing Access databases. Also, advanced conversion of databases made in other applications and spreadsheet (flat file) databases. \u003c\/p\u003e\n\u003cp\u003e\u003cmeta charset=\"utf-8\"\u003e\u003cspan data-mce-fragment=\"1\"\u003eCompleting this course will confer 2 CPD Credits towards internationally recognised \u003c\/span\u003e\u003cstrong data-mce-fragment=\"1\"\u003eContinuous Professional Development\u003c\/strong\u003e\u003cspan data-mce-fragment=\"1\"\u003e Requirements within organisations operating this kind of staff development methodology.\u003c\/span\u003e\u003c\/p\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003ch5\u003eUnit Contents:\u003c\/h5\u003e\n\u003cp\u003e\u003cbr\u003e \u003cstrong\u003e1. Getting Started\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover a basic introduction to the course unit and its objectives.\u003cbr\u003e\u003cbr\u003e \u003cstrong\u003e2. Managing Relational Databases\u003c\/strong\u003e \u003cbr\u003eIn this topic you will cover: \u003cbr\u003eManaging Relational Databases \u003cbr\u003eDatabase Concepts\u003cbr\u003eDatabase Design\u003cbr\u003eNormalisation\u003cbr\u003eDatabase Integrity\u003cbr\u003eTypes of Relationship\u003cbr\u003eCreating Table Links\u003cbr\u003eReferential Integrity\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e \u003cstrong\u003e3. Customising Forms\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eCustomising Forms \u003cbr\u003eList And Combo Boxes\u003cbr\u003eCheck Boxes, Option \u0026amp; Toggle Buttons.\u003cbr\u003eOption Groups\u003cbr\u003eCommand Buttons\u003cbr\u003eCalculated Fields\u003cbr\u003eUsing Form’s Input Values\u003cbr\u003eCreate A Form With Multiple Pages Or Tabs\u003cbr\u003eTab Order\u003cbr\u003eInserting Graphics in Forms or Reports\u003cbr\u003eAutoFormat\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e \u003cstrong\u003e4. Optimise and Administer Access\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eOptimise and Administer Access \u003cbr\u003eOptimising Performance\u003cbr\u003eThe Performance Analyzer\u003cbr\u003eThe Add in Manager\u003cbr\u003eCompacting Your Database\u003cbr\u003eThe Database Documentor\u003cbr\u003eThe Database Splitter\u003cbr\u003eRecovering Damaged Databases\u003cbr\u003eImporting and Linking Tables\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e \u003cstrong\u003e5. Introduction to SQL\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eIntroduction to SQL \u003cbr\u003eIntroduction\u003cbr\u003eData Definition Language\u003cbr\u003eData Manipulation Language\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e \u003cstrong\u003e6. Wrapping Up \/ Assessment Result\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eCourse Conclusion\u003cbr\u003eWrapping up\u003cbr\u003eTest Results Summary\u003cbr\u003e\u003cbr\u003e\u003c\/p\u003e\n\u003c!-- ebsi-cross-sell --\u003e\u003cdiv class=\"ebsi-cross-sell\"\u003e\n\u003ch3\u003eContinue your learning\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003ePart of this learning pathway:\u003c\/strong\u003e \u003ca href=\"\/collections\/microsoft-office-skills\"\u003eMicrosoft Office \u0026amp; Windows\u003c\/a\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eLearners also take:\u003c\/strong\u003e \u003ca href=\"\/products\/access-2016-advanced\"\u003eAccess 2016 Advanced\u003c\/a\u003e\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c!-- ebsi-academy-breadcrumb --\u003e\n\u003chr\u003e\u003cdiv class=\"ebsi-course-pathway\"\u003e\n\u003cp\u003e\u003cstrong\u003eCourse pathway:\u003c\/strong\u003e \u003ca href=\"\/pages\/welcome-to-ebsi-sme-academy\"\u003eeBSI SME Academy\u003c\/a\u003e \u0026gt; \u003ca href=\"\/collections\/microsoft-office-skills\"\u003eMicrosoft Office \u0026amp; Windows\u003c\/a\u003e \u0026gt; Access 2016 Expert\u003c\/p\u003e\n\u003cp\u003eExplore more \u003ca href=\"\/collections\/microsoft-office-skills\"\u003eMicrosoft Office \u0026amp; Windows\u003c\/a\u003e training or return to the \u003ca href=\"\/pages\/welcome-to-ebsi-sme-academy\"\u003eeBSI SME Academy\u003c\/a\u003e.\u003c\/p\u003e\n\u003c\/div\u003e","brand":"eBSI Export Academy","offers":[{"title":"Individual Licence (EUR 40)","offer_id":35289067389088,"sku":"ITLU053","price":44.0,"currency_code":"USD","in_stock":true},{"title":"5 Licences (EUR 35 each)","offer_id":59260638724444,"sku":null,"price":193.0,"currency_code":"USD","in_stock":true},{"title":"10 Licences (EUR 30 each)","offer_id":59260638757212,"sku":null,"price":330.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0077\/7604\/3071\/products\/ITLU053Access2016ExpertCover.png?v=1595625107","url":"https:\/\/www.ebsiamericas.com\/products\/access-2016-expert","provider":"eBSI Export Academy","version":"1.0","type":"link"}