JSS3: COMPUTER STUDIES - 1ST TERM
-
Computer Career Opportunities | Week 15 Topics|1 Quiz
-
Computer Viruses I | Week 27 Topics|1 Quiz
-
Computer Viruses II | Week 37 Topics|1 Quiz
-
Introduction To The Internet | Week 44 Topics|1 Quiz
-
Internet Terminologies | Week 54 Topics|1 Quiz
-
The Concept of Digital Divide | Week 65 Topics|1 Quiz
-
Database Concept, Definition And Terminologies | Week 74 Topics|1 Quiz
-
Database II | Week 83 Topics|1 Quiz
-
Database III | Week 913 Topics|1 Quiz
-
Microsoft Access
-
Opening And Locating Ms-Access
-
Database Objects
-
How To Close A Database And Exit Ms - Access
-
Creating a Database
-
How To Create a Blank Database
-
Database Sheet In Database
-
Saving a Table In Ms Access
-
Setting Data Types In Access
-
Sorting, Filtering, and Creating Relationships In Access
-
Creating Queries In Ms-Access
-
Creating Forms In Access
-
Views In Microsoft Access
-
Microsoft Access
Creating Queries In Ms-Access
Topic Content:
- Creating Queries In Ms-Access
- How To Open Tables Or Queries In Query Design View
- Steps In Opening Queries In Query Design View
You can use a query to view a subset of your data or to answer questions about your data. For example, if you want to view a list of students’ names and email addresses, but you do not want to see addresses and other data, you can create a query that displays the student’s first name, last name, and email address only. On the other way round, if you want to know which students live in Osun, you can restrict your list to those students.
How To Open Tables Or Queries In Query Design View:
A query can be based on tables or on other queries. To create a query, you open the tables or queries on which you are going to base your query in Query Design view and then use the options in Design view to create your query. You then click the Run button to display the results. You can save queries for later use.
Steps In Opening Queries In Query Design View:
1. Activate the Create tab
2. Click the Query Design button in the Other group. The Show Table dialogue box appears.
3. Activate the Tables tab if you want to base your query on tables, activate the Queries tab if you want to base your query on queries, or activate both tabs if you want to base your query on both tables and queries.
4. Click to choose the table or query on which you want to base your query.
5. Click Add. The table appears in the window.
(a)Click to choose the next table or query on which you want to base your query.
(b) Continue clicking tables or queries until you have all the tables and queries you plan to use.
6. Click Close. Access changes to Query Design view.
