Microsoft Access 2010
Microsoft Access is database software that is commonly used by small businesses, companies or people with low knowledge of database. It processes many types of data such as, text, number, date/time, currency, Boolean, attachment, hyperlink, and so on. We use Microsoft Access to keeps the record, creates tables, queries, data relationship, forms, reports, and so on. Also, it is a relational database, which contains of fields and records. We can set up a relationship between tables by linking the common fields of tables. Moreover, in Microsoft Access, we use field to keep a uniquely data, for example, Student ID, First Name, Last Name, Age, Address, and so on. It provides many important features that help us to do the work easily. For instance, it allows simple or complex graph presentation, has extensive report functionalities, has database query facility, has Wizard to create data bound grids, and it has Visual Basic program procedures. In addition, Microsoft Access 2010 is attached to user interface objects such as, command button, text box, form, and report. We can create reports In Microsoft Access with two methods which are report wizard, and report design. From the two methods, we can create and design different types of report as we want. Finally, Microsoft Access is important and useful software for my future job in the field of Management of Information System. The management skill cannot work easily without database software, therefore; Microsoft Access is good software for me to management all the event and contract happen in future my company.
SQL Server
SQL Server stands for Structured Query Language. It is a language that is widely used among enterprise class database system. SQL Server processes data type of integer, character, float, binary, decimal, money, real, datetime, text, image, cursor, table, timestamp, and so on. Also, SQL Server is a relational database that its data can be organized into a two dimension tables. There is relationship between data in the tables.
The features of SQL Server are PowerPivot, Master Data Services, Streamlnsight, data-tier, and SQL Server utility. PowerPivot allows user to import, manipulate, analyze, and export data, while Master Data Services is the new and powerful feature to help organization to create structure and hierarchy for data. Streamlnsight is a new platform integrated with .Net and SQL Server for streams of data in parallel, whereas data-tier is functionally in Visual Studio, while SQL Server Utility allows for a single management dashboard across multiple servers and databases. Moreover, table structure of one file in SQL Server is the actual data in the table is stored in Pages, except BLOB data. The Page is a smaller unit of storing data in SQL Server and it contains the data in rows. A group of 8 adjacent pages together, we call an Extent. In addition, the graphic user interface of form of SQL Server contains of command button, text box, combo box, check box, list box, label, and so on. We can also create report in SQL Server by using report designer, or custom report. Finally, I can see this SQL Server database software is most important for my future job as the information system manager. I will use this database software since it is most powerful and capable with many enterprise class database systems.
Fabulous! These reviews about database programs are quite good. It provides abundant amount of information which allows the people to evaluate whether they want to use the programs or not according to their needs. From my experience, I think Microsoft Access is quite hard for computer newbies because of its complexities that needs time to train in order to master. For SQL Server database software, can we use it to run small business? And is the process of entering the data similar to Microsoft Access?
ReplyDeleteThis is a very good review. You have pointed out the importance of using Microsoft Access 2010 which gathers many features and facilities to complete the task easier and faster than the old version. For SQL server, it is a major program for your department(MIS) as well as computer science, thus, the features and facilities will encourage the user to complete the task efficiently.
ReplyDeleteYour review is very useful for me, the uses of Microsoft Access 10 is more better than the old version, which features the functionality and facility that can improve the usage of this software. For SQL server, I might not need to use this software since I am from Banking and Finance sector, however for you study in Management Information System, it is definitely necessary for you to take over the software.
ReplyDeleteThis database program is good. It provides information which allows the people to evaluate whether they want to use the programs or not according to their needs. From my experience, I think Microsoft Access is too general for users because people mostly use everywhere.
ReplyDelete