{"product_id":"access-2013-advanced","title":"Access 2013 Advanced","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 2013 Advanced.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eThis course is designed to teach you a deeper understanding of Access 2013 in a practical way. The participants will learn how to use the advance features of Access to help them better manage a database. This course incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.\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 2013 Advanced 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 class=\"ng-scope\"\u003eThis course is designed to teach you a deeper understanding of Access 2013 in a practical way. The participants will learn how to use the advance features of Access to help them better manage a database. This course incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003eThis course is meant to provide a safe learning environment where they can practice and learn Access 2013 Advanced functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose―enable users to create data-centric web applications. Taking the time to learn the advanced features of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cmeta charset=\"utf-8\"\u003e\u003cspan\u003eCompleting this course will confer 2 CPD Credits towards internationally recognised \u003c\/span\u003e\u003cstrong\u003eContinuous Professional Development\u003c\/strong\u003e\u003cspan\u003e Requirements within organisations operating this kind of staff development methodology.\u003c\/span\u003e\u003cbr\u003e\u003c\/p\u003e\n\u003ch5 class=\"ng-scope\"\u003e\u003cspan style=\"text-decoration: underline;\"\u003e\u003cstrong\u003eCourse Outline\u003c\/strong\u003e\u003c\/span\u003e\u003c\/h5\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule One: Getting Started\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Two: Using App Views\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eUnderstanding Views\u003c\/li\u003e\n\u003cli\u003eAdding a New View\u003c\/li\u003e\n\u003cli\u003eEditing a View\u003c\/li\u003e\n\u003cli\u003eDeleting a View\u003c\/li\u003e\n\u003cli\u003eAdding a Popup View\u003c\/li\u003e\n\u003cli\u003eModule Two: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Three: Customizing Apps (I)\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eChecking Your Database Name or Server Location\u003c\/li\u003e\n\u003cli\u003eModifying the Action Bar\u003c\/li\u003e\n\u003cli\u003eOpening a Table for Editing\u003c\/li\u003e\n\u003cli\u003eMoving, Resizing, or Deleting Controls\u003c\/li\u003e\n\u003cli\u003eModule Three: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Four: Customizing Apps (II)\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eAdding Controls from the Ribbon\u003c\/li\u003e\n\u003cli\u003eAdding Controls from the Field List\u003c\/li\u003e\n\u003cli\u003eChanging Control Properties\u003c\/li\u003e\n\u003cli\u003eModule Four: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Five: Advanced Record Tasks\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eShowing Totals\u003c\/li\u003e\n\u003cli\u003eAdding from Outlook\u003c\/li\u003e\n\u003cli\u003eSaving a Record as an Outlook Contact\u003c\/li\u003e\n\u003cli\u003eAdjust Row Height\u003c\/li\u003e\n\u003cli\u003eHiding and Un-hiding Fields\u003c\/li\u003e\n\u003cli\u003eFreezing and Unfreezing Fields\u003c\/li\u003e\n\u003cli\u003eFormatting Text\u003c\/li\u003e\n\u003cli\u003eModule Five: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Six: Adding Other Types of Fields\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eAdding Rich Text and Long Text Fields\u003c\/li\u003e\n\u003cli\u003eAdding Attachment Fields\u003c\/li\u003e\n\u003cli\u003eAdding Hyperlink Fields\u003c\/li\u003e\n\u003cli\u003eAdding Lookup \u0026amp; Relationship Fields\u003c\/li\u003e\n\u003cli\u003eAdding Calculated Fields\u003c\/li\u003e\n\u003cli\u003eModule Six: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Seven: Advanced Field Tasks\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eAdjusting the Field Size\/Width\u003c\/li\u003e\n\u003cli\u003eSetting Field Default Value\u003c\/li\u003e\n\u003cli\u003eWorking with More Fields\u003c\/li\u003e\n\u003cli\u003eWorking with Field Validation Options\u003c\/li\u003e\n\u003cli\u003eUsing the Field List\u003c\/li\u003e\n\u003cli\u003eModule Seven: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Eight: Working in Table Design View\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eOpening Design View\u003c\/li\u003e\n\u003cli\u003eWorking with Field Properties\u003c\/li\u003e\n\u003cli\u003eSetting the Primary Key\u003c\/li\u003e\n\u003cli\u003eUsing the Properties Sheet\u003c\/li\u003e\n\u003cli\u003eWorking with Table Properties\u003c\/li\u003e\n\u003cli\u003eViewing Table Relationships\u003c\/li\u003e\n\u003cli\u003eUsing Relationship Tools\u003c\/li\u003e\n\u003cli\u003eViewing Object Dependencies\u003c\/li\u003e\n\u003cli\u003eModule Eight: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Nine: Working with External Data\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eLinking Data\u003c\/li\u003e\n\u003cli\u003eImporting Data\u003c\/li\u003e\n\u003cli\u003eUsing the Table Analyzer\u003c\/li\u003e\n\u003cli\u003eRefreshing Data\u003c\/li\u003e\n\u003cli\u003eExporting Data\u003c\/li\u003e\n\u003cli\u003eModule Nine: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Ten: Creating Queries\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eCreating a Select Query\u003c\/li\u003e\n\u003cli\u003eCreating a Make Table Query\u003c\/li\u003e\n\u003cli\u003eCreating an Append Query\u003c\/li\u003e\n\u003cli\u003eCreating a Cross tab Query\u003c\/li\u003e\n\u003cli\u003eShowing and Removing Tables\u003c\/li\u003e\n\u003cli\u003eModule Ten: Review Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Eleven: Creating Queries\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eModule Eleven: Creating Forms and Reports\u003c\/li\u003e\n\u003cli\u003eCreating a Form with the Form Wizard\u003c\/li\u003e\n\u003cli\u003eCreating a Report with the Report Wizard\u003c\/li\u003e\n\u003cli\u003eModifying Form Layout\u003c\/li\u003e\n\u003cli\u003eNavigating the Field List\u003c\/li\u003e\n\u003cli\u003eKey Features on the Form Tools Tabs\u003c\/li\u003e\n\u003cli\u003eKey Features on the Report Tools Tabs\u003c\/li\u003e\n\u003cli\u003eModule Eleven: Review Questions\u003c\/li\u003e\n\u003c\/ul\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-2013-essentials\"\u003eAccess 2013 Essentials\u003c\/a\u003e  |  \u003ca href=\"\/products\/access-2016-essentials\"\u003eAccess 2016 Essentials\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 2013 Advanced\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":14358964994111,"sku":"ITLU009","price":44.0,"currency_code":"USD","in_stock":true},{"title":"5 Licences (EUR 35 each)","offer_id":59260628107612,"sku":null,"price":193.0,"currency_code":"USD","in_stock":true},{"title":"10 Licences (EUR 30 each)","offer_id":59260628140380,"sku":null,"price":330.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0077\/7604\/3071\/products\/ITLU009_Access_2013_Advanced_1.png?v=1592855329","url":"https:\/\/www.ebsiamericas.com\/products\/access-2013-advanced","provider":"eBSI Export Academy","version":"1.0","type":"link"}