Microsoft Office Tutorials and References
In Depth Information
Reviewing the Panorama Database
Read the Microsoft Access
Naming Conventions sec-
tion in the appendix titled
“Relational Databases and
Database Design” for more
information about naming
Sarah and her staff had no previous database experience when they created the Panorama
database using the wizards and other easy-to-use Access tools. As business continued to
grow at Belmont Landscapes, Sarah convinced Oren that they needed to hire a computer
expert to further enhance the Panorama database, and they hired Lucia Perez, who has a
business information systems degree and nine years of experience developing database
systems. Lucia spent a few days reviewing the Panorama database, and she decided to
implement simple naming standards for the objects and field names in the database to
make her future work easier.
Before implementing the enhancements for Sarah and Taylor, you’ll review the naming
changes Lucia made to the object and field names in the Panorama database.
To review the object naming standards in the Panorama database:
1. Make sure you have created your copy of the Access Data Files, and that your com-
puter can access them.
Trouble? If you don’t have the Access Data Files, you need to get them before you
can proceed. Your instructor will either give you the Data Files or ask you to obtain
them from a specified location (such as a network drive). In either case, make a
backup copy of the Data Files before you start so that you will have the original
files available in case you need to start over. If you have any questions about the
Data Files, see your instructor or technical support person for assistance.
2. Start Access, and then open the Panorama database in the Level.02\Tutorial folder
provided with your Data Files.
Trouble? If the Security Warning is displayed below the Ribbon, click the Options
button next to the Security Warning. In the dialog box that opens, click the
“Enable this content” option button, and then click the OK button.
The Navigation Pane displays the objects grouped by object type, as shown in Figure 5-1.
Lucia added prefix tags to the object names—a tbl prefix tag for tables, a qry prefix tag
for queries, a frm prefix tag for forms, and a rpt prefix tag for reports. Using object prefix
tags, you can readily identify the object type, even when the objects have the same base
name—for instance, tblContract, frmContract, and rptContract. In addition, Lucia
removed spaces from the object names based on her experience with other database
management systems, such as SQL Server and Oracle, that do not permit spaces in
object and field names. If Belmont Landscapes needs to upscale to one of these other
database management systems in the future, Lucia will have to do less work to make the