Notes, summaries, assignments, exams, and exercises for Technology for Baccalaureate

Topic 1. Test

• Test=prueba
• Broad=amplia
• Assess=evaluar
• Manufacture=fabricar
• Power transmission=transmisión de potencia
• Improve=mejorar

E1: Hi, I’m Ian Moore. I’m here for an interview.

E2: It’s nice to meet you, Ian. Tell me about your work experience.

E1: Well, I worked for Escribano for twelve years.

E2: What were your job duties?

E1: I assessed old engine models. Then I made suggestions to improve them.

E2: Did you design any engines?

E1: Not on my own. I designed new parts for older models.

E2: If we hire you, you’ll design new ones as well.

Topic 2. Bearings / Cojinetes

• Ball bearing=rodamiento de bolas
• Thrust roller bearing=rodamiento de rodillos de empuje
• Tapered roller bearing=rodamiento de rodillos cónicos
• Straight roller bearing=rodamiento de

Important Oracle SQL Data Dictionary Views

Important Oracle SQL tablespaces views include: dba_tablespaces, dba_data_files, dba_tables, user_types, user_source.

Creating Complex Object Types

CREATE OR REPLACE TYPE direccion AS OBJECT(
    calle VARCHAR2(50),
    numero NUMBER(3),
    piso NUMBER(2),
    puerto VARCHAR2(1),
    codpostal NUMBER(5),
    localidad VARCHAR2(50),
    provincia VARCHAR2(50)
);

CREATE OR REPLACE TYPE persona AS OBJECT(
    dni VARCHAR2(9),
    nombre VARCHAR2(50),
    apellido1 VARCHAR2(50),
    apellido2 VARCHAR2(50),
    telefono NUMBER(9),
    fecha_nac DATE,
    direccion direccion
);

Creating Tables Using Object Types

CREATE TABLE agenda OF persona;

DESC agenda; -- Visualize table structure


CREATE TABLE agenda2

Search Query Context

The original search query may have intended to find information related to inserting a text box, potentially in the context of creating a crib (cheat sheet). The suggested search term was: crib insert text box.

Relevant Search Results

1. Add or Delete a Text Box in PowerPoint (Office.com)

   office.microsoft.com/en.../add-or-delete-a-text-box-HA010230259.aspx

   Instructions and videos detailing how to add and delete text boxes in Word, Outlook, PowerPoint, and Excel 2007.

2. Add, Copy, or Delete a Text Box in Word (Office.com)

   office.microsoft.com/.../add-copy-or-delete-a-text-box-HA010354856.as...

   Instructions and videos to add, copy, or delete text boxes in Excel, Outlook, PowerPoint, or Word 2010.

3. Text Compressor - Free Source Code and

Controls and Calculated Fields

What Are Calculated Controls?

Calculated controls display results derived from calculations, which are vital for reports or forms. For example, if you own a toy company and need to determine the total sales amount generated by a product line, you can multiply the amount of toys sold by the price and display the total in a report or form.

Types of Expressions Used in Controls

Understanding Dependent Controls

A...

Mastering Microsoft Access Field Creation

Methods for Creating Fields in Access

There are two primary ways to create a field in Microsoft Access:

1. Adding fields using a predefined template.
2. Using an existing field copied from another table.

Access Field Templates Collection

Access includes a collection of field templates designed to significantly reduce the time required when setting up new fields.

Understanding Multi-Valued Fields in Access 2007

Multi-valued fields are suitable for specific scenarios, particularly when using Office Access 2007 to interact with information stored in Microsoft Windows SharePoint Services.

Defining Field Properties in Datasheet View

Field properties can be defined in the Datasheet View. Follow these steps:

1. Open the table

Windows Storage Unit Maintenance Tools

Windows provides three primary tools for maintaining storage units:

• Error Checking (Check Disk)
• Defragmentation (Disk Optimizer)
• Security Copy (Backup)

Error Checking Utility

This utility scans and repairs potential disk shortcomings. It can perform two types of tests:

• Logical Level: Checks for cross-linked errors in object names and file structure.
• Physical Level: Identifies and attempts to repair bad sectors.

Defragmentation Utility

This utility reorganizes the data on the disk, moving information so that all data belonging to a single file is stored in contiguous sectors. This improves access speed and overall disk performance.

Security Copy (Backup)

This utility allows users to create backups of information for...

Machining Processes and Machine Tools

In this type of machining, the machine is anchored in a fixed location while the workpiece moves toward the tool to be machined.

Common Machine Tools

Drilling

Drilling allows for the execution of round holes in both metal and non-metal materials. It utilizes a tool called a drill bit, which removes material in the form of chips as it rotates and advances.

• Setting the piece: The center of the hole should be positioned directly below the drill point. To secure the piece to the table, use fixing blocks with locking pliers or clamps.
• Determining revolutions: Before starting, it is necessary to set the required number of revolutions (RPM).

Lathe

A machine tool used to produce parts of revolution, which are components...

Lathe Operations

• Conical: To create a cone on a lathe, the most common method is matching the slope of the generatrix with the direction of the saddle.
• Thread: This involves the precise timing of cutting and forward movement. This coordination allows the tool to describe a helix on the surface of the workpiece, moving one thread pitch per rotation.
• Knurling: Used to generate rough surfaces for improved grip.

Router Machine

The router is a highly versatile machine tool capable of performing numerous operations. It utilizes a multi-point cutting tool, known as a milling cutter, mounted on a rotating shaft that provides the cutting motion while the workpiece remains fixed on a table.

Router Components

• Bed: Constructed from cast iron or heavy welded steel

Surgical Wound Care Principles

Surgical wounds are typically managed under clean and aseptic conditions. In contrast, other wounds, such as those resulting from firearms or animal bites, are considered "dirty wounds" due to a higher risk of contamination.

Objectives of Wound Management

• Remove or prevent bleeding.
• Encourage wound healing (cicatrization).
• Prevent infection.
• Promote the drainage of secretions.

Wound Care Methods

Open Method:

No dressings are used. Only cleaning and asepsis of the wound are performed, leaving it exposed to dry.

Closed Method:

Aseptic cleaning of the wound is performed, and dressings are applied and secured.

Essential Elements for Wound Care

• For Cleaning and Asepsis: Saline solution, sterile water or sterile soap solution, gauze