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 Fundamentals MOS MOUS Certification XP

This MOS (Formerly MOUS) Training course presents the learner with the fundamentals of Microsoft Access 2002. This course guides the learner through the basics of Access databases and covers topics such as creating and modifying databases, and establishing relationships between tables.

Learn To
  • Identify advantages of a relational database.
  • Identify the basics of a relational database.
  • Sequence the steps for planning a relational database.
  • Create a table in Datasheet view.
  • Identify features of the Table Wizard
  • Create a table in Design view.
  • Identify features of relationships between tables.
  • Create a one-to-many relationship between tables.
  • Sequence the steps to define a many-to-many relationship between two tables.
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: Basics of Access 2002

2 - 3 hours
  • Identify advantages of a relational database.
  • Identify the basics of a relational database.
  • Sequence the steps for planning a relational database.
  • Open a database by using Microsoft Access.
  • Match database objects with their features.
  • Identify the functions of each database object view.
  • Create a blank database.
  • Identify the options available when creating a database by using a database template.
  • Get help by using the Office Assistant.
  • Identify features of the Help Window.

Unit 2: Table Creation and Modification
2 - 3 hours
  • Create a table in Datasheet view.
  • Identify features of the Table Wizard.
  • Create a table in Design view.
  • Create a field for a table in Design view.
  • Move a field in a table in Datasheet view.
  • Modify a field property in a table in Design view.
  • Create an input mask in a table field.
  • Delete a field from a table in Design view.
  • Set a field as a primary key in Design view.

Unit 3: Table Relationships and Data Integrity
2 hours
  • Identify features of relationships between tables.
  • Create a one-to-many relationship between tables.
  • Sequence the steps to define a many-to-many relationship between two tables.
  • Print a relationship report of a database.
  • Identify features of a subdatasheet.
  • Validate data integrity in a table.
  • Identify features of the Required property used to ensure data integrity.


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