Join David Rivers for an in-depth discussion in this video Understanding the reasons to switch, part of Migrating from Access 2003 to Access 2010.
Access 2010 offers a number of major improvements and enhancements that make upgrading from Access 2003 worthwhile. There's an improved user interface with a new layout view to help you stay organized when working with forms and reports. There are new helpful fields you can use in your tables, and you can use rich text formatting now when working with Memo fields. In this movie, we will get a brief overview of some of these features before covering them in greater detail later on in this course. We will begin with the new fluent user interface, which has been improved to help you work more efficiently and improve your 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 will also find quick and easy access to relevant commands using the Quick Access Toolbar and mini toolbars that appear when selecting a rich text in a field. With Access 2010, 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 in Access 2010, it's a simple process to convert your older databases to the new Access 2010 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. Being able to view the form or report with real-life data while you design it eliminates the need to change views back and forth to preview the end result. Now you can make use of some of the new field types in Access 2010.
For example, if you need the users to insert dates into a form that you've created, you can use the new Date Picker Property when using date and time fields. 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 the expense amount into a field and then attaching a scanned image of the receipt to back it up.
With the added benefit of better compression in Access 2010, users won't need to be concerned about database bloat. Lastly, you will be able to apply rich text formatting to your text and Memo fields without the need for third-party controls. Access 2010 stores this formatting as HTML, so users will be able to apply color, bold, italics, underlining, and more to the text they enter in 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 2010.
We will be exploring these reasons in greater detail as we move through the various chapters in this course.
- Comparing the Access 2003 and 2010 interfaces
- Exploring the Ribbon and Backstage view
- Dealing with file compatibility issues
- Converting older databases to the 2010 format
- Creating navigation forms
- Adding field-level attachments
- Formatting rich text in memo fields
- Using keyboard shortcuts