This is the Course Details

You have selected the Microsoft Corporation for the Microsoft Office Specialist (MOS) course in Exam: 77-885 MOS Core Access 2010

CourseChapTopicID

CourseChapTopicName

147

Managing the Access Environment

CourseChapTopicDetailsID	CourseChapTopicID	DetailTopicName	imgUrl
1516	147	Create and manage a database•Use Save Object As, Open, Save and Publish, Compact and Repair Database and Encrypt with Password commands, create a database from a template and set Access options	Learn
1517	147	Configure the Navigation pane•Rename objects, delete objects and set Navigation options	Learn
1518	147	Apply Application Parts•Use Blank Forms, Quick Start and user templates	Learn

148

Building Tables

CourseChapTopicDetailsID	CourseChapTopicID	DetailTopicName	imgUrl
1519	148	Create tables•Create tables in Design view	Learn
1520	148	Create and modify fields•Insert a field, delete a field, rename a field, Hide or Unhide fields, Freeze or Unfreeze fields, modify data types, modify the field description and modify field properties	Learn
1521	148	Sort and filter records•Use Find, Sort and Filter commands	Learn
1522	148	Set relationships•Define Primary Keys, use Primary Keys to create Relationships and edit Relationships	Learn
1523	148	Enter and format text•Use text effects; change the indentation, alignment, line spacing and direction of text; change the formatting of bulleted and numbered lists; enter text in a placeholder text box; convert text to SmartArt; copy and paste text; use Paste Special and use Format Painter	Learn
1524	148	Import data from a single data file•Import source data into a new table, append records to an existing table and import data as a linked table	Learn

149

Building Forms

CourseChapTopicDetailsID	CourseChapTopicID	DetailTopicName	imgUrl
1525	149	Create forms•Use the Form Wizard, create a blank form, use Form Design tools and create Navigation forms	Learn
1526	149	Apply Form Design Tab options•Use the Themes, Controls, Header/Footer and Tools groups	Learn
1527	149	Apply Form Arrange Tab options•Use the Table, Move and Position groups	Learn
1528	149	Apply Form Format Tab options•Use the Background and Control Formatting groups	Learn

150

Creating and Managing Queries

CourseChapTopicDetailsID	CourseChapTopicID	DetailTopicName	imgUrl
1529	150	Construct queries•Use Select, Make Table, Append and Crosstab query types	Learn
1530	150	Manage source tables and relationships•Use the Show Table and Remove Table commands, and create ad hoc relationships	Learn
1531	150	Manipulate fields•Add, remove and rearrange fields, and use Sort and Show options	Learn
1532	150	Calculate totals•Use the Total row, and use Group By	Learn
1533	150	Generate calculated fields•Perform calculations, use the Zoom box and use Expression Builder	Learn

151

Designing Reports

CourseChapTopicDetailsID	CourseChapTopicID	DetailTopicName	imgUrl
1534	151	Create reports•Create a blank report, use Report Design tools and use the Report Wizard	Learn
1535	151	Apply Report Design Tab options•Use the Themes, Grouping & Totals, Controls, Header/Footer and Tools groups	Learn
1536	151	Apply Report Arrange Tab options•Use the Table, Move, Position and Sizing & Ordering groups	Learn
1537	151	Apply Report Format Tab options•Add colour, background images and conditional formatting	Learn
1538	151	Apply Report Page Setup Tab options•This objective may include, but is not limited to, using the Page Size and Page Layout groups	Learn
1539	151	Sort and filter records for reporting•Use the Find, Sort and Filter commands, and use view types	Learn

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