| The MOS certifcation certifies
individuals in the workplace with Proficient and Expert skills
in Microsoft Office - Word, Excel, PowerPoint, Access, Outlook
and FrontPage.You can be certified in any one Course or the entire
Microsoft Office Suite. Great certification for anyone requiring
high level skills in Microsoft Office or provide computer support
within a company. Many company's support departments require A+
and MOUS Certification for employment. Microsoft is expecting
1 million individuals to be MOUS Certified.skills, knowledge,
and experience with challenging exams that are a recognized benchmark
in over 75 countries.
MOS ACCESS Exams are available at two
levels
|
|
Accumulative Ratings
- Note all data presented here assumes students
are following the certz route, where each certification builds
on the previous certifications achieved. See
FAQ for explanation of each rating.
|
| A |
MOS
Access 2003 (XP) - Proficient (Core) |
|
| Level (1/10) |
1 |
Overall rating (1/10) |
7 |
| Difficulty (1/10) |
4 |
Study time - Wks |
5 |
| No of exams |
1 |
Additional Earnings |
+$5,000 |
| Exam Costs |
$75 |
Study Costs |
$18
34% off |
|
| STUDYING
- The MOUS Access 2003 certification exam tests a users
ability in the following exam objectives
Structuring Databases Create
- Access databases
- Create and modify tables
- Define and modify field types
- Modify field properties
- Create and modify one-to-many relationships
- Enforce referential integrity
- Create and modify queries
- Create forms
- Add and modify form controls and properties
- Create reports
- Add and modify report control properties
- Create a data access page
Entering Data
- Enter, edit and delete records
- Find and move among records
- Import data to Access
Organizing Data
- Create and modify calculated fields
- and aggregate functions
- Modify form layout
- Modify report layout and page setup
- Format datasheets
- Sort records
- Filter records
Managing Databases
- Identify object dependencies
- View objects and object data in other
views
- Print database objects and data
- Export data from Access
- Back up a database
- Compact and repair databases
The
Access 2003 : Your visual blueprint for creating and maintaining
real-world databases at $18
(34% discount)
. This practical, hands-on book takes a visual approach
to learning and teaching.. Open the book and you’ll
discover step-by-step screen shots that demonstrate over
140 key techniques to help you make the most of Access 2003,
including :
Building charts and graphs
Designing user-friendly forms
Creating tables, queries, and Data Access Pages
Writing macros
Converting macros to VBA code
Setting up database relationships
Programming Access with VBA
Writing and using classes
Managing databases
Using ActiveX Data Objects
Using Data Access Pages in a Web site.
The book comprises 336 pages and comes as
a paperback with a CD-Rom..
|
|
| EXAMS
- Microsoft Office certification exams are not
traditional tests with multiple choice answers. Instead,
you’re presented with an actual program interface
with a document already started. Steps appear in a pane
below the application window, and your task is to complete
the steps exactly as directed. Then you are scored on how
closely your result matches the computer’s version
of what is “correct.”
The passing score is 640 out of 1000, with
typically 17 scenerio based questions and a time limit of
50 minutes,
|
Access 2003 : Your visual blueprint for creating and maintaining real-world databases
(34% off)
 |
| CONCLUSION
- This is an ideal certification of MS Office
users, the exam is Not a pushover, given the method of testing
so candidates must ensure adequate practice in using MS
Access beforehand. Saying that the passing score is low
so there is some room for error on the day of the test. |
|
|
|
