north face black Friday, north face black friday sale, the north face black Friday, north face cyber Monday, north face cyber monday 2014, ralph lauren black Friday louis vuitton black Friday coach thanksgiving
Online Exam

  Home  
  Free Exams List  
  About Us  
  Advertise With Us  
  Link to Us  
  Contact Us  
  New User? Register!  

ADVERTISEMENT





Search Online Exams & Dumps:

MS Access 2002 Proficient MOS MOUS Certification XP

This MOS ( formerly MOUS) Training courses covers more advanced features of Access 2002. Individuals will learn how to make different types of data queries, work with forms and link data to other databases.

Learn To
  • Create a single-table query in Design view.
  • Create a multiple-table query in Design view.
  • Create a simple query by using the Simple Query Wizard.
  • Identify features of the Form Wizard.
  • Identify features of the AutoForm Wizard.
  • Add a record to a form.
  • Identify features of the Report Wizard.
  • Print a report from Print Preview.
  • Add a control label to a report.
  • Identify options of the Import Spreadsheet Wizard that are used to import an Excel worksheet to a data access page.
  • Link an existing Microsoft Access table to a database.
  • Publish a table to Microsoft Excel.
Audience

The intended audiences for this course are Project or Office Managers, Secretarial, Web Designer-Developers, System Administrators, Database Administrators. Access 2002 Fundamentals doesn't require any previous database knowledge. Its audience could include a range of other job types such as Junior Secretarial, Customer Service etc. Typically learners will work in an office environment (possibly networked) producing documents/spreadsheets and/or databases/Web pages. Learners will need a basic knowledge of either Microsoft Office 97 or 2000 programs and be familiar with Windows 9X or later operating system(s).

Total Learning Time
6 to 8 hours

Unit 1: Querying Data

1 - 2 hours
  • Create a single-table query in Design view.
  • Create a multiple-table query in Design view.
  • Create a simple query by using the Simple Query Wizard.
  • Match query wizards with their functions.
  • Identify the effects of opening queries.
  • Sort a query by output.
  • Apply a criterion to a query.
  • Apply an aggregate tool to a query.
  • Add a table to a query.
  • Add a calculated field to a query.
  • Match the field properties with their features.

Unit 2: Forms Introduction
1 - 2 hours
  • Identify features of the Form Wizard.
  • Identify features of the AutoForm Wizard.
  • Add a record to a form.
  • Insert a picture into a field.
  • Add an unbound control image to a form.
  • Identify features of controls in a form.
  • Add a calculated text box to a form.
  • Format controls by using the Formatting toolbar.
  • Match form control properties with their functions.
  • Add a section to a form by using the menu bar.
  • Identify functions of the Form Properties sheet.

Unit 3: Reports and Data Access Pages
2 hours
  • Identify features of the Report Wizard.
  • Print a report from Print Preview.
  • Add a control label to a report.
  • Modify a control layout in a report.
  • Add a calculated text box to a report.
  • Format the data display for a control in a report.
  • Modify the control properties in a report.
  • Add a section to a report.
  • Modify the report properties in a report.
  • Identify features of the Page Wizard that are used to create data access pages.
  • Sort a record on a data access page in Page view.
  • Group records on a data access page in Page view.
Unit 4: Database Integration
2 hours
  • Identify options of the Import Spreadsheet Wizard that are used to import an Excel worksheet to a data access page.
  • Link an existing Microsoft Access table to a database.
  • Publish a table to Microsoft Excel.
  • Publish a report to Microsoft Word.
  • Export a database object to Hypertext Markup Language (HTML).
  • Import an Extensible Markup Language (XML) document.
  • Export a database object as an XML document.


A D V E R T I S E M E N T


Members Login

Certifications Exams
Other Online Exams
Engineering Exams
IT Online Exams
Computer Fundamentals
IT Placement Tests
Miscellaneous Tests
Testsworld Quick Links
Free Source Codes
Tutorials


© 2005-2024, TestsWorld.com. All Rights Reserved. Testimonials | Privacy Policy | Terms and Conditions

Other sites in Vyom Network : Academic Tutorials | Best eBooksworld | Beyond Stats | City Details | Cool Interview | India Job Forum | Excellent Mobiles | Free Bangalore | Give Me The Code | Gog Logo | Indian Free Ads | Jobs Assist | New Interview Questions | One Stop FAQs | One Stop GATE | One Stop GRE | One Stop IAS | One Stop MBA | One Stop SAP | One Stop Testing | Quick2Host | Quick2Host Mirror | Quick Site Kit | Sirf Dosti | Source Codes World | Tasty Food | Tech Archive | Testing Interview Questions | CookBookGlobal | The Galz | Top Masala | Vyom | Vyom eBooks | Vyom International | Vyom Links | Vyoms | Vyom World