none
MOS 2010 Access and Excel certification RRS feed

  • Question

  • Hello...

    I am an Admin. Specialist, I work with MOS application, such as Access, Excel, Word and other MOS applications constantly (I would say my MOS level is intermediate).  I don’t have any MOS certificate yet; I am really interested in taking MOS Access and Excel exam and get certification. 

    I recently upgrade my MOS office to 2010.  I noticed that MS Access 2007 and 2010 are not compatible. 

    My questions:

    1.       Shall I wait until MS release Access 2010 certification exam?

    2.       I would like to prepare for the exam, however, there are many online and campus classes.  Should I take the class or any suggestions? 

    I have read many posts from your forum, but they didn't answer my questions; I hope somebody is there and could answer my questions.  Thank you very very much!!! 

    Have a nice day.

     

    Wednesday, October 6, 2010 6:33 PM

Answers

  • Hi,

    Thank you for your post here. Let's see if we can answer some questions for you here.

    First of Access 2007 and 2010 are compatible. Interface wise they look different and there are new additions in 2010 such as a new macro editor and webdatabases. I work a lot with Access and have to say the general idea is thinking database and objects. For exams you should consider that new features are always important and will be a part of the exam. So if you are familiar with 2007 i'd say go for that one first. It will give you an idea of how the exam works and what you might expect for the next exam.

    Furthermore in 2010 you have two Excel exams against one in 2007. So go for the 2007 versions first and after that go for the 2010 environment. That should give you enough time to prepare for the 2010 exams. Don't be fooled these are tough exams and you really have to know your stuff. Because the exams are based on the general application you have to know the whole package. For Access for instance you should know your objects (table design), forms, filtering, reports, queries etc. But also the Access settings which you find under the office button in 2007 and File in 2010.

    How to prepare for these exams?

    It depends on your own preference. In my opinion you really should know your way around in other words know the ribbon. Which functionality can i find where. Knowing that is the biggest advantage you can accomplish. The Step by Step books are great for prepping because the go through the apps in general just as the exam does. When you are done practicing with the book and your working knowledge it say go for it and give it a try.

    Remember that Access 2010 isn't out there yet so if you want Access it will have to be 2007 (not a bad starter in my opinion). Excel 2010 is the core exam (the basic one). The other isn't released yet.

    So it's up to you to decide.

    Anything else you might want to know you know where to find us.

    Good luck

    Maurice


    Maurice
    Wednesday, October 6, 2010 9:14 PM

All replies

  • Hi,

    Thank you for your post here. Let's see if we can answer some questions for you here.

    First of Access 2007 and 2010 are compatible. Interface wise they look different and there are new additions in 2010 such as a new macro editor and webdatabases. I work a lot with Access and have to say the general idea is thinking database and objects. For exams you should consider that new features are always important and will be a part of the exam. So if you are familiar with 2007 i'd say go for that one first. It will give you an idea of how the exam works and what you might expect for the next exam.

    Furthermore in 2010 you have two Excel exams against one in 2007. So go for the 2007 versions first and after that go for the 2010 environment. That should give you enough time to prepare for the 2010 exams. Don't be fooled these are tough exams and you really have to know your stuff. Because the exams are based on the general application you have to know the whole package. For Access for instance you should know your objects (table design), forms, filtering, reports, queries etc. But also the Access settings which you find under the office button in 2007 and File in 2010.

    How to prepare for these exams?

    It depends on your own preference. In my opinion you really should know your way around in other words know the ribbon. Which functionality can i find where. Knowing that is the biggest advantage you can accomplish. The Step by Step books are great for prepping because the go through the apps in general just as the exam does. When you are done practicing with the book and your working knowledge it say go for it and give it a try.

    Remember that Access 2010 isn't out there yet so if you want Access it will have to be 2007 (not a bad starter in my opinion). Excel 2010 is the core exam (the basic one). The other isn't released yet.

    So it's up to you to decide.

    Anything else you might want to know you know where to find us.

    Good luck

    Maurice


    Maurice
    Wednesday, October 6, 2010 9:14 PM
  •  

    Hi 

    Which 2 exams for Excel 2010 are required? I though it is only one exam!


    Thursday, December 16, 2010 1:29 PM
  • Hi,

    For Excel 2010 there are two exams. The first one is the 'core' exam which is the regular one. This one is already available. There is a second one on it's way "Excel Expert". This variant is also going to be available for Word. The expert exams are a lot harder the the regular 'core' exams and really expect you to know the difficult options within both applications.

    When you want to become a MOS Master you need the expert exams, PowerPoint and Access or Outlook. From the last two you have to pick one, PowerPoint is mandatory.

    So when Excel 'core' is done you are certified for Excel but this exam doesn't count for the MOS Master credential.

    The expert exams will be released in the beginning (end Q1) of next year.

    Hope this clarifies is somewhat for you.

    Maurice


    Maurice
    Thursday, December 16, 2010 3:21 PM
  • Hi,
             Please tell me how can i give

    Exam 77-851:

    Excel 2007 Expert

    I m new here..

    Tuesday, January 17, 2012 8:00 AM