Q. What is the pre-requisite for taking the exam 77-602?

A. Although there are no prerequisites for the exam 77-602 – MCAS – Using Microsoft Office Excel 2007, Microsoft recommends that the candidates for this exam should have the equivalent of six months to one year of hands-on experience on Microsoft Office Excel 2007 and might have experience with previous versions of Microsoft Office Excel.

Q. What certificate does it provide?
Continue reading

Q. What is the prerequisite for taking the test Security+ 2008 Edition (SY0-201)?

A. There is no prerequisite for taking the test SY0-201. However, it is recommended that CompTIA Security+ candidates should have at least two years on-the-job networking experience, with an emphasis on security. The CompTIA Network+ certification is also recommended for taking the test.

Q. What certificate does it provide?
Continue reading

Q. What is the 70-502 VB.NET exam?

A. The Microsoft 70-502 VB.NET exam measures your knowledge and skills in developing and implementing Windows-based applications by using Microsoft .NET Framework 3.5. This exam measures your knowledge of Microsoft Visual Studio 2008. You have to take this exam along with 70-536 VB.NET. NET in order to achieve the MCTS: .NET Framework 3.5 – Windows Presentation Foundation Applications certification.

Q. What are the prerequisites of the 70-502 VB.NET exam? Continue reading

Mike Rand

Mike has 10 years of experience in the software development field. He¬†¬†started his career at a small manufacturing company where he used to work on different Quality control related database applications. After having worked at the Manufacturing company, Mike joined Macy’s (Many people might recognize Macy’s as “The Bon Marche” as it was earlier reknowned by this name). At Macy’s Mike used to work on Applications and Websites for various departments of the organization like Accounting, Maintenance, Visual Merchandising etc.

After leaving Macy’s Mike began working at 3Sharp a software consulting company in Redmond Washington specializing in Office Applications and SharePoint.

His love and passion drove him to acquire and share knowledge about various new technologies and certifications. One can read his articles on http://blogs.3sharp.com

After reviewing the uCertify prepkit for the exam 70-528, Mike said “Overall I like this product. When I’m getting ready to take future exams I will definitely check uCertify”. Continue reading

Introduction to JavaScript

  • VBScript is another scripting language that uses Visual Basic code for writing scripts.
  • ECMA approved JavaScript as an international standard in 1997.
  • The Microsoft version of JavaScript is known as JScript.
  • JavaScript is the first scripting language used for a browser.
  • The old name of JavaScript is LiveScript.
  • CGI was used to validate forms when JavaScript was not developed.
  • JavaScript is the default scripting language of Netscape Navigator.
  • If the language attribute is not defined, Netscape Navigator uses JavaScript as the default scripting language.
  • Netscape develops the JavaScript language.
  • A property is an attribute of an object used to change the style of the object.
  • Every property has a value that changes the style of an object.
  • JavaScript is interpreted at runtime. The script is not compiled.
  • The comment tag is used to hide the script from the non-scriptable browsers.
  • The <script>…<script> tag is used to insert scripts in a Web page.
  • An HTML document can contain any number of <script>…<script> tag
  • A variable declared inside the <script>…<script> tag but outside any function is known as global variable and can be accessed from any function within the <script tag>.
  • The increment (++) operator is used to increment the value of a variable by one.
  • Instantiation is a process of creating copies of different objects.

Continue reading

Envisioning the Solution

  • A solution concept is developed based on the existing business strategy. A developing team creates the solution concept on the basis of the business requirements and scope of the solution.
  • A project team identifies and understands the current business process in order to incorporate it in the proposed or new system.
  • During the Envisioning phase of the business project, the project team evaluates the current business situation. The team analyzes the difference between the current and expected business situation. A gap analysis is performed to identify a path towards the desired state of a business. The team also identifies and outlines the scope of the project.
  • A team identifies basic solution concept during the Envisioning phase.
  • A feasibility study determines and documents a project’s viability. The analysis of the feasibility study identifies whether a particular business concept can be realized as a scalable design.
  • During the Envisioning phase, various tasks are identified that address the goals and constraints of the project. During this phase, the project team determines the objectives of the solution by identifying business problems or opportunities.
  • A team analyzes business feasibility of a solution during the Envisioning phase.
  • The project scope is the number and complexity of tasks to be performed by a software solution. The scope comprises the overall project requirements and incorporates the constraints imposed on the project by resources, time, and other limiting factors.
  • Pass Microsoft .NET Certification in first attempt.

  • Download Free Practice test and Study Notes for Microsoft 70-300 Analyzing Requirements
  • Download Free Practice test and Study Notes for Microsoft 70-315 Web Applications with C# .NET
  • Download Free Practice test and Study Notes for Microsoft exam 70-316 Windows Based Application C#.NET
  • Download Free Practice test and Study Notes for Microsoft exam 70-320 Developing XML Web Services C#.NET
  • Project scope defines what will or will not be included in a project. Therefore, the project scope is the number and complexity of tasks to be performed by a software solution.
  • A team prepares the functional specification that will contain the scope of the solution. The project scope is the number and complexity of tasks to be performed by a software solution.
  • A developer plans and creates modules in order to define scope components in a project.
  • A project team identifies and analyzes the current and expected business system of an organization.
  • The project team identifies a set of initial risks during the Envisioning phase. The best technique to manage a risk is to identify all the potential risks with high priority level and to prevent them by following a good mitigation and prevention strategy.
  • During the solution development, greatest potential risks of an organization are identified.
  • A project team monitors the status of high-priority risks of an organization. The team identifies a set of initial risks during the Envisioning phase. This set of risks is continuously updated at the later phases of the project.
  • A team should identify the biggest threat that can occur within the organization. It should also try to control and mitigate the threat to the organization.
  • Risk Management is a decision-making process that involves the organization, users, and the project team. It deals with the uncertainties that might occur during the application development. This ensures that all the vital assets and resources of the organization are safeguarded.
  • A team identifies business risks of an organization.

Media and Topologies

  • Centralized computing is an environment in which a mainframe computer provides data storage and computational abilities.
  • Bus topology uses a 10Base2 cable.
  • Bus topology is the easiest to implement.
  • Bus and Ring are zero fault tolerant topologies.
  • Full-mesh topology is the most fault tolerant topology.
  • Mesh topology is a type of physical network design where all devices in a network are connected to each other with many redundant connections.
  • In star topology, when a single connection to one of the network hosts fails, the failed connection will be down and the host will not have network connectivity.
  • LEDs on a network card of a client computer indicates the sending and receiving of data.
  • Continue reading

E-Commerce Site Development

  • MIME stands for Multipurpose Internet Mail Extensions. It is a standard for multi-part, multimedia electronic mail messages and World Wide Web hypertext documents on the Internet.
  • The number of hits per page will help you rank the Web pages in your site according to their popularity. The number of hits per page denotes the number of clicks on that particular page. The more the number of hits, the more popular is the page.
  • Electronic commerce (E-Commerce) includes the buying and selling of goods and services, and the transfer of funds, through digital communications.
  • E-Commerce increases efficiency, opens new markets, and can be used to communicate directly with the customer.
  • A Web site that is created should be efficient and easy to use. This is the main idea behind usability.
  • AutoComplete is a feature of a browser in which the user is provided with the options he has previously used.
  • The integration that can be used to manage data, security, etc., for the sales of goods and services conducted through the Internet is known as e-commerce.
  • Continue reading

Installing and Configuring SQL Server 2005

  • In order to change collation settings, reinstall SQL Server 2005 on a server with the same collation settings as another server.
  • In order to install SQL Server 2005 on a computer on which SQL Server 2000 is already installed, install SQL Server 2005 as a named instance.
  • Members of db_access role can assign permissions to other users to enable them to access and query the database.
  • RAID-0, also known as disk striping, is made up of a disk set in which data is divided into blocks and spread equally in each disk. It provides best performance because data read and data write operations are not limited to a single disk, but to a set of disks. It does not provide data redundancy. Data once lost cannot be recovered.
  • The Service Broker can be attached to a database by using the FOR ATTACH clause of the CREATE DATABASE statement.
  • If a snapshot of a database is present on the same computer on which the database is present, the database cannot be deleted.
  • In order to connect to the DAC, specify ADMIN: server_name in the Connect to the Server dialog box.
  • The login information stored in the master database.
  • In order to secure data that is data transmitted over a network, set the value of the ForceEncryption option on a server to Yes.
  • In order to enable a user to connect to the database, a DBA should add the user to that database.
  • The db_ddladmin fixed database role allows its members to add, modify, or drop objects in the database. Members of the db_ddladmin role can issue DDL statements (e.g. CREATE, ALTER, and DROP) in the database.
  • Member of db_ddladmin role have the permission to execute the T-SQL statements.
  • The sysadmin role allows a user to view the security log.
  • Continue reading