{"product_id":"access-2016-essentials","title":"Access 2016 Essentials","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 Essentials.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eIn this two hour course, learners will gain a fundamental understanding of this database application's environment and basic database principles. They will be able to demonstrate the correct use of key features and the ability to create and maintain tables, relationships, forms, reports, and queries.\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 Essentials 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\u003cspan\u003eAccess 2016 Essentials\u003c\/span\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003eIn this two hour course, learners will gain a fundamental understanding of this database application's environment and basic database principles. They will be able to demonstrate the correct use of key features and the ability to create and maintain tables, relationships, forms, reports, and queries.\u003c\/span\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003e\u003cmeta charset=\"utf-8\"\u003eCompleting this course will confer 2 CPD Credits towards internationally recognised \u003cstrong\u003eContinuous Professional Development\u003c\/strong\u003e Requirements within organisations operating this kind of staff development methodology.\u003cbr\u003e\u003c\/span\u003e\u003c\/p\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003ch5\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: Create and Manage a Database\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Create and Modify Databases\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eCreate a blank desktop database\u003c\/li\u003e\n\u003cli\u003eCreate a database from a template\u003c\/li\u003e\n\u003cli\u003eCreate a database by using Import objects or data from other sources\u003c\/li\u003e\n\u003cli\u003eDelete database objects\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Manage Relationships and Keys\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eCreate and modify relationships\u003c\/li\u003e\n\u003cli\u003eSet the primary key\u003c\/li\u003e\n\u003cli\u003eEnforce referential integrity\u003c\/li\u003e\n\u003cli\u003eSet foreign keys, view relationships\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Navigate through a Database\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eNavigate specific records\u003c\/li\u003e\n\u003cli\u003eCreate and modify a navigation form\u003c\/li\u003e\n\u003cli\u003eSet a form as the startup option\u003c\/li\u003e\n\u003cli\u003eDisplay objects in the Navigation Pane\u003c\/li\u003e\n\u003cli\u003eChange views of objects\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Protect and Maintain Databases\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eCompact a database\u003c\/li\u003e\n\u003cli\u003eRepair a database, back up a database\u003c\/li\u003e\n\u003cli\u003eSplit a database\u003c\/li\u003e\n\u003cli\u003eEncrypt a database with a password\u003c\/li\u003e\n\u003cli\u003eRecover data from backup\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Print and Export Data\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003ePrint reports\u003c\/li\u003e\n\u003cli\u003ePrint records\u003c\/li\u003e\n\u003cli\u003eSave a database as a template\u003c\/li\u003e\n\u003cli\u003eExport objects to alternative formats\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Two: Build tables\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Create Tables\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eCreate a table\u003c\/li\u003e\n\u003cli\u003eImport data into tables\u003c\/li\u003e\n\u003cli\u003eCreate linked tables from external sources\u003c\/li\u003e\n\u003cli\u003eImport tables from other databases\u003c\/li\u003e\n\u003cli\u003eCreate a table from a template with application parts\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Manage Tables\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eHide fields in tables\u003c\/li\u003e\n\u003cli\u003eAdd total rows\u003c\/li\u003e\n\u003cli\u003eAdd table descriptions\u003c\/li\u003e\n\u003cli\u003eRename tables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Manage Records in Tables\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eUpdate records\u003c\/li\u003e\n\u003cli\u003eAdd records\u003c\/li\u003e\n\u003cli\u003eDelete records\u003c\/li\u003e\n\u003cli\u003eAppend records from external data\u003c\/li\u003e\n\u003cli\u003eFind and replace data\u003c\/li\u003e\n\u003cli\u003eSort records, filter records\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Create and Modify Fields\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eAdd fields to tables\u003c\/li\u003e\n\u003cli\u003eAdd validation rules to fields\u003c\/li\u003e\n\u003cli\u003eChange field captions\u003c\/li\u003e\n\u003cli\u003eChange field sizes\u003c\/li\u003e\n\u003cli\u003eChange field data types\u003c\/li\u003e\n\u003cli\u003eConfigure fields to auto-increment\u003c\/li\u003e\n\u003cli\u003eSet default values\u003c\/li\u003e\n\u003cli\u003eUsing input masks\u003c\/li\u003e\n\u003cli\u003eDelete fields\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Three: Create Queries\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Create a Query\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eRun a query\u003c\/li\u003e\n\u003cli\u003eCreate a crosstab query\u003c\/li\u003e\n\u003cli\u003eCreate a parameter query\u003c\/li\u003e\n\u003cli\u003eCreate an action query\u003c\/li\u003e\n\u003cli\u003eCreate a multi-table query\u003c\/li\u003e\n\u003cli\u003eSave a query\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Modify a Query\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eRename a query\u003c\/li\u003e\n\u003cli\u003eAdd fields, remove fields\u003c\/li\u003e\n\u003cli\u003eHide fields\u003c\/li\u003e\n\u003cli\u003eSort data within queries\u003c\/li\u003e\n\u003cli\u003eFormat fields within queries\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Create Calculated Fields and Grouping within Queries\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eAdd calculated fields\u003c\/li\u003e\n\u003cli\u003eSet filtering criteria\u003c\/li\u003e\n\u003cli\u003eGroup and summarize data\u003c\/li\u003e\n\u003cli\u003eGroup data by using comparison operators\u003c\/li\u003e\n\u003cli\u003eGroup data by using arithmetic and logical operators\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Four: Create Forms\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Create a Form\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eCreate a form\u003c\/li\u003e\n\u003cli\u003eCreate a form from a template with application parts\u003c\/li\u003e\n\u003cli\u003eSave a form\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Configure Form Controls\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eMove form controls\u003c\/li\u003e\n\u003cli\u003eAdd form controls\u003c\/li\u003e\n\u003cli\u003eModify data sources\u003c\/li\u003e\n\u003cli\u003eRemove form controls\u003c\/li\u003e\n\u003cli\u003eSet form control properties\u003c\/li\u003e\n\u003cli\u003eManage labels\u003c\/li\u003e\n\u003cli\u003eAdd sub-forms\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Format a Form\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eModify tab order\u003c\/li\u003e\n\u003cli\u003eConfigure Print settings\u003c\/li\u003e\n\u003cli\u003eSort records by form field\u003c\/li\u003e\n\u003cli\u003eApply a theme\u003c\/li\u003e\n\u003cli\u003eControl form positioning\u003c\/li\u003e\n\u003cli\u003eInsert backgrounds, insert headers and footers, insert images\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Five: Create Reports\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Create a Report\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eCreate a report based on the query or table\u003c\/li\u003e\n\u003cli\u003eCreate a report in Design view\u003c\/li\u003e\n\u003cli\u003eCreate a report by using a wizard\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Configure Report Controls\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eGroup and sort fields\u003c\/li\u003e\n\u003cli\u003eModify data sources\u003c\/li\u003e\n\u003cli\u003eAdd report controls\u003c\/li\u003e\n\u003cli\u003eAdd and modify labels\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003e    Format a Report\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eFormat a report into multiple columns\u003c\/li\u003e\n\u003cli\u003eAdd calculated fields\u003c\/li\u003e\n\u003cli\u003eControl report positioning\u003c\/li\u003e\n\u003cli\u003eFormat report elements\u003c\/li\u003e\n\u003cli\u003eChange report orientation\u003c\/li\u003e\n\u003cli\u003eInsert header and footer information\u003c\/li\u003e\n\u003cli\u003eInsert images\u003c\/li\u003e\n\u003cli\u003eApply a theme\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-advanced\"\u003eAccess 2013 Advanced\u003c\/a\u003e  |  \u003ca href=\"\/products\/access-2013-essentials\"\u003eAccess 2013 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 2016 Essentials\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":14359113498687,"sku":"ITLU003","price":44.0,"currency_code":"USD","in_stock":true},{"title":"5 Licences (EUR 35 each)","offer_id":59260628500828,"sku":null,"price":193.0,"currency_code":"USD","in_stock":true},{"title":"10 Licences (EUR 30 each)","offer_id":59260628533596,"sku":null,"price":330.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0077\/7604\/3071\/products\/ITLU002_Access_2016_Essentials_1.png?v=1590011691","url":"https:\/\/www.ebsiamericas.com\/products\/access-2016-essentials","provider":"eBSI Export Academy","version":"1.0","type":"link"}