{"product_id":"access-2016-essentials","title":"Access 2016 Essentials","description":"\u003cp\u003e\u003cspan\u003eLearners 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\u003eModule One: Create and Manage a Database\u003cbr\u003e• Create and Modify Databases\u003cbr\u003eo Create a blank desktop database\u003cbr\u003eo Create a database from a template\u003cbr\u003eo Create a database by using Import objects or data from other sources\u003cbr\u003eo Delete database objects\u003cbr\u003e• Manage Relationships and Keys\u003cbr\u003eo Create and modify relationships\u003cbr\u003eo Set the primary key\u003cbr\u003eo Enforce referential integrity\u003cbr\u003eo Set foreign keys, view relationships\u003cbr\u003e• Navigate through a Database\u003cbr\u003eo Navigate specific records\u003cbr\u003eo Create and modify a navigation form\u003cbr\u003eo Set a form as the startup option\u003cbr\u003eo Display objects in the Navigation Pane\u003cbr\u003eo Change views of objects\u003cbr\u003e• Protect and Maintain Databases\u003cbr\u003eo Compact a database\u003cbr\u003eo Repair a database, back up a database\u003cbr\u003eo Split a database\u003cbr\u003eo Encrypt a database with a password\u003cbr\u003eo Recover data from backup\u003cbr\u003e• Print and Export Data\u003cbr\u003eo Print reports\u003cbr\u003eo Print records\u003cbr\u003eo Save a database as a template\u003cbr\u003eo Export objects to alternative formats\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eModule Two: Build tables\u003cbr\u003e• Create Tables\u003cbr\u003eo Create a table\u003cbr\u003eo Import data into tables\u003cbr\u003eo Create linked tables from external sources\u003cbr\u003eo Import tables from other databases\u003cbr\u003eo Create a table from a template with application parts\u003cbr\u003e• Manage Tables\u003cbr\u003eo Hide fields in tables\u003cbr\u003eo Add total rows\u003cbr\u003eo Add table descriptions\u003cbr\u003eo Rename tables\u003cbr\u003e• Manage Records in Tables\u003cbr\u003eo Update records\u003cbr\u003eo Add records\u003cbr\u003eo Delete records\u003cbr\u003eo Append records from external data\u003cbr\u003eo Find and replace data\u003cbr\u003eo Sort records, filter records\u003cbr\u003e• Create and Modify Fields\u003cbr\u003eo Add fields to tables\u003cbr\u003eo Add validation rules to fields\u003cbr\u003eo Change field captions\u003cbr\u003eo Change field sizes\u003cbr\u003eo Change field data types\u003cbr\u003eo Configure fields to auto-increment\u003cbr\u003eo Set default values\u003cbr\u003eo Using input masks\u003cbr\u003eo Delete fields\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eModule Three: Create Queries\u003cbr\u003e• Create a Query\u003cbr\u003eo Run a query\u003cbr\u003eo Create a crosstab query\u003cbr\u003eo Create a parameter query\u003cbr\u003eo Create an action query\u003cbr\u003eo Create a multi-table query\u003cbr\u003eo Save a query\u003cbr\u003e• Modify a Query\u003cbr\u003eo Rename a query\u003cbr\u003eo Add fields, remove fields\u003cbr\u003eo Hide fields\u003cbr\u003eo Sort data within queries\u003cbr\u003eo Format fields within queries\u003cbr\u003e• Create Calculated Fields and Grouping within Queries\u003cbr\u003eo Add calculated fields\u003cbr\u003eo Set filtering criteria\u003cbr\u003eo Group and summarize data\u003cbr\u003eo Group data by using comparison operators\u003cbr\u003eo Group data by using arithmetic and logical operators\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eModule Four: Create Forms\u003cbr\u003e• Create a Form\u003cbr\u003eo Create a form\u003cbr\u003eo Create a form from a template with application parts\u003cbr\u003eo Save a form\u003cbr\u003e• Configure Form Controls\u003cbr\u003eo Move form controls\u003cbr\u003eo Add form controls\u003cbr\u003eo Modify data sources\u003cbr\u003eo Remove form controls\u003cbr\u003eo Set form control properties\u003cbr\u003eo Manage labels\u003cbr\u003eo Add sub-forms\u003cbr\u003e• Format a Form\u003cbr\u003eo Modify tab order\u003cbr\u003eo Configure Print settings\u003cbr\u003eo Sort records by form field\u003cbr\u003eo Apply a theme\u003cbr\u003eo Control form positioning\u003cbr\u003eo Insert backgrounds, insert headers and footers, insert images\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eModule Five: Create Reports\u003cbr\u003e• Create a Report\u003cbr\u003eo Create a report based on the query or table\u003cbr\u003eo Create a report in Design view\u003cbr\u003eo Create a report by using a wizard\u003cbr\u003e• Configure Report Controls\u003cbr\u003eo Group and sort fields\u003cbr\u003eo Modify data sources\u003cbr\u003eo Add report controls\u003cbr\u003eo Add and modify labels\u003cbr\u003e• Format a Report\u003cbr\u003eo Format a report into multiple columns\u003cbr\u003eo Add calculated fields\u003cbr\u003eControl report positioning\u003cbr\u003eo Format report elements\u003cbr\u003eo Change report orientation\u003cbr\u003eo Insert header and footer information\u003cbr\u003eo Insert images\u003cbr\u003eo Apply a theme\u003c\/span\u003e\u003c\/p\u003e","brand":"My Store","offers":[{"title":"Default Title","offer_id":46499584770260,"sku":"access_2016_essentials","price":25.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0751\/4882\/0692\/files\/access-2016.png?v=1779428636","url":"https:\/\/essatraining.com.au\/products\/access-2016-essentials","provider":"Essential Soft Skills Academy","version":"1.0","type":"link"}