OPS Technical SolutionsWelcome
Oracle has decided to give Microsoft and Google some competition with its new productivity suite Cloud Office. Cloud Office is based on open office and is also based on ODF (Open Document Format). It includes a spreadsheet application, Text presentation and supports online collaboration. It is compatible with Microsoft Office .The compatibility with Microsoft office comes through a plug-in which is not free. Oracle is charging 90 dollars for it. It has been primarily linked with the Oracle Open Office 3.3.
It can be used to share documents over the internet and boasts of mobile compatibility. It supports sharing of document through its compatibility with Microsoft Office and web 2.0.
“Customers now have the flexibility to support users across a wide variety of devices and platforms, whether via desktop, private or public cloud,” commented Michael Bemmer, vice president of Oracle Office.
This is not just about competing with Google and Microsoft but an attempt at a grab for the slice of the current 3.3 Billion Dollar industry which in the next ten years could grow up to 20 billion Dollars. Whatever Oracle’s intentions are, it sure has raised concerns among the supporters of Open Source software.
Cloud office comes with a hefty price of 49.95 dollars per user for the standard edition and 90 Dollars for the enterprise edition. It is only for businesses and will be delivered as a SaaS (software as a service) service.
Oracle has made massive attempts at the release of CloudOffice to promote it. Oracle in its official blog states that “Oracle office will help end users to reduce cost by up to 5x, help in greater collaboration and lead the your organization into an open standard strategy with ODF”
OpenOffice of which oracle is a major contributor states in its mission statement “To create, as a community, the leading international office suite that will run on all major platforms and provide access to all functionality and data through open-component based APIs and an XML-based file format.” So this Cloud office by oracle is clearly an attempt by oracle to steal into Microsoft’s revenue stream.
However, this has ruffled some feathers back in the open office camp led by oracle where 33 members walked off and formed The Document Foundation as a separate development group. Oracle has tried to play down the concern over the release of CloudOffice by maintaining its stand behind OpenOffice and continuing its support in the growth and development of OpenOffice.
Microsoft Office Access is one of the famous Database Management System developed and manufactured by Microsoft. It was earlier marketed as Microsoft Access but it has recently been re-branded by Microsoft. This application is used for creating database and store data it its original format which is supported by the latest technology known as Access jet Database Engine. It is also used to import data and link data directly from other applications and databases. Which means you can access an Access database with any other database files like Oracle and SQL.
It is very important to keep in mind that in the real world how Microsoft Access is used with other products. A complete Access solution may have Microsoft Access Forms and Reports managing Microsoft Access tables. On the other hand, Microsoft Access can be used only as the front-end, using another product for the back end tables like as Microsoft SQL server and non Microsoft products like Oracle. Similarly, some applications will only use the Microsoft Access tables and use another product as a front end like Visual Basic or technologies like Microsoft Excel, Microsoft outlook and ActiveX Data Objects.
Below I am giving few steps to create an Input Form in MS Access.
Firstly select Form from the Objects menu which is on the left hand side of the Microsoft Access screen. you can now select Create form using Wizard from the menu that appears but you can create forms without the wizard or helper program, it will give a number of automatic functions for you and then you can easily change these menus once the form is created.
The second step is to select a data table where you want to insert the required information. This will show you the list of options where you need to select the specified fields data and items. You can also choose a number or a data field where you would like all the information to be stored. You can also use or choose more than one fields and the setup wizard will create different boxes automatically. These boxes can be used to represent separate information.
Once the above steps are performed successfully, you need to select the layout type. A layout type is a representation of the data which can be a Standard layout or a columnar layout. These settings can be edited even after the setup process or wizard is closed. Click on Finish once the steps are performed and then it will open the form in the standard layout. After this step, you will be able to modify the look and feel of the data represented using the standard layout frame.
Once all these steps performed you are ready to save the data and work you have done so far. You can always come back to the same screen if you would like to make any changes in future as well.
Have you ever encountered the error “C:\Documents.xls could not be found” in excel. Well, this error is not a generic error that is most often encountered in using MS Excel. When you open any Excel spreadsheet by double clicking the file, it successfully opens but so does the error, “C:\Documents.xls’ could not be found”, display? You can check the spelling of the filename and you can verify that the file location is correct, if you are trying to open the file from your list of recently used files on the file menu, you can make sure that the file has not been renamed, moved or deleted, its followed by several more errors referencing similar filenames which do not exist. The spreadsheet will ultimately open, but only after much provocation.
You can follow these steps fix this error, “C:\Documents.xls’:
To solve this problem Excel must be unregistered and then re-registered to do this, you can close your spreadsheet if it is open and exit from Excel.
Now click the windows start button and then click Run type this phrase exactly excel/unregserver( minus the quotations marks) now click ok button and the window will close.
Now click the windows start button again and after that click Run and type this phrase exactly excel/regserver ( minus the quotation mark ) now click the ok button and the window will close
After all above things now open your Excel spreadsheet again by double clicking the file. Now it should open this time with no errors, this procedure will resets Excel to its factory defaults in the windows registry, you should not reactivate Excel after performing these steps.
By these steps you can easily fix the “C:\Documents.xls’ could not be found.” error in MS Excel.
A database is collection of data in an organized format and there are various database applications available like FileMaker Pro, Oracle, SQL which makes the database management task simpler and flexible. Choosing a database application completely depends on the requirement and the complexity of data and if you are a home user or own a Small business, Microsoft Access makes the perfect choice. Microsoft Access is a DBMS computer application which is used to create and manage databases. This application is majorly used to manage Personal Information Management for small businesses.
MS Access comes with all major tools required to manage a database project and Scheduling is one of the important component. Scheduling, in other words, is to apply time management. Scheduling a task in MS Access is easier with available online templates provided by Microsoft Office online. Microsoft office is vastly used application in offices and home and users require add-ons to make the application better. Microsoft has been provided free tools, updates and security patches for all the application for the maximum performance. Microsoft has already release thousands of free resources related to Office products which makes it simple for any user to manage MS Office application.
Below are the very simple instructions to make schedule in Microsoft Access:
Select the Microsoft Access option from the Start Menu program list. Then open the ‘Template Category’ option from the Heading label and click on ‘Featuring’ option. If you are connected to internet, it would automatically lead to you to the Microsoft Office online webpage.
Once you are on the Microsoft Office online webpage, select “Browse for templates by industry option” or you can also search an Office template.
The next step would be to search for schedule template by typing “access schedule” in the “Search Template” box under “Templates”. Once the search is initiated, it will show the search result of the available templates. Select the template from the list which is compatible with Microsoft Access. The appropriate template will always have the Microsoft Access icon displayed in front of it.
A sample template like “Resource scheduling database” will be displayed on screen which needs to be downloaded by clicking the “download” button. This step will download the schedule template on your computer and once this step is finished, a message is appeared on Microsoft Office online website for the completion of successful download.
You do not need to reboot your system for changes to take effect. The computer will open the file itself and you can start using the schedule template by putting the scheduling information in.
These simple steps would allow downloading schedule template and make those templates work with Microsoft Access to manage time resources appropriately. With the vastly available schedule templates on Microsoft Office online website, you can choose an appropriate schedule template to work with Microsoft Access and make the scheduling in your database.
In times when CIOs must respond to real-time and big data demands by acquiring advanced databases, Oracle seems to be way ahead of IBM and Microsoft.
Opportunities for CIOs
CIOs have a huge chance of driving the expansion and innovation of their companies ahead but for that they would have to master the world of data. When all we hear is the inevitable burst of data and information, the enterprises must find a way to gather these bursts and use them to increase their own revenues or else face destruction by something they could not understand nor control.
Big data means turning all passively stored items into active ideas for business, based on customer choices and market fluctuations. Most enterprises posses loads of terabytes of raw materials and there are those who dare to use the latest in database management and analysis in order to master the data before the bursts.
Except everything else, there is also the challenge of real time business operation. That would mean to surpass just gathering and storing data into huge devices and come up with an advanced futuristic system, which allows instant analysis, processing and re-evaluation of large quantities of data to find new business possibility in real time.
The advantage of Oracle
Given this growing demand to match the new data challenges, many products and technologies were changed and remade accordingly. One of the biggest wars for aiding CIOs in gathering data is for databases between Oracle, IBM and Microsoft.
Nobody is surprised at the quite direct contentions of Oracle that their database products are way better than IBM and Microsoft. Their senior vice president Andy Mendelsohn, who is also the person in charge of Oracle’s database products said in an interview that the leaders in vision and technology will offer undoubted advantages to their customers and Oracle does precisely that in various foundation categories.
Oracle’s pride is the innovation in databases – being years ahead of Microsoft, he says. When they released RAC and ASM in 2001, Microsoft was nowhere and IBM had something that maybe worked with OLTP but no customers. The same is with Exadata – IBM has nothing like it and Microsoft has parallel data storage package, but not one, which does everything.
According to Medelsohn any business, greatly involved in IT and wanting to beat the competition, would choose Oracle and not remain years behind by choosing IBM or Microsoft. Huge and complex tasks, which could have collapsed the systems for long periods before, now can be easily analyzed for better answers and better business opportunities. And Oracle gives you just that by Exdata and other items, which is why it believes it’s 5-10 years ahead of its competitors.