Data entry clerks use online forms to enter data into databases. Explain how the use of an online form can make entering data easier for the clerks.

9626_s23_qp_33

THEORY

2023

Paper 3, Variant 3

View

Theresa has created a database query which searches for the surname “Johnson”. Surjit has told her that this is a static parameter query. Explain what is meant by static parameter query and why she should change to using a dynamic parameter query.

9626_m17_qp_12

THEORY

2017

Paper 1, Variant 2

View

When creating queries in a database, a function IIf() is often used. IIf is equivalent to the IF function found in spreadsheet software. Examine the following database query. IIf(>Date(),"not yet",IIf(=Date(),"today’s the day","you’ve missed it")) Date() returns the current date. is written as “Examdate” in some software. Describe, in detail, what the database query does.

9626_m21_qp_12

THEORY

2021

Paper 1, Variant 2

View

Ayesha is searching a school database for all the students studying biology. She has used a static parameter query but has been advised to set the query up as a dynamic parameter query. Describe what is meant by a dynamic parameter query and give the advantages of using one instead of a static parameter query.

9626_s20_qp_12

THEORY

2020

Paper 1, Variant 2

View

Amir has created a student database query which allows users to type in any name they choose and then the query finds everybody in the database with that name. Annisa has told him that this is a dynamic parameter query. Evaluate, by weighing up the advantages and disadvantages, dynamic parameter queries compared with static parameter queries. Please for Question 12.

9626_w20_qp_11

THEORY

2020

Paper 1, Variant 1

View

Amir has created a student database query which allows users to type in any name they choose and then the query finds everybody in the database with that name. Annisa has told him that this is a dynamic parameter query. Evaluate, by weighing up the advantages and disadvantages, dynamic parameter queries compared with static parameter queries. Please for Question 12.

9626_w20_qp_13

THEORY

2020

Paper 1, Variant 3

View

Compare static parameter queries with dynamic parameter queries. You must include similarities and differences.

9626_w23_qp_11

THEORY

2023

Paper 1, Variant 1

View

Some database systems use the indexed sequential method of accessing data. Describe the features of indexed sequential access and how it is used.

9626_s18_qp_13

THEORY

2018

Paper 1, Variant 3

View

Below is an excerpt from a database showing some holiday bookings. Egypt Malaysia Thailand Costa Rica Sri Lanka Bahamas Indonesia Indonesia Costa Rica Egypt Sri Lanka Egypt Thailand Costa Rica Costa Rica Indonesia Malaysia Thailand Sri Lanka Thailand Egypt Malaysia Indonesia Malaysia Bahamas Costa Rica Thailand Sri Lanka Thailand Thailand Egypt Egypt Country Group size Code Discount Duration EGY MAL THA COZ SRI BAH IND IND COZ EGY SRI EGY THA COZ COZ IND MAL THA SRI THA EGY MAL IND MAL BAH COZ THA SRI THA THA EGY EGY Describe the steps that need to be followed to set up a dynamic query to allow you to search on the Group size and Code fields. All fields are to be printed except Discount. You run the query and type in the Group size as 4 and the Code as EGY. Write down the Durations that will be printed out. The Duration field has only the values shown in the database excerpt. The database needs to be set up to allow you to enter the data in this field without using the keyboard to type in the value each time. Describe how this would be done and explain how you would now enter the data. When the database was initially set up it did not have the Country field. Data was exported to a spreadsheet and a formula created, using the Code field, to add the names of the countries with the layout exactly as shown in the database excerpt. Without specifying the formula precisely, explain how this could be achieved.

9626_s18_qp_11

THEORY

2018

Paper 1, Variant 1

View

Fig. 1 below shows a small extract from a school database. All students shown are in year groups 9, 10 or 11 depending on their year of birth. Each student’s year group, which is not part of the database, is shown in Fig. 2. student_ID student_name Marian Griffith Manjit Dupay Ho Chan Johan Schmidt Paul Dugarry Li Cho option _1 Geography Sociology History Geography History History option_2 Art Design Tech Spanish Art German Latin year of birth Fig. 1 Name year_group Marian Griffith Manjit Dupay Ho Chan Johan Schmidt Paul Dugarry Li Cho Fig. 2 The year_group field needs to be added to the database and will be a calculated field. Explain how you would set up the calculated year_group field. You have been asked to produce a well-formatted report showing the year 10 students studying History. The report will contain a list of these students showing only each student’s name, identity number and the total number of students involved. Explain how you would produce such a report.

9626_w17_qp_13

THEORY

2017

Paper 1, Variant 3

View

---