Chapter 4, Problem 4.1UYK

a.

Explanation of Solution

Microsoft Access 2016:

Microsoft Access 2016 is one of popular programs which can support you in dealing with database.

The functions of Microsoft Access is listed below:

• String function
• Numeric/Math function
• Date/Time function
• Advanced/Logical function
• Information function
• Domain function
• Data type conversion function
• Group by function

Microsoft OneNote 2016:

Microsoft OneNote 2016 is a program which is available for free cost to collect the information by notes, drawing, audios, and screen clippings.

Some of features which is newly added to OneNote 2016 is given below:

• Office integration features such as embedded Excel spreadsheets and outlook tasks.
• Template can be applied to pages to sustain a particular look.
• Classify notes with custom tags and rapidly search them later.
• It stores the notebooks on local drive.

Microsoft Windows server 2016:

Microsoft windows server 2016 is an operating system for server which is developed by Microsoft.

The new features which is added into windows server 2016 is given below:

• Nano server
• Container
• Linux secure boot
• ReFS (Resilient File System)
• Storage spaces direct
• ADFS v4 (Active Directory Federation Services)
• Nested virtualization
• Hyper-V Hot-Add Virtual Hardware
• PowerShell direct
• Shielded VMs
• Final Thoughts

Microsoft Project 2016:

Microsoft Project 2016 is a project management software which helps the project manager to plan, allocate the tasks, track, manage, and analyze the work.

The new features which is added into Project 2016 is given below:

• Architectural enhancements
• Data consolidation with SharePoint
• Multiple visual timelines
• Resource heatmap view
• Resource engagement request
• Project unique ID
• Other API (Application Program Interface) improvements

Microsoft Visual Studio 2015:

Microsoft Visual Studio 2015 is the code which is based on files and folders in integrated development environment (IDE). It helps to develop the program, web apps, mobile apps, web sites, and web services.

The new features which is added into Visual Studio 2015 is given below:

• Custom window layouts
• Debug Lambdas
• Better code editor
• Shared projects
• IntelliSense for Bower and NPM (Node Package Manager)

Microsoft SQL Server 2016:

Microsoft SQL Server 2016 is relational database management system (RDBMS) which helps to store and retrieve the data as requested by applications.

The functions of Microsoft SQL server is listed below:

• Aggregate functions
• Analytic functions
• Rowset functions
• Ranking functions
• Function determinism
• Function collation
• Scalar function

Microsoft Visio 2016:

Microsoft Visio 2016 is application for diagrams and vector graphics which helps to create simple or complicated diagrams.

The new features which is added into Visio 2016 is given below:

• Excel data
• Information rights management (IRM) protection
• Modernized shape for office layouts
• Detailed shapes for site plans
• Upgraded shapes for floor plans
• New range of starter diagrams
• Modernized shape for home plans

b.

Explanation of Solution

Microsoft Access 2016:

Microsoft Access 2016 is one of popular programs which can support you in dealing with database.

Microsoft OneNote 2016:

Microsoft OneNote 2016 is a program which is available for free cost to collect the information by notes, drawing, audios, and screen clippings.

Microsoft Windows server 2016:

Microsoft windows server 2016 is an operating system for server which is developed by Microsoft.

Microsoft Project 2016:

Microsoft Project 2016 is a project management software which helps the project manager to plan, allocate the tasks, track, manage, and analysis the work.

Microsoft Visual Studio 2015:

Microsoft Visual Studio 2015 is code which is based on files and folders in integrated development environment (IDE). It helps to develop the program, web apps, mobile apps, web sites, and web services.

Microsoft SQL Server 2016:

Microsoft SQL Server 2016 is relational database management system (RDBMS) which helps to store and retrieve the data as requested by applications.

Microsoft Visio 2016:

Microsoft Visio 2016 is application for diagrams and vector graphics which helps to create simple or complicated diagrams.

Therefore, “Microsoft windows server 2016” is referred as operating system and “Microsoft Access 2016”, “Microsoft OneNote 2016”, “Microsoft Project 2016”, “Microsoft Visual Studio 2015”, “Microsoft SQL Server 2016”, “Microsoft Visio 2016” are referred as application programs.

c.

Explanation of Solution

Microsoft Access 2016:

Microsoft Access 2016 is one of popular programs which can support you in dealing with database.

Microsoft OneNote 2016:

Microsoft OneNote 2016 is a program which is available for free cost to collect the information by notes, drawing, audios, and screen clippings.

Microsoft Windows server 2016:

Microsoft windows server 2016 is an operating system for server which is developed by Microsoft.

Microsoft Project 2016:

Microsoft Project 2016 is a project management software which helps to project manager to plan, allocate the tasks, track, manage, and analysis the work.

Microsoft Visual Studio 2015:

Microsoft Visual Studio 2015 is code which is based on files and folders in integrated development environment (IDE). It helps to develop the program, web apps, mobile apps, web sites, and web services.

Microsoft SQL Server 2016:

Microsoft SQL Server 2016 is relational database management system (RDBMS) which helps to store and retrieve the data as requested by applications.

Microsoft Visio 2016:

Microsoft Visio 2016 is application for diagrams and vector graphics which helps to create simple or complicated diagrams.

Therefore, “Microsoft windows server 2016”, “Microsoft Access 2016”, and “Microsoft SQL Server 2016” are DBMS (Database Management System) products.

d.

Explanation of Solution

Microsoft Access 2016:

Microsoft Access 2016 is one of popular programs which can support you in dealing with database.

• It is trailware software which is built in time limit.

Microsoft OneNote 2016:

Microsoft OneNote 2016 is a program which is available for free cost to collect the information by notes, drawing, audios, and screen clippings.

• It is free to download this software program.

Microsoft Windows server 2016:

Microsoft windows server 2016 is an operating system for server which is developed by Microsoft.

• It is trailware software which is built in time limit.

Microsoft Project 2016:

Microsoft Project 2016 is a project management software which helps to project manager to plan, allocate the tasks, track, manage, and analysis the work.

Microsoft Visual Studio 2015:

Microsoft Visual Studio 2015 is code which is based on files and folders in integrated development environment (IDE). It helps to develop the program, web apps, mobile apps, web sites, and web services.

• It is free of cost to download this software program.

Microsoft SQL Server 2016:

Microsoft SQL Server 2016 is relational database management system (RDBMS) which helps to store and retrieve the data as requested by applications.

• It is proprietary software that is sometime no cost to download or fee required for download.

Microsoft Visio 2016:

Microsoft Visio 2016 is application for diagrams and vector graphics which helps to create simple or complicated diagrams.

• It is trailware software which is built in time limit.

Therefore, “Microsoft OneNote 2016” and “Microsoft Visual Studio 2015” are download and install tonight.

e.

Explanation of Solution

(1)

Microsoft Access 2016:

Microsoft Access 2016 is one of popular programs which can support you in dealing with database.

• It is trailware software which is built in time limit.

Microsoft OneNote 2016:

Microsoft OneNote 2016 is a program which is available for free cost to collect the information by notes, drawing, audios, and screen clippings.

• It is free to download this software program.

Microsoft Windows server 2016:

Microsoft windows server 2016 is an operating system for server which is developed by Microsoft.

• It is trailware software which is built in time limit.

Microsoft Project 2016:

Microsoft Project 2016 is a project management software which helps to project manager to plan, allocate the tasks, track, manage, and analysis the work.

Microsoft Visual Studio 2015:

Microsoft Visual Studio 2015 is code which is based on files and folders in integrated development environment (IDE). It helps to develop the program, web apps, mobile apps, web sites, and web services.

• It is free of cost to download this software program.

Microsoft SQL Server 2016:

Microsoft SQL Server 2016 is relational database management system (RDBMS) which helps to store and retrieve the data as requested by applications.

• It is proprietary software that is sometime no cost to download or fee required for download.

Microsoft Visio 2016:

Microsoft Visio 2016 is application for diagrams and vector graphics which helps to create simple or complicated diagrams.

• It is trailware software which is built in time limit.

Therefore, “Microsoft OneNote 2016” and “Microsoft Visual Studio 2015” are download and install tonight. Because, both software programs are free of cost. So it can be downloaded easily.

f.

Explanation of Solution

“Yes”, DreamSpark provides much benefits to Microsoft.

Reasons:

• DreamSpark is an application program which access the Microsoft designer and development tools for students over the world, to support, and advance the student skills with free of cost.
• It aims to support the students in technical wise by giving rights to access all Microsoft software design with free of cost.
• Later, the program was renamed to Microsoft Imagine to provide the better align with annual imagine Cup in the year of 2016