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. Module One: Create and Manage a Database• Create and Modify Databaseso Create a blank desktop databaseo Create a database from a templateo Create a database by using Import objects or data from other sourceso Delete database objects• Manage Relationships and Keyso Create and modify relationshipso Set the primary keyo Enforce referential integrityo Set foreign keys, view relationships• Navigate through a Databaseo Navigate specific recordso Create and modify a navigation formo Set a form as the startup optiono Display objects in the Navigation Paneo Change views of objects• Protect and Maintain Databaseso Compact a databaseo Repair a database, back up a databaseo Split a databaseo Encrypt a database with a passwordo Recover data from backup• Print and Export Datao Print reportso Print recordso Save a database as a templateo Export objects to alternative formatsModule Two: Build tables• Create Tableso Create a tableo Import data into tableso Create linked tables from external sourceso Import tables from other databaseso Create a table from a template with application parts• Manage Tableso Hide fields in tableso Add total rowso Add table descriptionso Rename tables• Manage Records in Tableso Update recordso Add recordso Delete recordso Append records from external datao Find and replace datao Sort records, filter records• Create and Modify Fieldso Add fields to tableso Add validation rules to fieldso Change field captionso Change field sizeso Change field data typeso Configure fields to auto-incremento Set default valueso Using input maskso Delete fieldsModule Three: Create Queries• Create a Queryo Run a queryo Create a crosstab queryo Create a parameter queryo Create an action queryo Create a multi-table queryo Save a query• Modify a Queryo Rename a queryo Add fields, remove fieldso Hide fieldso Sort data within querieso Format fields within queries• Create Calculated Fields and Grouping within Querieso Add calculated fieldso Set filtering criteriao Group and summarize datao Group data by using comparison operatorso Group data by using arithmetic and logical operatorsModule Four: Create Forms• Create a Formo Create a formo Create a form from a template with application partso Save a form• Configure Form Controlso Move form controlso Add form controlso Modify data sourceso Remove form controlso Set form control propertieso Manage labelso Add sub-forms• Format a Formo Modify tab ordero Configure Print settingso Sort records by form fieldo Apply a themeo Control form positioningo Insert backgrounds, insert headers and footers, insert imagesModule Five: Create Reports• Create a Reporto Create a report based on the query or tableo Create a report in Design viewo Create a report by using a wizard• Configure Report Controlso Group and sort fieldso Modify data sourceso Add report controlso Add and modify labels• Format a Reporto Format a report into multiple columnso Add calculated fieldsControl report positioningo Format report elementso Change report orientationo Insert header and footer informationo Insert imageso Apply a theme
