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.

1 comment:

  1. In this part of the practiCe, 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 US start any job we want. Acces 2007 works like older versions, but there ARE 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 recent-- 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 ASKS you some things about all the things explained before, like where you CAN set the Acces options (in the Microsoft Office Button).

    After doing the test, the video tutorial explainS 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, IT 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 practiCe that involved creating-- 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 makeS 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 practiCe 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 practiCe was over.

    ReplyDelete