Computing

Look at the database above and answer the following questions

1. State the number of fields shown above.
2. State the number of records shown above.
3. List suitable field types for all fields in the database.
4. A new patient called Elaine Johnstone joins the dental practice. What must the dentist do with the personal information Elaine Johnstone gives her?
5. Describe how the dentist can find out which patients live in the town of Lomond.

Look at the database above and answer the following questions

1. State the number of fields shown above.
2. State the number of records shown above.
3. List suitable field types for all fields in the database.
4. A new patient called Elaine Johnstone joins the dental practice. What must the dentist do with the personal information Elaine Johnstone gives her?
5. Describe how the dentist can find out which patients live in the town of Lomond.

Basic Mail Merge steps as shown today. Remember, a more detailed set of instructions can be found on the school network….My Computer/Pupil Files/Computing and Info Sys/SG Comp/GPP/Databases

• Carry out Database search
• Select file and then export records
• Create a save file. Make sure .mer is file type.
• Select the fields that you need and then click on export.
• In your letter ensure the Mail Merge toolbar is visible.
• Select “Open Data Source”
• Navigate to find your .mer file you saved earlier.
• Select “insert fields” and place merge fields in place of placeholders.
• Once complete select “View Merged Data” and print the letters.

A quick recap on the database search techniques we discussed last week….

< less than
> greater than
<= less than OR equal to
>= greater than OR equal to
<> not equal to

To carry out a range search for dates etc you could enter something like 01/07/2011..31/07/2011. This would search for appointments in the month of July.

“simple search” = Searching on one field

“complex search” = searching on two or more fields