Welcome, Guest
You have to register before you can post on our site.

Username/Email:
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 52
» Latest member: bernardwoods
» Forum threads: 4,492
» Forum posts: 4,495

Full Statistics

Online Users
There are currently 6332 online users.
» 0 Member(s) | 6329 Guest(s)
Yandex, Bing, Google

Latest Threads
SELECT statement with MS ...
Forum: MS Access SQL Tutorials
Last Post: Qomplainerz
07-27-2023, 03:35 PM
» Replies: 0
» Views: 527
SELECT statement with the...
Forum: MS Access SQL Tutorials
Last Post: Qomplainerz
07-27-2023, 03:31 PM
» Replies: 0
» Views: 326
Creating hyperlinks in HT...
Forum: HTML5 Tutorials
Last Post: Qomplainerz
07-27-2023, 01:23 PM
» Replies: 0
» Views: 382
What's new in HTML5?
Forum: HTML5 Tutorials
Last Post: Qomplainerz
07-27-2023, 12:48 PM
» Replies: 0
» Views: 327
What is HTML5?
Forum: HTML5 Tutorials
Last Post: Qomplainerz
07-27-2023, 12:43 PM
» Replies: 0
» Views: 312
Neck isometric exercises
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:44 AM
» Replies: 0
» Views: 316
Shoulder shrug
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:43 AM
» Replies: 0
» Views: 298
Neck retraction
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:43 AM
» Replies: 0
» Views: 270
Neck flexion and extensio...
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:42 AM
» Replies: 0
» Views: 293
Neck rotation
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:42 AM
» Replies: 0
» Views: 278

 
  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.

Print this item

  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.

Print this item

  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.

Print this item

  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.

Print this item

  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.

Print this item

  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.

Print this item

  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.

Print this item

  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.

Print this item

  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.

Print this item

  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.

Print this item