This is the Course Details

You have selected the Microsoft Corporation for the Microsoft Office Specialist (MOS) course in 77-424: Access 2013

CourseChapTopicID

CourseChapTopicName

191

Create and manage a database (20–25%)

CourseChapTopicDetailsID	CourseChapTopicID	DetailTopicName	imgUrl
1684	191	Create a new database •Create new databases, create databases using templates, create databases in older formats, create databases using wizards	Learn
1685	191	Manage relationships and keys •Edit references between tables, create and modify relationships, set primary key fields, enforce referential integrity, set foreign keys, view relationships	Learn
1686	191	Navigate through a database •Navigate to specific records, set a form as the startup option, use navigation forms, set navigation options, change views	Learn
1687	191	Protect and maintain a database •Compact databases, repair databases, back up databases, split databases, encrypt databases with a password, merge databases, recover data from backups	Learn
1688	191	Print and export a database •Print reports, print records, maintain backward compatibility, save databases as templates, save databases to external locations, export to alternate formats	Learn

192

Build tables (25–30%)

CourseChapTopicDetailsID	CourseChapTopicID	DetailTopicName	imgUrl
1689	192	Create a table •Create new tables, import external data into tables, create linked tables from external sources, import tables from other database, create tables from templates and application parts	Learn
1690	192	Format a table •Hide fields in tables, change data formats, add total rows, add table descriptions, rename tables	Learn
1691	192	Manage records •Update records, add new records, delete records, append records from external data, find and replace data, sort records, filter records, group records	Learn
1692	192	Create and modify fields •Add fields to tables, add a validation rules to fields, change field captions, change field sizes, change field data types, configure fields to auto-increment, set default values, use input masks, delete fields	Learn

193

Create queries (15–20%)

CourseChapTopicDetailsID	CourseChapTopicID	DetailTopicName	imgUrl
1693	193	Create a query •Run queries, create crosstab queries, create parameter queries, create action queries, create multi-table queries, save queries, delete queries	Learn
1694	193	Modify a query •Rename queries, add new fields, remove fields, hide fields, sort data within queries, format fields within queries	Learn
1695	193	Utilize calculated fields and grouping within a query •Add calculated fields, add conditional logic, group and summarize data, use comparison operators, use basic operators	Learn

194

Create forms (15–20%)

CourseChapTopicDetailsID	CourseChapTopicID	DetailTopicName	imgUrl
1696	194	Create a form •Create new forms, create forms with application parts, save forms, delete forms	Learn
1697	194	Set form controls •Move form controls, add form controls, modify data sources, remove form controls, set form control properties, manage labels	Learn
1698	194	Format a form •Modify tab order in forms, format print layouts, sort records, apply themes, change margins, insert backgrounds, auto-order forms, insert headers and footers, insert images, modify existing forms	Learn

195

Create reports (15–20%)

CourseChapTopicDetailsID	CourseChapTopicID	DetailTopicName	imgUrl
1699	195	Create a report •Create new reports, create reports with application parts, delete reports	Learn
1700	195	Set report controls •Group data by fields, sort data, add sub-forms, modify data sources, add report controls, manage labels	Learn
1701	195	Format a report •Format reports into multiple columns, add calculated fields, set margins, add backgrounds, change report orientation, change sort order, insert headers and footers, insert images, insert page numbers, apply themes, modify existing reports	Learn

data-share="true" data-width="450" data-show-faces="true">