{"product_id":"access-2016-part-1","title":"Access 2016 Master","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 Master.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eMicrosoft Office Access 2016 is the newest version of Microsoft’s popular database program. This is the second part of a two-level course, and it explores advanced Access features. Whether you’re using Access for the first time, or have been using it for years, this course will help you make the most of Access 2016’s features and tools.\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 Master 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\u003eStudy time:\u003c\/strong\u003e approximately 4 hours.\u003c\/li\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 is a 2 part course.\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cspan style=\"text-decoration: underline;\"\u003e\u003cstrong\u003ePART 1\u003c\/strong\u003e\u003c\/span\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003eThe Microsoft Access 2016 Part One program covers all the basics, including:\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eAn introduction to the Access interface\u003c\/li\u003e\n\u003cli\u003eThe basics of creating a database with tables, forms, queries, and reports\u003c\/li\u003e\n\u003cli\u003eTable management tools, including data normalization and the Relationships window\u003c\/li\u003e\n\u003cli\u003eTechniques for importing and exporting data with Access\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cu\u003e\u003cstrong\u003eCourse Topics:\u003c\/strong\u003e\u003c\/u\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 1:\u2028Getting Started with Access\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eMicrosoft Access 2016\u003c\/li\u003e\n\u003cli\u003eAccess Files\u003c\/li\u003e\n\u003cli\u003eOpening Databases\u003c\/li\u003e\n\u003cli\u003eAccess Web Apps\u003c\/li\u003e\n\u003cli\u003eThe Access 2016 Application Window\u003c\/li\u003e\n\u003cli\u003eTables\u003c\/li\u003e\n\u003cli\u003eForms and Views\u003c\/li\u003e\n\u003cli\u003eQueries\u003c\/li\u003e\n\u003cli\u003eReports\u003c\/li\u003e\n\u003cli\u003eThe Ribbon Interface\u003c\/li\u003e\n\u003cli\u003eActivity 1-1\u003c\/li\u003e\n\u003cli\u003eDatabase Templates\u003c\/li\u003e\n\u003cli\u003eWeb App Templates\u003c\/li\u003e\n\u003cli\u003eSave Options\u003c\/li\u003e\n\u003cli\u003eField Definition\u003c\/li\u003e\n\u003cli\u003eMethods to Create a Form\u003c\/li\u003e\n\u003cli\u003eForm Object Views\u003c\/li\u003e\n\u003cli\u003eForm Sections\u003c\/li\u003e\n\u003cli\u003eModifying Existing Forms\u003c\/li\u003e\n\u003cli\u003eSaving Forms\u003c\/li\u003e\n\u003cli\u003eDeleting Forms\u003c\/li\u003e\n\u003cli\u003eAccess Web App Views\u003c\/li\u003e\n\u003cli\u003eActivity 1-2\u003c\/li\u003e\n\u003cli\u003eUsing Tell Me\u003c\/li\u003e\n\u003cli\u003eAccessing Advanced Help Options\u003c\/li\u003e\n\u003cli\u003eActivity 1-3\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 2:\u2028Working with Table Data\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eAutoCorrect\u003c\/li\u003e\n\u003cli\u003eCommit, Save, and Undo\u003c\/li\u003e\n\u003cli\u003eQuick Search\u003c\/li\u003e\n\u003cli\u003eThe Find and Replace Dialog Box\u003c\/li\u003e\n\u003cli\u003eDatasheet Totals\u003c\/li\u003e\n\u003cli\u003eActivity 2-1\u003c\/li\u003e\n\u003cli\u003eAdding New Records\u003c\/li\u003e\n\u003cli\u003eUpdating Records with a Query\u003c\/li\u003e\n\u003cli\u003eAppend Queries\u003c\/li\u003e\n\u003cli\u003eNavigating Through Records\u003c\/li\u003e\n\u003cli\u003ePrinting Records\u003c\/li\u003e\n\u003cli\u003eActivity 2-2\u003c\/li\u003e\n\u003cli\u003eThe Sort Feature\u003c\/li\u003e\n\u003cli\u003eThe Filter Feature\u003c\/li\u003e\n\u003cli\u003eFilter Commands\u003c\/li\u003e\n\u003cli\u003eThe Group Feature\u003c\/li\u003e\n\u003cli\u003eActivity 2-3\u003c\/li\u003e\n\u003cli\u003eLookup Fields\u003c\/li\u003e\n\u003cli\u003eThe Property Sheet Pane\u003c\/li\u003e\n\u003cli\u003eActivity 2-4\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 3:\u2028Querying a Database\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eQuery Views\u003c\/li\u003e\n\u003cli\u003eThe Simple Query Wizard\u003c\/li\u003e\n\u003cli\u003eTypes of Queries\u003c\/li\u003e\n\u003cli\u003eThe Run Command\u003c\/li\u003e\n\u003cli\u003eQuery Design\u003c\/li\u003e\n\u003cli\u003eSaving Queries\u003c\/li\u003e\n\u003cli\u003eDeleting Queries\u003c\/li\u003e\n\u003cli\u003eRenaming Queries\u003c\/li\u003e\n\u003cli\u003eActivity 3-1\u003c\/li\u003e\n\u003cli\u003eQuery Criteria\u003c\/li\u003e\n\u003cli\u003eComparison Operators\u003c\/li\u003e\n\u003cli\u003eLogical Operators\u003c\/li\u003e\n\u003cli\u003eSorting Query Results\u003c\/li\u003e\n\u003cli\u003eGrouping Query Results\u003c\/li\u003e\n\u003cli\u003eFormatting Query Fields\u003c\/li\u003e\n\u003cli\u003eThe Zoom Dialog Box\u003c\/li\u003e\n\u003cli\u003eActivity 3-2\u003c\/li\u003e\n\u003cli\u003eArithmetic Operators\u003c\/li\u003e\n\u003cli\u003eAdding Calculated Fields\u003c\/li\u003e\n\u003cli\u003eAdding Conditional Logic\u003c\/li\u003e\n\u003cli\u003eActivity 3-3\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 4:\u2028Creating Advanced Queries\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eParameter Queries\u003c\/li\u003e\n\u003cli\u003eWildcards in a Parameter Query\u003c\/li\u003e\n\u003cli\u003eThe Ampersand Operator\u003c\/li\u003e\n\u003cli\u003eActivity 4-1\u003c\/li\u003e\n\u003cli\u003eAction Queries\u003c\/li\u003e\n\u003cli\u003eTypes of Action Queries\u003c\/li\u003e\n\u003cli\u003eActivity 4-2\u003c\/li\u003e\n\u003cli\u003eThe Find Duplicates Query Wizard\u003c\/li\u003e\n\u003cli\u003eThe Find Unmatched Query Wizard\u003c\/li\u003e\n\u003cli\u003eActivity 4-3\u003c\/li\u003e\n\u003cli\u003eCrosstab Queries\u003c\/li\u003e\n\u003cli\u003eMultiple Table Queries\u003c\/li\u003e\n\u003cli\u003eActivity 4-4\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 5:\u2028Generating Reports\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eReport Creation Tools\u003c\/li\u003e\n\u003cli\u003eUsing Application Parts to Create Reports\u003c\/li\u003e\n\u003cli\u003eReport Views\u003c\/li\u003e\n\u003cli\u003eThe Report Wizard\u003c\/li\u003e\n\u003cli\u003eSaving a Report\u003c\/li\u003e\n\u003cli\u003eModifying an Existing Report\u003c\/li\u003e\n\u003cli\u003eDeleting a Report\u003c\/li\u003e\n\u003cli\u003eActivity 5-1\u003c\/li\u003e\n\u003cli\u003eReport Sections\u003c\/li\u003e\n\u003cli\u003eAdding Controls\u003c\/li\u003e\n\u003cli\u003eModifying Control Properties\u003c\/li\u003e\n\u003cli\u003eManaging Labels\u003c\/li\u003e\n\u003cli\u003eInserting Images\u003c\/li\u003e\n\u003cli\u003eActivity 5-2\u003c\/li\u003e\n\u003cli\u003eGalleries\u003c\/li\u003e\n\u003cli\u003eThemes\u003c\/li\u003e\n\u003cli\u003eActivity 5-3\u003c\/li\u003e\n\u003cli\u003eAdding a Header or Footer\u003c\/li\u003e\n\u003cli\u003eInserting Page Numbers\u003c\/li\u003e\n\u003cli\u003ePage Setup Options\u003c\/li\u003e\n\u003cli\u003eThe Print Preview Tab\u003c\/li\u003e\n\u003cli\u003eActivity 5-4\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 6:\u2028Customizing the Access Environment\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eAccess Options\u003c\/li\u003e\n\u003cli\u003eActivity 6-1\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 7:\u2028Designing a Relational Database\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eRelational Databases\u003c\/li\u003e\n\u003cli\u003eThe Relational Database Design Process\u003c\/li\u003e\n\u003cli\u003eThe Statement of Purpose\u003c\/li\u003e\n\u003cli\u003eExisting Data\u003c\/li\u003e\n\u003cli\u003eGuidelines for Determining Fields\u003c\/li\u003e\n\u003cli\u003eBusiness Rules\u003c\/li\u003e\n\u003cli\u003eGuidelines for Grouping Fields into Tables\u003c\/li\u003e\n\u003cli\u003ePrimary Keys\u003c\/li\u003e\n\u003cli\u003eForeign Keys\u003c\/li\u003e\n\u003cli\u003eComposite Keys\u003c\/li\u003e\n\u003cli\u003eTable Relationships\u003c\/li\u003e\n\u003cli\u003eActivity 7-1\u003c\/li\u003e\n\u003cli\u003eTable Creation Options\u003c\/li\u003e\n\u003cli\u003eImporting Tables from Other Databases\u003c\/li\u003e\n\u003cli\u003eCreating Tables with Templates\u003c\/li\u003e\n\u003cli\u003eTable Views\u003c\/li\u003e\n\u003cli\u003eData Types\u003c\/li\u003e\n\u003cli\u003eInserting Fields\u003c\/li\u003e\n\u003cli\u003eQuick Start Fields\u003c\/li\u003e\n\u003cli\u003eDeleting Fields\u003c\/li\u003e\n\u003cli\u003eCalendar for Picking Dates\u003c\/li\u003e\n\u003cli\u003eThe Lookup Wizard\u003c\/li\u003e\n\u003cli\u003eThe Table Properties Dialog Box\u003c\/li\u003e\n\u003cli\u003eActivity 7-2\u003c\/li\u003e\n\u003cli\u003eRenaming a Table\u003c\/li\u003e\n\u003cli\u003eChanging Field Captions\u003c\/li\u003e\n\u003cli\u003eChanging Field Sizes\u003c\/li\u003e\n\u003cli\u003eConfiguring Fields to Auto-Increment\u003c\/li\u003e\n\u003cli\u003eSetting the Default Value for a Field\u003c\/li\u003e\n\u003cli\u003eActivity 7-3\u003c\/li\u003e\n\u003cli\u003eThe Relationships Window\u003c\/li\u003e\n\u003cli\u003eReferential Integrity\u003c\/li\u003e\n\u003cli\u003eGuidelines for Enforcing Referential Integrity\u003c\/li\u003e\n\u003cli\u003eThe Edit Relationships Dialog Box\u003c\/li\u003e\n\u003cli\u003eJoin Lines\u003c\/li\u003e\n\u003cli\u003eRelationship Report\u003c\/li\u003e\n\u003cli\u003eActivity 7-4\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 8:\u2028Joining Tables\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eQuery Joins\u003c\/li\u003e\n\u003cli\u003eInner Joins\u003c\/li\u003e\n\u003cli\u003eOuter Joins\u003c\/li\u003e\n\u003cli\u003eThe Join Properties Dialog Box\u003c\/li\u003e\n\u003cli\u003eActivity 8-1\u003c\/li\u003e\n\u003cli\u003eJoining Tables with No Common Fields\u003c\/li\u003e\n\u003cli\u003eActivity 8-2\u003c\/li\u003e\n\u003cli\u003eSelf-Joins\u003c\/li\u003e\n\u003cli\u003eThe Alias Property\u003c\/li\u003e\n\u003cli\u003eActivity 8-3\u003c\/li\u003e\n\u003cli\u003eSubdatasheets\u003c\/li\u003e\n\u003cli\u003eActivity 8-4\u003c\/li\u003e\n\u003cli\u003eSubqueries\u003c\/li\u003e\n\u003cli\u003eActivity 8-5\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 9:\u2028Organizing a Database for Efficiency\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eFirst Normal Form\u003c\/li\u003e\n\u003cli\u003eSecond Normal Form\u003c\/li\u003e\n\u003cli\u003eThird Normal Form\u003c\/li\u003e\n\u003cli\u003eDenormalization\u003c\/li\u003e\n\u003cli\u003eThe Table Analyzer Wizard\u003c\/li\u003e\n\u003cli\u003eActivity 9-1\u003c\/li\u003e\n\u003cli\u003eMany-to-Many Relationships\u003c\/li\u003e\n\u003cli\u003eJunction Tables\u003c\/li\u003e\n\u003cli\u003eActivity 9-2\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 10:\u2028 Sharing Data Across Applications\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eData Importing\u003c\/li\u003e\n\u003cli\u003eThe Get External Data Wizard\u003c\/li\u003e\n\u003cli\u003eDelimiters\u003c\/li\u003e\n\u003cli\u003eActivity 10-1\u003c\/li\u003e\n\u003cli\u003eData Exporting\u003c\/li\u003e\n\u003cli\u003eActivity 10-2\u003c\/li\u003e\n\u003cli\u003eExporting Access Data to Excel\u003c\/li\u003e\n\u003cli\u003eActivity 10-3\u003c\/li\u003e\n\u003cli\u003eThe Microsoft Word Mail Merge Wizard\u003c\/li\u003e\n\u003cli\u003eMerge Fields\u003c\/li\u003e\n\u003cli\u003eThe Mail Merge Task Pane\u003c\/li\u003e\n\u003cli\u003eActivity 10-4\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 11:\u2028Advanced Reporting\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eReport Design Elements\u003c\/li\u003e\n\u003cli\u003eReport Design Tools\u003c\/li\u003e\n\u003cli\u003eThe Group, Sort, and Total Pane\u003c\/li\u003e\n\u003cli\u003eThe Field List Pane\u003c\/li\u003e\n\u003cli\u003eAdding a Background Image to a Report\u003c\/li\u003e\n\u003cli\u003eActivity 11-1\u003c\/li\u003e\n\u003cli\u003eReport Format Tools\u003c\/li\u003e\n\u003cli\u003eReport Control Properties\u003c\/li\u003e\n\u003cli\u003eReport Pagination\u003c\/li\u003e\n\u003cli\u003eActivity 11-2\u003c\/li\u003e\n\u003cli\u003eData Bars\u003c\/li\u003e\n\u003cli\u003eCharts\u003c\/li\u003e\n\u003cli\u003eActivity 11-3\u003c\/li\u003e\n\u003cli\u003eCalculated Fields\u003c\/li\u003e\n\u003cli\u003eActivity 11-4\u003c\/li\u003e\n\u003cli\u003eSubreports\u003c\/li\u003e\n\u003cli\u003eActivity 11-5\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 12:\u2028Additional Reporting Options\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eThe Label Wizard\u003c\/li\u003e\n\u003cli\u003eActivity 12-1\u003c\/li\u003e\n\u003cli\u003ePublishing a Report as PDF\u003c\/li\u003e\n\u003cli\u003eActivity 12-2\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cspan style=\"text-decoration: underline;\"\u003e\u003cstrong\u003ePART 2\u003c\/strong\u003e\u003c\/span\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003eMicrosoft Office Access 2016 is the newest version of Microsoft’s popular database program. This is the second part of a two-level course, and it explores advanced Access features. Whether you’re using Access for the first time, or have been using it for years, this course will help you make the most of Access 2016’s features and tools.\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003eThe Microsoft Access 2016 Part Two program covers advanced Access features, including:\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eImplementing Advanced Form Design\u003c\/li\u003e\n\u003cli\u003eUsing Data Validation\u003c\/li\u003e\n\u003cli\u003eUsing Macros to Improve User Interface Design\u003c\/li\u003e\n\u003cli\u003eUsing Advanced Database Management\u003c\/li\u003e\n\u003cli\u003eDistributing and Securing a Database\u003c\/li\u003e\n\u003cli\u003eManaging Switchboards\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul class=\"ng-scope\"\u003e\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cu\u003e\u003cstrong\u003eCourse Topics:\u003c\/strong\u003e\u003c\/u\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 1: \u003c\/strong\u003e\u2028\u003cstrong\u003eImplementing Advanced Form Design\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eTypes of Controls\u003c\/li\u003e\n\u003cli\u003eCommand Buttons\u003c\/li\u003e\n\u003cli\u003eQuick Start Fields\u003c\/li\u003e\n\u003cli\u003eCalendar\/Datepicker Control\u003c\/li\u003e\n\u003cli\u003eForm Layouts\u003c\/li\u003e\n\u003cli\u003eQuick Styles\u003c\/li\u003e\n\u003cli\u003eTab Order\u003c\/li\u003e\n\u003cli\u003eThe Anchoring Tool\u003c\/li\u003e\n\u003cli\u003eActivity 1-1\u003c\/li\u003e\n\u003cli\u003eMove Form Controls\u003c\/li\u003e\n\u003cli\u003eAdd Form Controls\u003c\/li\u003e\n\u003cli\u003eRemove Form Controls\u003c\/li\u003e\n\u003cli\u003eModify Data Sources\u003c\/li\u003e\n\u003cli\u003eSet Form Control Properties\u003c\/li\u003e\n\u003cli\u003eManage Labels\u003c\/li\u003e\n\u003cli\u003eActivity 1-2\u003c\/li\u003e\n\u003cli\u003eSubforms\u003c\/li\u003e\n\u003cli\u003eActivity 1-3\u003c\/li\u003e\n\u003cli\u003eTab Pages\u003c\/li\u003e\n\u003cli\u003eActivity 1-4\u003c\/li\u003e\n\u003cli\u003eNavigation Control and Navigation Forms\u003c\/li\u003e\n\u003cli\u003eSetting Navigation Options\u003c\/li\u003e\n\u003cli\u003eCreating a Navigation Form\u003c\/li\u003e\n\u003cli\u003eUsing a Navigation Form\u003c\/li\u003e\n\u003cli\u003eActivity 1-5\u003c\/li\u003e\n\u003cli\u003eInsert Headers And Footers\u003c\/li\u003e\n\u003cli\u003eInsert Images\u003c\/li\u003e\n\u003cli\u003eAuto-Order Forms\u003c\/li\u003e\n\u003cli\u003eSort Records\u003c\/li\u003e\n\u003cli\u003eApply Themes\u003c\/li\u003e\n\u003cli\u003eInsert Backgrounds\u003c\/li\u003e\n\u003cli\u003eChange Margins\u003c\/li\u003e\n\u003cli\u003eActivity 1-5\u003c\/li\u003e\n\u003cli\u003eConditional Formatting\u003c\/li\u003e\n\u003cli\u003eActivity 1-6\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 2:\u003c\/strong\u003e\u2028 \u003cstrong\u003eUsing Data Validation\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eField Properties\u003c\/li\u003e\n\u003cli\u003eInput Masks\u003c\/li\u003e\n\u003cli\u003eThe Input Mask Wizard\u003c\/li\u003e\n\u003cli\u003eInput Mask Characters\u003c\/li\u003e\n\u003cli\u003eLookup Lists\u003c\/li\u003e\n\u003cli\u003eExpression Builder\u003c\/li\u003e\n\u003cli\u003eActivity 2-1\u003c\/li\u003e\n\u003cli\u003eForm Validation\u003c\/li\u003e\n\u003cli\u003eControl Wizards\u003c\/li\u003e\n\u003cli\u003eThe Combo Box Control\u003c\/li\u003e\n\u003cli\u003eThe List Box Control\u003c\/li\u003e\n\u003cli\u003eThe Option Group Control\u003c\/li\u003e\n\u003cli\u003eRecord Validation\u003c\/li\u003e\n\u003cli\u003eActivity 2-2\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 3:\u003c\/strong\u003e\u2028 \u003cstrong\u003eUsing Macros to Improve User Interface Design\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eMacros\u003c\/li\u003e\n\u003cli\u003eThe Macro Builder Window\u003c\/li\u003e\n\u003cli\u003eMacro Actions\u003c\/li\u003e\n\u003cli\u003eTypes of Macro Actions\u003c\/li\u003e\n\u003cli\u003eAction Arguments\u003c\/li\u003e\n\u003cli\u003eObject Events\u003c\/li\u003e\n\u003cli\u003eMacros in Access Web Apps\u003c\/li\u003e\n\u003cli\u003eActivity 3-1\u003c\/li\u003e\n\u003cli\u003eMacro Conditions\u003c\/li\u003e\n\u003cli\u003eThe Where Condition\u003c\/li\u003e\n\u003cli\u003eActivity 3-2\u003c\/li\u003e\n\u003cli\u003eEvent Properties for Data Validation\u003c\/li\u003e\n\u003cli\u003eMacro Actions for Data Validation\u003c\/li\u003e\n\u003cli\u003eEmbedded Macros\u003c\/li\u003e\n\u003cli\u003eActivity 3-3\u003c\/li\u003e\n\u003cli\u003eEvent Properties for Automating Data Entry\u003c\/li\u003e\n\u003cli\u003eMacro Actions for Automating Data Entry\u003c\/li\u003e\n\u003cli\u003eActivity 3-4\u003c\/li\u003e\n\u003cli\u003eMacros and VBA\u003c\/li\u003e\n\u003cli\u003eActivity 3-5\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 4:\u003c\/strong\u003e\u2028 \u003cstrong\u003eUsing Advanced Database Management\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eExternal Data Sources\u003c\/li\u003e\n\u003cli\u003eThe Linked Table Manager\u003c\/li\u003e\n\u003cli\u003eActivity 4-1\u003c\/li\u003e\n\u003cli\u003eExclusive Mode\u003c\/li\u003e\n\u003cli\u003eDatabase Access Modes\u003c\/li\u003e\n\u003cli\u003eDatabase Backup\u003c\/li\u003e\n\u003cli\u003eThe Compact and Repair Database Option\u003c\/li\u003e\n\u003cli\u003eActivity 4-2\u003c\/li\u003e\n\u003cli\u003eObject Dependency\u003c\/li\u003e\n\u003cli\u003eActivity 4-3\u003c\/li\u003e\n\u003cli\u003eThe Database Documenter\u003c\/li\u003e\n\u003cli\u003eActivity 4-4\u003c\/li\u003e\n\u003cli\u003ePerformance Analyzer\u003c\/li\u003e\n\u003cli\u003eActivity 4-5\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 5:\u003c\/strong\u003e\u2028 \u003cstrong\u003eDistributing and Securing a Database\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eSplitting a Database\u003c\/li\u003e\n\u003cli\u003eMerging a Database\u003c\/li\u003e\n\u003cli\u003eActivity 5-1\u003c\/li\u003e\n\u003cli\u003eSecurity Strategies in Access 2016\u003c\/li\u003e\n\u003cli\u003eThe Message Bar\u003c\/li\u003e\n\u003cli\u003eThe Trust Center Dialog Box\u003c\/li\u003e\n\u003cli\u003eTrusted Locations\u003c\/li\u003e\n\u003cli\u003eActivity 5-2\u003c\/li\u003e\n\u003cli\u003ePassword Protection Guidelines\u003c\/li\u003e\n\u003cli\u003eActivity 5-3\u003c\/li\u003e\n\u003cli\u003eThe ACCDE File Format\u003c\/li\u003e\n\u003cli\u003eUser Templates\u003c\/li\u003e\n\u003cli\u003eSaving Databases as Templates\u003c\/li\u003e\n\u003cli\u003eActivity 5-4\u003c\/li\u003e\n\u003cli\u003eDigital Signatures\u003c\/li\u003e\n\u003cli\u003eDigital Certificates\u003c\/li\u003e\n\u003cli\u003eThe Package and Sign Feature\u003c\/li\u003e\n\u003cli\u003eActivity 5-5\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eLesson 6:\u003c\/strong\u003e\u2028 \u003cstrong\u003eManaging Switchboards\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eSwitchboards\u003c\/li\u003e\n\u003cli\u003eSwitchboard Manager\u003c\/li\u003e\n\u003cli\u003eActivity 6-1\u003c\/li\u003e\n\u003cli\u003eSwitchboard Modification\u003c\/li\u003e\n\u003cli\u003eActivity 6-2\u003c\/li\u003e\n\u003cli\u003eDatabase Startup Options\u003c\/li\u003e\n\u003cli\u003eActivity 6-3\u003c\/li\u003e\n\u003cli\u003eSummary\u003c\/li\u003e\n\u003cli\u003eReview Questions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul class=\"ng-scope\"\u003e\u003c\/ul\u003e\n\u003cul class=\"ng-scope\"\u003e\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\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 Master\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":41820862152882,"sku":"VS-002-003","price":44.0,"currency_code":"USD","in_stock":true},{"title":"5 Licences (EUR 35 each)","offer_id":59260645671260,"sku":null,"price":193.0,"currency_code":"USD","in_stock":true},{"title":"10 Licences (EUR 30 each)","offer_id":59260645704028,"sku":null,"price":330.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0077\/7604\/3071\/files\/VS-002_Access_2016_Master.png?v=1779618013","url":"https:\/\/www.ebsiamericas.com\/products\/access-2016-part-1","provider":"eBSI Export Academy","version":"1.0","type":"link"}