This heading explains the working of tasks or instructions that you have just completed.

You will also find some other learning aids in the book, including:

These are short multiple-choice questions intended to help you test your own understanding.

These practical challenges give you ideas for experimenting with what you have learned.

You will also find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: “We made a copy of the report 05_Adding_Groups.prpt and saved it with the name 15_Adding_Hyperlinks_Sparklines.prpt.”

A block of code is set as follows:

SELECT country.country_id, country.country, customer.first_name, customer.last_name, SUM(payment.amount) sum_amount, payment.customer_id
FROM payment 
INNER JOIN customer ON customer.customer_id=payment.customer_id
INNER JOIN address ON address.address_id=customer.address_id
INNER JOIN city ON city.city_id=address.city_id
INNER JOIN country ON country.country_id=city.country_id
WHERE country.country_id IN (20,24,29,34,48,67,74)
GROUP BY payment.customer_id
ORDER BY country.country, customer.first_name

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

SELECT country.country_id, country.country, customer.first_name, customer.last_name, SUM(payment.amount) sum_amount, payment.customer_id
FROM payment 
INNER JOIN customer ON customer.customer_id=payment.customer_id
INNER JOIN address ON address.address_id=customer.address_id
INNER JOIN city ON city.city_id=address.city_id
INNER JOIN country ON country.country_id=city.country_id
WHERE country.country_id IN (20,24,29,34,48,67,74)
GROUP BY payment.customer_id
ORDER BY country.country, customer.first_name

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: “On the Select Destination Location screen, click on Next to accept the default destination.”.