Join David Rivers for an in-depth discussion in this video Understanding the reasons to switch, part of Migrating from Access 2003 to Access 2007.
- View Offline
Access 2007 offers a number of major improvements and enhancements that make upgrading from Access 2003 worthwhile. There is an improved user interface with a new layout view to help you stay organized when working with forms and reports. There are new and helpful fields you can use in your tables and forms, and you can use Rich Text Formatting now when working with Memo fields. In this movie, we'll get a brief overview of some of these features before covering them in greater detail later on in this course. We'll begin with the new Fluent User Interface, which has been improved to help you work more efficiently and improve productivity.
The Ribbon allows you to spend more time getting your work done and less time searching for commands by making them easier to find and use. You'll also find quick and easy access to relevant commands using the Quick A ccess toolbar, and the new mini toolbars that appear when working with selected text. With Access 2007, you can continue to work with your older databases created in Access 2003, and when you're ready to make use of the added functionality here in Access 2007, it's a simple process to convert your older databases to the new Access 2007 format.
There are also a number of new features to help improve your productivity and efficiency when working in Access. For example, you no longer have to be in Design view to work on the design of your forms and reports. Layout view is a new view that allows you to preview the layout of your form or report while you work on its design. So, being able to view the form or report with real-like data, while you design it, eliminates the need to change views back and forth to preview the end result. And now you can make use of some new field types in Access 2007. If you need users to insert dates into a form that you've created, users can now pick dates off a pop-up calendar as opposed to typing them into a form field.
This helps to eliminate the possibility of improperly entered dates due to confusing date formats. Also, users will be able to attach files to a record now, as they fill in a form or table. Imagine entering an expense amount and attaching a scanned image of the receipt to back it up. And with the added benefit of better compression here in Access 2007, they won't need to be concerned about database bloat. Lastly, you'll be able to apply Rich Text Formatting to your text in Memo fields without the need for third-party controls.
Access 2007 stores this formatting as HTML, so users will be able to apply color, bold, italics, underlining, and more to the text they enter into a Memo field. So, I hope this brief overview has helped to show you why you might want to migrate from Access 2003 to Access 2007. We will be exploring these reasons in greater detail as we move through the various chapters in this course.
- Comparing the Access 2003 and 2007 interfaces
- Changing the default file format
- Ensuring compatibility with the Compatibility Checker
- Controlling Access with keyboard shortcuts
- Adding attachments to records with the Attachment field type
- Converting older databases
- Filtering data without a query
- Designing in the improved Layout View