Time for action – heading

1. Action 1
2. Action 2
3. Action 3

Instructions often need some extra explanation so that they make sense, so they are followed with:

What just happened?

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:

Pop quiz – heading

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

Have a go hero – heading

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.”.

Note

Warnings or important notes appear in a box like this.

Tip

Tips and tricks appear like this.