DATABASE OBJECTS : QUERY

DEFINE THE QUERY

A Query is database object that retrieves specific information from a database.

For example, you can retrieve a student’s name and address from the database.

With Access Queries, you can do the following :

• View specific data from Table.
• Perform calculations on selected records.
• Delete record from a table.

 

You can create new Queries using one of the methods.

• Create query in Design View.
• Create query by using wizard.

CREATING A RELATIONSHIP

You need to create the relationship between Tables before you can create Queries.

__________________________________________________________________________________
 Others Lesson : | click lesson to view |

• Database and DBMS
  
• Relationship Between Field And Record
  
• Primary And Foreign Key
  
• Relationship Between Primary and Foreign Key
  
• Database Object - Query
• Database Object - Form
• Database Object - Report
• Data Manipulation