In addition to quickly locating information, the database ensures consistency in the information by linking together the data in different tables.
The product allows you to present the data through both professional-looking forms and reports.
If no line is drawn, the displayed result will normally be a long list of every combination of records from each of the tables. For example ' Linking tables using wildcards provides the ability to update fields in a range of records in another table.
Occasionally however it is useful to have a wildcarded value as the link. This might be particularly useful in an accounting program where there is a need to update a field for a wildcarded selection of account codes.
Introduced in Office 2007, the ribbon provides a tabbed interface for working in the product.Set Up You don’t need any practice files to complete this exercise, but the MSOffice Pro Blank.accdb database you create here will be used in further exercises in this chapter.Start Access from the Start screen (Windows 8), or from the Start menu (Windows 7) that is displayed when you click at the left end of the Windows taskbar.You can either choose to create a database by using a predefined template database, or you can start by creating an empty database.In this exercise, you’ll create a desktop database.
For more information, see “Download the practice files” in this book’s Introduction.