Monday, April 30, 2012

I am a Management of Information System (MIS) student at Zaman University, Phnom Penh Cambodia. MIS is a new major in Cambodia, and it provides many field of future job such as:
    - Information Technology Specialist
    - Software Engineering
    - Database Analyst
    - Database Administration
    - Network Engineer
    - Information Systems Security Engineer
    - Business Development Manager for ICT Companies
    - Systems Analyst
    - Web Developer
    - IT Development Project Leader
    - System Developer
    - Business Application Developer
    - Business and Financial Markets Analyst
    - Banking, Finance and Auditing Analyst

After I graduate from Zaman University in 2015, I would like to be a business development manager for ICT Companies. To be at this position, I need to know how to use some database software. I will choose two database software which are Microsoft Access and SQL Server for my future career.

Sunday, April 29, 2012

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.