a)Field name Data type
ID (Primary key) Auto Number
Make text
Date of manufacture Date/time
Colour Text
Cost Currency
b)Create a query to show same make and colour
c)Create a query. In the colour field, and in the Criteria row, write “green”
d) i)Create a query. In the cost field, and in the criteria row, write “.>500000
and <1000000”
ii)Create a query. Choose average of costs “Avg” option in the total section.
Kavungya answered the question on June 6, 2019 at 09:06
- Differentiate between Fill and stroke(Solved)
Differentiate between Fill and stroke
Date posted: June 6, 2019. Answers (1)
- Differentiate between Change case and drop cap.(Solved)
Differentiate between Change case and drop cap.
Date posted: June 6, 2019. Answers (1)
- Differentiate between Margins and column guides.(Solved)
Differentiate between Margins and column guides.
Date posted: June 6, 2019. Answers (1)
- Differentiate between pasteboard and printable page(Solved)
Differentiate between pasteboard and printable page.
Date posted: June 6, 2019. Answers (1)
- Why is layering very useful in a desktop publisher?(Solved)
Why is layering very useful in a desktop publisher?
Date posted: June 6, 2019. Answers (1)
- Name the two most common protocols for the Internet, and state their functions.(Solved)
Name the two most common protocols for the Internet, and state their functions.
Date posted: June 6, 2019. Answers (1)
- Mention two examples of email software.(Solved)
Mention two examples of email software.
Date posted: June 6, 2019. Answers (1)
- Briefly describe four factors contributing to Internet access and growth in Kenya.(Solved)
Briefly describe four factors contributing to Internet access and growth in Kenya.
Date posted: June 6, 2019. Answers (1)
- Differentiate between data security and data integrity.(Solved)
Differentiate between data security and data integrity.
Date posted: June 6, 2019. Answers (1)
- Computer systems need maximum security to prevent an unauthorized access. State six precautions that you would expect an organization to take to prevent illegal access...(Solved)
Computer systems need maximum security to prevent an unauthorized access. State six precautions that you would expect an organization to take to prevent illegal access to its computer-based systems.
Date posted: June 6, 2019. Answers (1)
- Give four rules that must be observed in order to keep within the law when working with data and information.(Solved)
Give four rules that must be observed in order to keep within the law when working with data and information.
Date posted: June 6, 2019. Answers (1)
- An individual has a right to demand guarantee to privacy of personal information stored on a computer. Give three such types of information.(Solved)
An individual has a right to demand guarantee to privacy of personal information stored on a computer. Give three such types of information.
Date posted: June 6, 2019. Answers (1)
- Clearly differentiate between data collection and data capture.(Solved)
Clearly differentiate between data collection and data capture.
Date posted: June 6, 2019. Answers (1)
- Name the examples of industries and business organizations that extensively use distributed processing systems.(Solved)
Name the examples of industries and business organizations that extensively use distributed processing systems.
Date posted: June 6, 2019. Answers (1)
- Explain the concept of multiprogramming(Solved)
Explain the concept of multiprogramming
Date posted: June 6, 2019. Answers (1)
- State at least four advantages of storing data in computer files over the manual filing system(Solved)
State at least four advantages of storing data in computer files over the manual filing system
Date posted: June 6, 2019. Answers (1)
- In a computer based information system, state the purpose of the computer files, and give one example where such a file may be required in...(Solved)
In a computer based information system, state the purpose of the computer files, and give one example where such a file may be required in a school.
Date posted: June 6, 2019. Answers (1)
- What are low-level languages? Give their features.(Solved)
What are low-level languages? Give their features.
Date posted: June 6, 2019. Answers (1)
- Examine two features of fourth generation languages (4GLS)(Solved)
Examine two features of fourth generation languages (4GLS)
Date posted: June 6, 2019. Answers (1)
- Describe 5 factors to be considered while choosing a programming language.(Solved)
Describe 5 factors to be considered while choosing a programming language.
Date posted: June 6, 2019. Answers (1)