Microsoft Office Specialist - Westminster

Microsoft Office SpecialistAccess 2016: Core Database Management,Manipulation, and Query Skills; Exam 77-730Successful candidates for the Access 2016 exam have a fundamental understanding of theapplication’s environment. They understand basic database design principles and are able tocomplete tasks independently. They know and demonstrate the correct application of theprinciple features of Access 2016, and will demonstrate the ability to create and maintain basicAccess database objects including tables, relationships, data entry forms, multi-level reports, andmulti-table queries.MOS 2016 certification exams introduce a new performance-based format for improved testing of a candidate’s knowledge, skillsand abilities using the MOS 2016 programs: MOS 2016 exam task instructions generally do not include the command name as in previous versions. For example, functionnames are avoided, and are replaced with descriptors. This means candidates must understand the purpose and commonusage of the program functionality in order to successfully complete the tasks in each of the projects. The MOS 2016 exam format incorporates multiple projects.Objective DomainsCreate andManage aDatabase1.1Create and Modify Databases1.1.1Create a blank desktop database1.1.2Create a database from a template1.1.3Create a database by using Import objects ordata from other sources1.1.4Delete database objects1.2Manage Relationships and Keys1.2.1Create and modify relationships1.2.2Set the primary key1.2.3Enforce referential integrity1.2.4Set foreign keys1.2.5View relationships1.3Navigate through a Database1.3.1Navigate specific records1.3.2Create and modify a navigation form1.3.3Set a form as the startup option1.3.4Display objects in the Navigation Pane1.3.5Change views of objects1.4Protect and Maintain Databases1.4.1Compact a database1.4.2Repair a database1.4.3Back up a database1.4.4Split a database1.4.5Encrypt a database with a password1.4.6Recover data from backupMicrosoft Office Specialistcertification is the only officialMicrosoft-recognizedcertification for MicrosoftOffice globally.Page 1 of 3

MOS Access 2016Create andManage aDatabaseBuild TablesCreateQueries1.5Print and Export Data1.5.11.5.21.5.31.5.42.1Print reportsPrint recordsSave a database as a templateExport objects to alternative formatsCreate Tables2.1.12.1.22.1.32.1.42.1.5Create a tableImport data into tablesCreate linked tables from external sourcesImport tables from other databasesCreate a table from a template with application parts2.2Manage Tables2.2.1Hide fields in tables2.2.2Add total rows2.2.3Add table descriptions2.2.4Rename tables2.3Manage Records in Tables2.3.1Update records2.3.2Add records2.3.3Delete records2.3.4Append records from external data2.3.5Find and replace data2.3.6Sort records2.3.7Filter records2.4Create and Modify Fields2.4.1Add fields to tables2.4.2Add validation rules to fields2.4.3Change field captions2.4.4Change field sizes2.4.5Change field data types2.4.6Configure fields to auto-increment2.4.7Set default values2.4.8Using input masks2.4.9Delete fields3.1Create a Query3.1.1Run a query3.1.2Create a crosstab query3.1.3Create a parameter query3.1.4Create an action query3.1.5Create a multi-table query3.1.6Save a query3.2Modify a Query3.2.1Rename a query3.2.2Add fields3.2.3Remove fields3.2.4Hide fields3.2.5Sort data within queries3.2.6Format fields within queriesPage 2 of 3 2016 Certiport, Inc. Certiport and the Certiport logo are registered trademarks of Certiport Inc. All other trademarks and registered trademarks are the property of their respective holders.

MOS Access 2016CreateQueriesCreateFormsCreateReports3.3Create Calculated Fields and Grouping within Queries3.3.1Add calculated fields3.3.2Set filtering criteria3.3.3Group and summarize data3.3.4Group data by using comparison operators3.3.5Group data by using arithmetic and logical operators4.1Create a Form4.1.1Create a form4.1.2Create a form from a template with application parts4.1.3Save a form4.2Configure Form Controls4.2.1Move form controls4.2.2Add form controls4.2.3Modify data sources4.2.4Remove form controls4.2.5Set form control properties4.2.6Manage labels4.2.7Add sub-forms4.3Format a Form4.3.1Modify tab order4.3.2Configure Print settings4.3.3Sort records by form field4.3.4Apply a theme4.3.5Control form positioning4.3.6Insert backgrounds4.3.7Insert headers and footers4.3.8Insert images5.1Create a Report5.1.1Create a report based on the query or table5.1.2Create a report in Design view5.1.3Create a report by using a wizard5.2Configure Report Controls5.2.1Group and sort fields5.2.2Modify data sources5.2.3Add report controls5.4Add and modify labels5.3Format a Report5.3.1Format a report into multiple columns5.3.2Add calculated fields5.3.3Control report positioning5.3.4Format report elements5.3.5Change report orientation5.3.6Insert header and footer information5.3.7Insert images5.3.8Apply a themePage 3 of 3 2016 Certiport, Inc. Certiport and the Certiport logo are registered trademarks of Certiport Inc. All other trademarks and registered trademarks are the property of their respective holders.

77-424MOS Access 2013Objective Domain1.0Create and Manage a Database1.1Create a New DatabaseThis objective may include but is not limited to: creating new databases, creatingdatabases using templates, saving databases in older formats, creating databases usingwizards1.2Manage Relationships and KeysThis objective may include but is not limited to: editing references between tables,creating and modifying relationships, setting primary key fields, enforcing referentialintegrity, setting foreign keys, viewing relationships1.3Navigate through a DatabaseThis objective may include but is not limited to: navigating to specific records, setting aform as the startup option, using navigation forms, setting navigation options, changingviews1.4Protect and Maintain a DatabaseThis objective may include but is not limited to: compacting databases, repairingdatabases, backing up databases, splitting databases, encrypting databases with apassword, merging databases, recovering data from a backups1.5Print and Export a DatabaseThis objective may include but is not limited to: printing reports, printing records,maintaining backward compatibility, saving databases as templates, saving databases toexternal locations, exporting to alternate formats

2.0Build Tables2.1Create a TableThis objective may include but is not limited to: creating new tables, importing externaldata into tables, creating linked tables from external sources, importing tables fromothers database, creating tables from templates and application parts2.2Format a TableThis objective may include but is not limited to: hiding fields in tables, changing dataformats, adding total rows, adding table descriptions, renaming tables2.3Manage RecordsThis objective may include but is not limited to: updating records, adding new records,deleting records, appending records from external data, finding and replacing data,sorting records, filtering records, grouping records2.4Create and Modify FieldsThis objective may include but is not limited to: adding fields to tables, adding avalidation rules to fields, changing field captions, changing field sizes, changing field datatypes, configuring fields to auto-increment, setting default values, using input masks,deleting fields3.0Create Queries3.1Create a QueryThis objective may include but is not limited to: running queries, creating crosstabqueries, creating parameter queries, creating action queries, creating multi-tablequeries, saving queries, deleting queries3.2Modify a QueryThis objective may include but is not limited to: renaming queries, adding new fields,removing fields, hiding fields, sorting data within queries, formatting fields withinqueries3.3Utilize Calculated Fields and Grouping within a QueryThis objective may include but is not limited to: adding calculated fields, addingconditional logic, grouping and summarizing data, using comparison operators, usingbasic operators

4.0Create Forms4.1Create a FormThis objective may include but is not limited to: creating new forms, creating forms withapplication parts, saving forms, deleting forms4.2Set Form ControlsThis objective may include but is not limited to: moving form controls, adding formcontrols, modifying data sources, removing form controls, setting form controlproperties, managing labels4.3Format a FormThis objective may include but is not limited to: modifying Tab order in forms,formatting print layouts, sorting records, applying themes, changing margins, insertingbackgrounds, auto-ordering forms, inserting headers and footers, inserting images,modifying existing forms5.0Create Reports5.1Create a ReportThis objective may include but is not limited to: creating new reports, creating reportswith application parts, deleting reports5.2Set Report ControlsThis objective may include but is not limited to: grouping data by fields, sorting data,adding sub-reports, modifying data sources, adding report controls, managing labels5.3Format a ReportThis objective may include but is not limited to: formatting reports into multiplecolumns, adding calculated fields, setting margins, adding backgrounds, changing reportorientation, changing sort order, inserting headers and footers, inserting images,inserting page numbers, applying themes, modifying exiting reports

77-885Access 2010Exam DesignThe BasicsThis is a Technical Specialist exam designed to assess candidates’ hands-on skills using Microsoft OfficeAccess 2010. We are specifying an item pool of 45 unique performance-based tasks. Items should bewritten to the Application cognitive level. For more information about cognitive levels, refer to theCognitive Domain in Bloom’s Taxonomy.Categories in the cognitive domain of Bloom's Taxonomy (Anderson & Krathwohl, 2001)

Target AudienceThe typical candidate for the exam works as a user support professional, trainer, teacher, professor,database user, or database creator who needs to create or maintain a basic Access database. Users cancreate, modify, and extend functionality of basic database objects, including tables, queries, forms, andreports. Users can also construct and modify basic relationships among database entities and caninstruct others in basic Access functionality and usage.The Access 2010 user typically: is effective in creating, modifying, and personalizing objects is capable of working independently on database projects often answers questions from others about databases has created or modified a simple Access database can use templates to create basic objectsObjective Domain1. Managing the Access Environment1.1.Create and manage a database.1.2.Configure the Navigation Pane.1.3.Apply Application Parts.2. Building Tables2.1.Create tables.2.2.Create and modify fields.2.3.Sort and filter records.2.4.Set relationships.2.5.Import data from a single data file.3. Building Forms3.1.Create forms.3.2.Apply Form Design Tab options.

3.3.Apply Form Arrange Tab options.3.4.Apply Form Format Tab options.4. Creating and Managing Queries4.1.Construct queries.4.2.Manage source tables and relationships.4.3.Manipulate fields.4.4.Calculate totals.4.5.Generate calculated fields.5. Designing Reports5.1.Create reports.5.2.Apply Report Design Tab options.5.3.Apply Report Arrange Tab options.5.4.Apply Report Format Tab options.5.5.Apply Report Page Setup Tab options.5.6.Sort and filter records for reporting.

MOS Access 2013 Objective Domain 1.0 Create and Manage a Database 1.1 Create a New Database This objective may include but is not limited to: creating new databases, creating databases using templates, saving databases in older formats, creating databases using wizards 1.2 Manage Relationships and Keys