Monday, October 4, 2010

Up to speed with Access 2007

In this part of the practise, I made a Microsoft Access 2007 Course in this web page. This is the summary of my experience.

One of the new stuff is the Getting Started page. In this page, we can see many categorized templates that let we to start any job we want. Acces 2007 works like older versions, but there's two new features: The Ribbon (a toolbar with the new Microsoft design) and the microsoft Office Button. The Ribbon is organized in tabs, and each tab contains different commands, organized in logical groups. The Microsoft Office Buttons contains some basic commands for work with files, a list of recents documents, and a button to change or view the program settings.

After watching the video demonstration, I made apart of the Microsoft Office test. This part of the test questions you some things about all the things explained before, like where can you set the Acces options (in the Microsoft Office Button).

After doing the test, the video tutorial explain us how to create a new database: In the getting Started page, we are able to select a template and choose a name for it. Then, explains us how to add a table using the new features in the ribbon tab "Create". With a very similar method we can add forms and reports, thanks to the Ribbon Tabs.

After this, I made a practise that involved creating a new databes, with a table, a form and a report, with the method explained in the video tutorial (very easy), and a test, with some questions about this method.

Access 2007 uses a new file format: .accdb. This new format make databases mroe secure, more compact and more reliable if a file does become corrupted. To convert an older database we only have to open it with Access 2007 and save it as Access 2007 database, and the method is almost the same to do the inverse process.

The next practise was quite simple; open a database and convert it to many Access versions. After that, I made a few questions about all the things learned. Then, the practise was over.

Excel 2007: New Features Summary

In this part of the practise, I'm going to talk about new features of Microsoft Excel 2007. The most obvious new feature It's the new design of the toolbar. It contains a new surface with the most used tools, like copy and paste, distributed in many tabs with different functions; insert (for insert things), page layout, formulas...

With this Excel version we are able to view how our sheets are going to look when they are printed, and edit the layout in any ways we want; adding a header or a footer, editing margins, etc. Another usefull tool it's the Switch Windows button; with this tool we can switch different sheets at the same time.

Also, Microsoft Excel 2007 works as other and older versions, so we can perfectly work with it also if we haven't experience with this new version.

PRÁCTICA 1b: On-line Exercises (www.ego4u.com)

First I made some exercises on Simple Past tests here. I have some problems with the use of was/were, so I did the exercise of this form. For my surprise, I made all the exercises well without problems.

I want to use this blog after ending the english practises, so I made some writing exercises here. And another time, I hadn't any problems, even with relative clauses (who, which, whose), a thing that I ever thought it was difficult.

In order to finish, I made some exercises of vocabulary lessons here. I see there a very interesting lesson about Both, Either, Neither, Nor and So; With this exercice I have some problems with the use of when do you have to use this forms. I think I must practise more with this thing.

Finally, I think that will be impressive if here there were some exercises of pronunciation, like that "Learn English" videogame. I have some problems with some words, like "images", that I don't really know how to say it.