none
will 70-432 exam, help me for connectin Microsoft Access 2007 with SQL-Server 2008?? RRS feed

  • Question

  • hello guys.

    i've some knowlegde in Access 2007, i could do easily queries, reports, forms macros etc.

    But i want that DATA TO BE STORED ON SQL SERVER 2008.

    i need to know, if learning for 70-432 exam, will help me to achieve my goal.

    Thank you for your quick responce.

    Wednesday, December 29, 2010 1:21 PM

Answers

  • Hi Erind,

    the 70-432 exam will only help you to set up an SQL Server and maintain it (e.g. do backups/restors, take care of security, ....)

    It will not teach you, how to create a database and create tables, views, stored procedures, ....

    If you want to learn about that, the 70-433 exam is much better. But even with this exam, you only learn the SQL Server part. It does not explain, how to connect your access database to it and how to build a good client side access application.

    With kind regards,

    Konrad

    Wednesday, December 29, 2010 2:32 PM
    Answerer
  • Take a look through the exam requirements to see if you think it will meet your needs, there's definitely no harm in learning all that stuff as it will help you to design better solutions.

    There's a link to the skills measured for the exam here: http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432&locale=en-us#tab2

    I wrote a quick blog entry on how I prepared for this exam earlier in the year: http://sql.richarddouglas.co.uk/archive/2010/06/my-wife-always-said-i-was-certifiable.html


    If you find this helpful, please mark the post as helpful,
    If you think this solves the problem, please propose or mark it an an answer.

    Please provide details on your SQL Server environment such as version and edition, also DDL statements for tables when posting T-SQL issues

    Richard Douglas
    My Blog: Http://SQL.RichardDouglas.co.uk
    Twitter: @SQLRich
    Friday, December 31, 2010 12:36 PM

All replies

  • Hi Erind,

    the 70-432 exam will only help you to set up an SQL Server and maintain it (e.g. do backups/restors, take care of security, ....)

    It will not teach you, how to create a database and create tables, views, stored procedures, ....

    If you want to learn about that, the 70-433 exam is much better. But even with this exam, you only learn the SQL Server part. It does not explain, how to connect your access database to it and how to build a good client side access application.

    With kind regards,

    Konrad

    Wednesday, December 29, 2010 2:32 PM
    Answerer
  • Take a look through the exam requirements to see if you think it will meet your needs, there's definitely no harm in learning all that stuff as it will help you to design better solutions.

    There's a link to the skills measured for the exam here: http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432&locale=en-us#tab2

    I wrote a quick blog entry on how I prepared for this exam earlier in the year: http://sql.richarddouglas.co.uk/archive/2010/06/my-wife-always-said-i-was-certifiable.html


    If you find this helpful, please mark the post as helpful,
    If you think this solves the problem, please propose or mark it an an answer.

    Please provide details on your SQL Server environment such as version and edition, also DDL statements for tables when posting T-SQL issues

    Richard Douglas
    My Blog: Http://SQL.RichardDouglas.co.uk
    Twitter: @SQLRich
    Friday, December 31, 2010 12:36 PM