Discuss the advantage of creating a multitable query.

What will be an ideal response?


Multitable queries contain two or more tables and enable you to take advantage of the relationships that have been established in your database. When you extract information from a database with a query, often you will need to pull data from multiple tables. One table may contain the core information that you want, while another table may contain the related data that make the query provide the complete results. The advantage is that data can be stored in separate tables but pulled together to create meaningful information.

Computer Science & Information Technology

You might also like to view...

Answer the following statements true (T) or false (F)

1. The last form created for a Windows Forms application is designated as the startup form. 2. Any form in a Windows Forms application can be designated as the startup form. 3. Once you create a form, you do not have to re-create it to use it in another project.

Computer Science & Information Technology

Which of the following is a requirement for supporting the Aero user interface?

A. at least 128 KB video memory B. DirectX 9 or higher C. an HDMI video port D. Windows XP with SP3

Computer Science & Information Technology

Which of the following is the keyboard shortcut for Print Preview?

a. F2 b. Ctrl + F2 c. Ctrl + F4 d. F4

Computer Science & Information Technology

Critical Thinking QuestionsCase 2-1You are planning a new presentation on marketing that you will deliver to your Intro to Business class. To make certain your presentation's design is both interesting and effective, your planning checklist contains all of the following elements except _____. a. use graphics suitable for a multicultural audiencec. do not overuse WordArtb. give careful thought to slide textd. download photos and clips from the Web sites of major companies to use as examples

What will be an ideal response?

Computer Science & Information Technology