This is the Course Details

Undernoted courses basic learning have been illustrated in the undernoted link to learn the basic of the the all courses  tutorials.  After Buying the exam voucher , you will get 40hrs courses extra to complete the project base tutorials  through office 365 / shere point platform . for that you required to learn oneNote

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

147Managing the Access Environment
1516147Create 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   
1517147Configure the Navigation pane•Rename objects, delete objects and set Navigation options Learn   
1518147Apply Application Parts•Use Blank Forms, Quick Start and user templates Learn   
148Building Tables
1519148Create tables•Create tables in Design view Learn   
1520148Create 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   
1521148Sort and filter records•Use Find, Sort and Filter commands Learn   
1522148Set relationships•Define Primary Keys, use Primary Keys to create Relationships and edit Relationships Learn   
1523148Enter 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   
1524148Import 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   
149Building Forms
1525149Create forms•Use the Form Wizard, create a blank form, use Form Design tools and create Navigation forms Learn   
1526149Apply Form Design Tab options•Use the Themes, Controls, Header/Footer and Tools groups Learn   
1527149Apply Form Arrange Tab options•Use the Table, Move and Position groups Learn   
1528149Apply Form Format Tab options•Use the Background and Control Formatting groups Learn   
150 Creating and Managing Queries
1529150Construct queries•Use Select, Make Table, Append and Crosstab query types Learn   
1530150Manage source tables and relationships•Use the Show Table and Remove Table commands, and create ad hoc relationships Learn   
1531150Manipulate fields•Add, remove and rearrange fields, and use Sort and Show options Learn   
1532150Calculate totals•Use the Total row, and use Group By Learn   
1533150Generate calculated fields•Perform calculations, use the Zoom box and use Expression Builder Learn   
151Designing Reports
1534151Create reports•Create a blank report, use Report Design tools and use the Report Wizard Learn   
1535151Apply Report Design Tab options•Use the Themes, Grouping & Totals, Controls, Header/Footer and Tools groups Learn   
1536151Apply Report Arrange Tab options•Use the Table, Move, Position and Sizing & Ordering groups Learn   
1537151Apply Report Format Tab options•Add colour, background images and conditional formatting Learn   
1538151Apply Report Page Setup Tab options•This objective may include, but is not limited to, using the Page Size and Page Layout groups Learn   
1539151Sort and filter records for reporting•Use the Find, Sort and Filter commands, and use view types Learn   


© 2024 - CodeHub India 2015   

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