Welcome, Guest |
You have to register before you can post on our site.
|
Online Users |
There are currently 695 online users. » 0 Member(s) | 693 Guest(s) Yandex, Bing
|
Latest Threads |
SELECT statement with MS ...
Forum: MS Access SQL Tutorials
Last Post: Qomplainerz
07-27-2023, 03:35 PM
» Replies: 0
» Views: 1,106
|
SELECT statement with the...
Forum: MS Access SQL Tutorials
Last Post: Qomplainerz
07-27-2023, 03:31 PM
» Replies: 0
» Views: 554
|
Creating hyperlinks in HT...
Forum: HTML5 Tutorials
Last Post: Qomplainerz
07-27-2023, 01:23 PM
» Replies: 0
» Views: 856
|
What's new in HTML5?
Forum: HTML5 Tutorials
Last Post: Qomplainerz
07-27-2023, 12:48 PM
» Replies: 0
» Views: 580
|
What is HTML5?
Forum: HTML5 Tutorials
Last Post: Qomplainerz
07-27-2023, 12:43 PM
» Replies: 0
» Views: 540
|
Neck isometric exercises
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:44 AM
» Replies: 0
» Views: 829
|
Shoulder shrug
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:43 AM
» Replies: 0
» Views: 494
|
Neck retraction
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:43 AM
» Replies: 0
» Views: 453
|
Neck flexion and extensio...
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:42 AM
» Replies: 0
» Views: 527
|
Neck rotation
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:42 AM
» Replies: 0
» Views: 497
|
|
|
SELECT statement with MS Access SQL |
Posted by: Qomplainerz - 07-27-2023, 03:35 PM - Forum: MS Access SQL Tutorials
- No Replies
|
|
Example:
SELECT employee_id, first_name, job_title
FROM employees
WHERE job_title = 'Manager';
Let's break down the SQL code:
SELECT: This keyword indicates that we want to retrieve data from the table.
employee_id, first_name, job_title: These are the columns we want to retrieve data from.
We specified three columns: "employee_id," "first_name," and "job_title."
FROM: This keyword indicates the table from which we want to retrieve data.
In this case, we want data from the "employees" table.
WHERE: This optional keyword is used for filtering the rows.
We can specify a condition to retrieve only those rows that satisfy the given condition.
job_title = 'Manager': This is the condition specified in the WHERE clause.
It means we only want to retrieve rows where the "job_title" column has the value "Manager."
When you run this SQL code as a query in Microsoft Access, it will return a result set containing the "employee_id," "first_name," and "job_title" columns for all employees who have the job title "Manager." The result will be displayed in the Datasheet View, showing only the relevant information based on the specified condition.
|
|
|
SELECT statement with the MS Access GUI |
Posted by: Qomplainerz - 07-27-2023, 03:31 PM - Forum: MS Access SQL Tutorials
- No Replies
|
|
Let's walk through an example of the SELECT statement step by step.
Suppose we have a table named "employees" in the Microsoft Access database with the following columns:
"employee_id," "first_name," "last_name," "job_title," and "salary."
Step 1: Connect to the Database
First, you need to open Microsoft Access and open the database that contains the "employees" table.
Step 2: Launch the Query Design View
To execute a SELECT statement, you can create a query in Access using the Query Design View.
Click on the "Create" tab in the top menu.
Click on "Query Design" in the "Queries" group.
Step 3: Add the Table to the Query Design View
In the Query Design View, you will see the "Show Table" dialog.
Add the "employees" table to the query design by double-clicking on it or selecting it and clicking the "Add" button.
Step 4: Select Columns to Retrieve Data
You will see the "employees" table added to the Query Design View with all its columns.
To specify which columns you want to retrieve, drag and drop them from the table grid to the query design area.
Let's say we want to retrieve the "employee_id," "first_name," and "job_title" columns:
Step 5: Specify the Criteria (Optional)
If you want to filter the results based on specific conditions, you can use the "Criteria" row in the query design grid.
For example, if you only want to retrieve employees with a certain job title (e.g., "Manager"), you can add the condition in the "Criteria" row for the "job_title" column:
Step 6: Run the Query
Once you have defined the SELECT statement in the Query Design View, click the "Run" button (it looks like a red exclamation mark) in the top menu to execute the query.
Step 7: View the Results
After running the query, you will see the results displayed in the Datasheet View.
The Datasheet View will show the selected columns from the "employees" table, filtered based on any conditions you specified.
That's it! You have successfully executed a SELECT statement in Microsoft Access to retrieve specific columns from the "employees" table, and optionally filtered the results based on certain criteria.
Remember, you can save the query for future use or modify it as needed.
SELECT statements are the foundation of data retrieval in SQL, allowing you to view specific information from the database tables.
|
|
|
Creating hyperlinks in HTML5 |
Posted by: Qomplainerz - 07-27-2023, 01:23 PM - Forum: HTML5 Tutorials
- No Replies
|
|
The a element in HTML is used to create hyperlinks, allowing you to link to other web pages, resources, files, or specific sections within a page.
Example:
Code: <!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Hyperlink Example</title>
</head>
<body>
<p>Welcome to my website! Check out <a href="https://openai.com">OpenAI</a>.</p>
</body>
</html>
Explanation:
Opening and Closing Tags:
The a element is an inline element and requires an opening a tag and a closing a tag to create a link.
The content between the opening and closing tags is what's displayed as the clickable link.
href Attribute:
The most crucial attribute of the a element is href, which specifies the destination URL or the target of the link.
In the example, href="https://openai.com" tells the browser to navigate to the OpenAI website when the link is clicked.
Link Text:
The content between the opening and closing a tags is known as the link text.
In our example, the link text is "OpenAI."
When the user clicks on this text, they will be redirected to the URL specified in the href attribute.
Absolute URL:
In the example, we used an absolute URL (https://openai.com) as the value for the href attribute.
This means the link will take the user directly to the OpenAI website.
Relative URL (optional):
Instead of an absolute URL, you can also use a relative URL for the href attribute.
A relative URL is relative to the current web page's location.
For example, if your current page is in the same directory as another page named about.html, you can use href="about.html" to create a link to the "about.html" page.
Linking to Files:
Besides web pages, you can use the a element to link to various resources like images, PDFs, videos, and more.
Just provide the correct URL to the file in the href attribute.
Linking to Sections within a Page (optional):
You can also link to specific sections within the same page by using the id attribute on an element and providing its value as the destination of the link. For example:
Code: <!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Internal Link Example</title>
</head>
<body>
<h2 id="section1">Section 1</h2>
<p>Welcome to Section 1. <a href="#section2">Jump to Section 2</a>.</p>
<h2 id="section2">Section 2</h2>
<p>Welcome to Section 2. <a href="#section1">Go back to Section 1</a>.</p>
</body>
</html>
In this example, we've created two sections with h2 headings, each having a unique id attribute.
The links within the paragraphs allow the user to jump back and forth between the sections within the same page.
Opening Links in a New Tab (optional): By default, when a user clicks on a link, the new content replaces the current page.
However, you can add the target="_blank" attribute to the a element to open the link in a new browser tab or window.
|
|
|
What's new in HTML5? |
Posted by: Qomplainerz - 07-27-2023, 12:48 PM - Forum: HTML5 Tutorials
- No Replies
|
|
1. Semantic elements:
HTML5 introduces many new semantic elements that help describe the structure of the content better, making it easier for search engines and screen readers to understand the page's purpose. Some key semantic elements include header, nav, main, article, section, footer, aside, etc.
2. Multimedia:
HTML5 provides built-in support for audio and video without the need for plugins like Flash.
The audio and video elements allow embedding media directly into the page.
Example:
Code: <audio controls>
<source src="audio.mp3" type="audio/mpeg">
Your browser does not support the audio element.
</audio>
Code: <video controls width="640" height="360">
<source src="video.mp4" type="video/mp4">
Your browser does not support the video element.
</video>
3. Form enhancements:
HTML5 enhances form handling with new input types, validation attributes, and the datalist element for autocomplete suggestions.
Example:
Code: <input type="email" required>
<input type="date">
<input type="range" min="0" max="100">
<input type="color">
<input type="search" list="search-suggestions">
<datalist id="search-suggestions">
<option value="Keyword 1">
<option value="Keyword 2">
</datalist>
4. Canvas:
The canvas element allows dynamic rendering of graphics, charts, animations, and games using JavaScript.
It provides a 2D drawing context and, with WebGL, can even support 3D graphics.
5. Offline web applications:
HTML5 includes an Application Cache feature that enables web applications to work offline and load faster by storing resources locally.
This is achieved using the manifest attribute in the html tag.
6. Geolocation:
HTML5 supports geolocation, allowing websites to access the user's location through the Geolocation API.
7. Web storage:
HTML5 introduces Web Storage (localStorage and sessionStorage) to store data locally on the user's browser for a more extended period compared to cookies.
8. Web workers:
Web Workers allow running JavaScript code in the background without interfering with the page's responsiveness, enabling multi-threading.
9. Drag and Drop:
HTML5 provides native support for drag-and-drop interactions, making it easier to implement intuitive UI elements.
|
|
|
What is HTML5? |
Posted by: Qomplainerz - 07-27-2023, 12:43 PM - Forum: HTML5 Tutorials
- No Replies
|
|
HTML5 (Hypertext Markup Language 5) is the latest version of the standard markup language used for creating and structuring content on the web.
It comes with several new features and improvements over its predecessors.
|
|
|
Neck isometric exercises |
Posted by: Qomplainerz - 07-27-2023, 11:44 AM - Forum: Exercises
- No Replies
|
|
Place your hand on your forehead.
Push your head forward against your hand while resisting with your hand.
Hold the tension for 5-10 seconds, then relax.
Repeat the isometric push in all directions: forward, backward (placing hand on the back of your head), and sideways (placing hand against the side of your head).
Repeat each direction 5-10 times.
|
|
|
Shoulder shrug |
Posted by: Qomplainerz - 07-27-2023, 11:43 AM - Forum: Exercises
- No Replies
|
|
Sit or stand with your back straight.
Slowly lift both shoulders towards your ears.
Hold for 5-10 seconds, then relax.
Repeat the shoulder shrug 10-15 times.
|
|
|
Neck retraction |
Posted by: Qomplainerz - 07-27-2023, 11:43 AM - Forum: Exercises
- No Replies
|
|
Sit or stand with your back straight.
Tuck your chin in towards your neck without tilting your head up or down.
Hold the position for 5-10 seconds.
Relax and repeat 5-10 times.
|
|
|
Neck flexion and extension |
Posted by: Qomplainerz - 07-27-2023, 11:42 AM - Forum: Exercises
- No Replies
|
|
Sit or stand with your back straight.
Slowly tilt your head forward, bringing your chin toward your chest (flexion).
Hold the stretch for 15-30 seconds.
Gently lift your head and look up towards the ceiling (extension).
Hold for 15-30 seconds.
Repeat the flexion and extension stretches 2-3 times each.
|
|
|
Neck rotation |
Posted by: Qomplainerz - 07-27-2023, 11:42 AM - Forum: Exercises
- No Replies
|
|
Sit or stand with your back straight.
Slowly turn your head to one side, looking over your shoulder.
Hold the stretch for 15-30 seconds.
Return to the starting position and repeat on the other side.
Perform this stretch 2-3 times on each side.
|
|
|
|