CHAPTER 4 - ACCESS - QUERY AND REPORTS

 

CHAPTER 4: ACCESS – QUERIES AND REPORTS

 D. 1. Differentiate between Major Key and Minor Key

When we sort on more than one field the most important field is known as Major Key or Primary Sort Key while the less important field is known as minor key or secondary sort key

 E. Answer in 1-2 sentences

1.  What do you understand by query?

Query is a request for specific data from the database. The capability of querying a database is one of the most powerful database features

 2. What do you mean by compound criteria?

Compound criteria means applying more than one criterion to find the data we are searching.

 3. Why do we need sorting?

We need Sorting to arrange alphabetical/numeric data in ascending/descending order so that we can locate the required data quickly.

 4. What do you mean by report?

A report is a database object used to display data from a query or table in an appealing way.

 F. Answer briefly.

1. Explain the query window options.

The top pane of query window displays the tables selected for the query. The bottom pane displays a design grid where we can add fields to the query and also specify the criteria.

The query window options are Database Tables, Field list, View, Run, QBE grid, Field, Table, Sort, Show, Criteria and Or.

 2. What is the use of wildcards in query?

Wildcards are symbols that represent any character or combination of characters. The first wild card symbol is asterisk (*) which represents any collection of characters. The other wildcard symbol is the question mark (?) which represents any individual character.

 

Popular posts from this blog

CHAPTER 8: APP DEVELOPMENT

  CHAPTER 8: APP DEVELOPMENT D. Write the use of the following: 1. Educational Apps Educational apps make things easier for the children to study.   These apps can make teaching and exploring more interactive. Kids can learn while playing educational game apps. 2.  Communication Apps: Communication appsenable us to impart or interchange thoughts, opinions, or information by speaking, writing, or through signs. E. Differentiate between Native App and Web App Native apps are developed for a particular platform or device. Apps built for systems like iOS, Android, Windows phone, and Blackberry cannot be used on a platform other than their own. Web apps are actually websites that provide a user with experience similar to native apps. They are not deployed to an app store. Rather they are deployed to a web server and users access them in a webbrowser from any device with an Internet connection. F. 1. What do you mean by app? The term app is originally referr...
Read more

CHAPTER 5: OPENSHOT VIDEO EDITOR

  CHAPTER 5: OPENSHOT VIDEO EDITOR   D 1. Differentiate between the following: Real Movies and Animated Movies Real movies are made using real people and location. Camera is used to shoot these movies. Animation movies are made of a series of still images displayed in a quick sequence. The images used in these movies are either drawn by hand or generated on the computer. E. Answer in 1-2 sentences. 1. Name the different mediums to watch movies We can watch the movie via two mediums — cinema hall and online platform. 2. What is OpenShot? OpenShot is an open-source video editor software. We can easily combine multiple images, video clips and audio clips into a single file, and then export the combined video to many common video formats 3. What is Timeline in OpenShot? Timeline is used to look at the sequence or ordering of the clips in your project. It also shows video effects that have been added in the project. F. Answer briefly 1. Write steps to add audi...
Read more

CHAPTER 9: PYTHON – LOOPING AND TKINTER GUI

  CHAPTER 9: PYTHON – LOOPING AND TKINTER GUI   D. 1. Differentiate between WHILE - ELSE LOOP and FOR – ELSE LOOP When we use else with while loop this structure is known as while-else loop. Using this loop, we can run an instruction code when the comparing value reaches to exceed limit of condition value. When we use else with for loop, this structure is known as for-else loop. The else clause of a loop gets executed only if the loop completes its execution normally without having encountered with break statement.   2. Differentiate between RADIOBUTTON and CHECKBUTTON. Radiobutton is used to create one option out of many selections. The user is provided with multiple choices out of which only one can be selected. Checkbutton is used to create multi-selection check boxes. User can select one or multiple check boxes from the list.   E.1. What are loops and why are they important in Python? Loop causes a section of our program to be repeated a certain n...
Read more