Get premium membership and access questions with answers, video lessons as well as revision papers.
A Select query is a query that asks a question about the data stored in your tables and returns a result set in the form of a datasheet—without changing the data.
An action query is a query that copies or makes changes to or moves many records in just one operation.
marto answered the question on September 26, 2019 at 06:07
- A concert was organized in a hall with a capacity of 1500 people. The first 700 people to buy the tickets at ksh. 1500 were...(Solved)
A concert was organized in a hall with a capacity of 1500 people. The first 700 people to buy the tickets at ksh. 1500 were reserved a seat at the VIP section while the others who bought their tickets at ksh. 1000 sat at normal hall outside the VIP section. Assuming that only 1420 tickets were sold;
i) Write a program pseudocode that would be used to determine the sitting arrangements of ticket holders i.e VIP or Normal, the number of VIP, Normal and Unoccupied seats and finally dispay the total amount of money collected from the concert
ii) Draw a flowchart for the pseudocode above
Date posted: September 26, 2019. Answers (1)
- A company in town wishes to link its offices together; the linking may be through wireless or fibre optic network media
State two benefits that the...(Solved)
A company in town wishes to link its offices together; the linking may be through wireless or fibre optic network media
State two benefits that the company would gain from the use of metropolitan area network (MAN)
Date posted: September 26, 2019. Answers (1)
- State three ways in which computer virus infection can be prevented other than through restricting the usage of removable storage media.(Solved)
State three ways in which computer virus infection can be prevented other than through restricting the usage of removable storage media.
Date posted: September 26, 2019. Answers (1)
- With the aid of a diagram describe the Hierarchical Database Model.(Solved)
With the aid of a diagram describe the Hierarchical Database Model.
Date posted: September 26, 2019. Answers (1)
- State two transmission media used in wireless transmission.(Solved)
State two transmission media used in wireless transmission.
Date posted: September 26, 2019. Answers (1)
- State any two techniques used by a network administrator to detect and prevent computer crimes.(Solved)
State any two techniques used by a network administrator to detect and prevent computer crimes.
Date posted: September 26, 2019. Answers (1)
- State the use of each of the following flowchart symbols.(Solved)
State the use of each of the following flowchart symbols.
Date posted: September 26, 2019. Answers (1)
- List any three protocols used in sending and receiving of emails.(Solved)
List any three protocols used in sending and receiving of emails.
Date posted: September 26, 2019. Answers (1)
- Name three types of graphics used in a word processor.(Solved)
Name three types of graphics used in a word processor.
Date posted: September 26, 2019. Answers (1)
- List three examples of Data Communication Equipment.(Solved)
List three examples of Data Communication Equipment.
Date posted: September 26, 2019. Answers (1)
- What is meant by Data Communication Equipment (DCE)?(Solved)
What is meant by Data Communication Equipment (DCE)?
Date posted: September 26, 2019. Answers (1)
- Briefly describe the two types of spreadsheets.(Solved)
Briefly describe the two types of spreadsheets.
Date posted: September 18, 2019. Answers (1)
- List two duties performed by each of the following personnel.
(i). Database administrator
(ii). Computer trainer(Solved)
List two duties performed by each of the following personnel.
(i). Database administrator
(ii). Computer trainer
Date posted: September 18, 2019. Answers (1)
- Name any two computer related courses that are offered at public universities in Kenya.(Solved)
Name any two computer related courses that are offered at public universities in Kenya.
Date posted: September 18, 2019. Answers (1)
- Robots are introduced in a factory which makes car engines. Mention three ways this could affect the workers.(Solved)
Robots are introduced in a factory which makes car engines. Mention three ways this could affect the workers.
Date posted: September 18, 2019. Answers (1)
- Convert each of the following numbers:
i. 110.1012 to decimal
ii. 12.687510 to binary
iii. Subtract 110.012 from 11001.01012
iv.Using seven-bit twos compliment, perform the following binary arithmetic leaving...(Solved)
Convert each of the following numbers:
i. 110.1012 to decimal
ii. 12.687510 to binary
iii. Subtract 110.012 from 11001.01012
iv.Using seven-bit twos compliment, perform the following binary arithmetic leaving the answer in binary notation. 11012 - 1001012
Date posted: September 18, 2019. Answers (1)
- Study the flowchart below and answer the questions that follow.(Solved)
Study the flowchart below and answer the questions that follow.
(i) State the main type of control structure used in the flowchart.
(ii). Dry run the flowchart and give the expected output.
(iii) What will be the value of product when printed in the following flow chart? Show how you arrive at your answer.
(b). Explain what happens when the expression A = A+1 is changed to A = A-1
c) Give two benefits of structured programming.
Date posted: September 18, 2019. Answers (1)
- Anne was working on her computer studies project. She was worried of the media to use for storing her data.She settled on a media that...(Solved)
Anne was working on her computer studies project. She was worried of the media to use for storing her data.She settled on a media that used serial file organization.
a) How are files organized on a storage medium using this method?
b) List two advantages offered by this type of file organization
Date posted: September 18, 2019. Answers (1)
- Solve 100112-01012(Solved)
Solve 100112−01012
Date posted: August 20, 2019. Answers (1)
- The tables below shows the human resources system in a particular company.(Solved)
The tables below shows the human resources system in a particular company.
The table below shows the tax calculation based on income.
(a) (i) Create he two tables for the database and save the database as Human resource.
(ii) Create relationship between the two tables.
(iii) Insert the data above in the two tables format the salary field to Ksh.
(b) (i) Create a query with all fields in the employee table and a calculated field giving the years of service of the employee (save the query as length of service).
(ii) Create a query based on employee table for the employees employed between two dates (Save the query as between dates).
(iii) Create a query based on the table employee and department add a calculated field tax
and net salary Depending on the income bracket of the employee.(save the query as
payslip.
(c) (i) Create a report based on the query payslip.
(ii) Create a report of employee based on the query length of service.
Date posted: August 20, 2019. Answers (1)