Maths
Tricks with Numbers
|
|
||
The main intention of this site to provide Engineering information and preparing Engineering students for leadership in their fields in a caring and challenging learning environment.
Monday, 14 October 2013
Maths Tricks with Numbers
Primary information about DATABASE
DATA BASE
It is an
organized list of data (information) that can be queried to find information
quickly and easily based on a chosen reference point such as a last name or a
social security number.
Access is a
RDBMS that you can use to store and manipulate large amounts of information.
A Relational
Database is a database, which consists of Tables of related information that
are linked together based on a key field.
ELEMENTS OF ACCESSES
An
access is an object-oriented program. It has the following objects.
1.Database
Window
2.Tables
3.Queries
4.Forms
5.Reports
6.Macros
7.Modules
|
Data
Type
|
Description
|
|
Text
|
It can store 255 alphanumeric characters, used for storing data
|
|
Memo
|
It can hold up to 64,000 characters
|
|
Number
|
It is used for calculations, can consist of numerical digits
|
|
Date/ Time
|
Stores a date or time. Consists of 8 bits
|
|
Currency
|
It is used for monitory values. Consists of 8 bytes.
|
|
Counter
|
It is numeric value that automatically increment for each record
|
|
Yes/ No
|
Stores Boolean values
|
|
OLE Object
|
Stores pictures, graphs and
other binary data. Can consists of 128 MB
|
DATA VALIDATION
It helps to reduce the number of
data entry errors, which occur when a large amount of data is being entered
into a database. Access provides a basic level of data validation with the
validation rule property for each field. Assuming that only local phone numbers
will be entered in the field, the first step is to limit the field size to
seven digits. Position the cursor in the filed size panel, and replace the
field size of 50 characters with 7 characters.
Uses of MS- Accesses
It is a Relational Database. It
helps us to collect information in tables. i.e. collection of rows and columns.
Then we can sort it, print it or scroll through. It allows us to create forms
in user-defined fashion. Apart from forms, reports are created which can
include subtotals, averages, and some other computations. If we need to view
data directly or depending on some condition also, queries is applied.
Queries
Ø
By using queries we can view, change and analyze
data in different ways. You can also use them as the source of records for
forms and reports.
Ø
You can bring together data form multiple tables
and sort it in a particular order.
Ø
You can perform calculations on groups of records
Ø
You can calculate a sum, count, or another type
of total and then group the results by two types of information – one down the
left side of the datasheet and another across the top.
The query window is divided in to
two halves. The top panel contains the list of all the fields in a table and in
the bottom panel the criteria for the query are entered this panel is called
the design grid. This design grid having 5 rows.
|
Field
|
Specifies the fields to be included in the
query
|
|
Table
|
Specifies which table does the above field
belong to.
|
|
Sort
|
Specifies the manner in which the query has
to be sorted.
|
|
Show
|
Specifies whether to display the field or
not
|
|
Criteria
|
Specifies the criteria of the records to be
shown.
|
PRIMARY KEY
Ø
It is the field, which identifies a record. The entry done into this field is unique. It
cannot be same for the two records.
Ø Primary
field of one table appearing as a normal field in some another table is called
a Foreign Key Field. If there is a entry in the Foreign key field then there
has to exist a corresponding entry in
the primary key field.
LOGICAL OPERATORS
Ø
Logical and Logical OR operators
Ø
The AND operator is used when two criteria’s
have to be entered into a single field. It returns the result only when the
single field satisfies both the condition.
Ø
The OR operator is sued for matching any of the
values specified in the criteria. It returns the result even if the single
field satisfied any one of the criteria.
RELATIONSHIPS IN DATABASE
In MS- Accesses Database, there are
3 types of Relations
1.One to One Relationship
2.Many to One Relationship of One to Many Relationships
3.Many to Many Relationships
FORMS
Ø
In a table, numbers of records are displayed at
a time. But if the table has many fields then it may not be possible for a user
to view all of them. The screen may be too small to fit it. The user may have
to scroll horizontally or vertically to view the rest of the fields / Records.
Ø
In forms the data can be displayed as per the
users requirement. The records are generally displayed one at a time. The
fields can be arranged as the user wants it. Pictures can be added to a form.
The display and contents of the form is controlled fully by the user.
FORMS - 2
In forms there are three views
1.
Design
2.
Data Sheet
3.
Form
The data sheet
view shows many records whereas form view displays single record. You can
toggle between these three views using the View Tool.
Type of the Forms
1.The
design view
2.Form wizard
3.Auto form columnar
4.Auto form tabular
5.Auto form data
sheet
6.Chart wizard
7.Pivot table wizard
REPORT
The data shown in table, Query and forms are meant for
displaying it on screen, but when you take out the printouts or the Hard copy
it is known as Reports. In the database window the open button is replaced by the
preview button, when you click the report tab. Reports can be viewed either in
print preview mode or design mode. Data cannot be edited in the reports. The
reports preview shows how the data will appear on taking out the printouts.
Thursday, 10 October 2013
How to control mouse arrows on desktop by using JAVA programs.....??????
With this simple tutorial I will show you how to use the Robot Class in Java to control your computers mouse.
We can change the position of the cursor, left and right click, move the mouse wheel and click the mouse wheel.
For these examples you will need to make sure you import the java.awt.Robot &java.awt.event.InputEvent classes.
java code 1:
Move the mouse cursor position on screen:
We can change the position of the cursor, left and right click, move the mouse wheel and click the mouse wheel.
For these examples you will need to make sure you import the java.awt.Robot &java.awt.event.InputEvent classes.
java code 1:
Move the mouse cursor position on screen:
import java.awt.Robot; public class MouseClass { public static void main(String[] args) throws Exception { Robot robot = new Robot(); // SET THE MOUSE X Y POSITION robot.mouseMove(300, 550); } }
java code 2:Click the left mouse button:import java.awt.Robot; import java.awt.event.InputEvent; public class MouseClass { public static void main(String[] args) throws Exception { Robot robot = new Robot(); // LEFT CLICK robot.mousePress(InputEvent.BUTTON1_MASK); robot.mouseRelease(InputEvent.BUTTON1_MASK); } }java code 3:Click the right mouse button:import java.awt.Robot; import java.awt.event.InputEvent; public class MouseClass { public static void main(String[] args) throws Exception { Robot robot = new Robot(); // RIGHT CLICK robot.mousePress(InputEvent.BUTTON3_MASK); robot.mouseRelease(InputEvent.BUTTON3_MASK); } }java code 4:Click & scroll the mouse wheel:import java.awt.Robot; import java.awt.event.InputEvent; public class MouseClass { public static void main(String[] args) throws Exception { Robot robot = new Robot(); // MIDDLE WHEEL CLICK robot.mousePress(InputEvent.BUTTON3_DOWN_MASK); robot.mouseRelease(InputEvent.BUTTON3_DOWN_MASK); // SCROLL THE MOUSE WHEEL robot.mouseWheel(-100); } }
Poverty Around The World........................!!!!!!!!
Third World countries are often described as “developing” while the First World, industrialized nations are often “developed”. What does it mean to describe a nation as “developing”? A lack of material wealth does not necessarily mean that one is deprived. A strong economy in a developed nation doesn’t mean much when a significant percentage (even a majority) of the population is struggling to survive.
Successful development can imply many things, such as (though not limited to):
Yet, for a variety of reasons, these “full rights” are not available in many segments of various societies from the richest to the poorest. When political agendas deprive these possibilities in some nations, how can a nation develop? Is this progress?
Politics have led to dire conditions in many poorer nations. In many cases, international political interests have led to a diversion of available resources from domestic needs to western markets. (See the structural adjustmentsection to find out more about this.) This has resulted in a lack of basic access to food, water, health, education and other important social services. This is a major obstacle to equitable development.
Successful development can imply many things, such as (though not limited to):
- An improvement in living standards and access to all basic needs such that a person has enough food, water, shelter, clothing, health, education, etc;
- A stable political, social and economic environment, with associated political, social and economic freedoms, such as (though not limited to) equitable ownership of land and property;
- The ability to make free and informed choices that are not coerced;
- Be able to participate in a democratic environment with the ability to have a say in one’s own future;
- To have the full potential for what the United Nations calls Human Development:
Human development is about much more than the rise or fall of national incomes. It is about creating an environment in which people can develop their full potential and lead productive, creative lives in accord with their needs and interests. People are the real wealth of nations. Development is thus about expanding the choices people have to lead lives that they value. And it is thus about much more than economic growth, which is only a means—if a very important one—of enlarging people’s choices.
— What is Human Development?, Human Development Reports, United Nations Development Program
Yet, for a variety of reasons, these “full rights” are not available in many segments of various societies from the richest to the poorest. When political agendas deprive these possibilities in some nations, how can a nation develop? Is this progress?
Politics have led to dire conditions in many poorer nations. In many cases, international political interests have led to a diversion of available resources from domestic needs to western markets. (See the structural adjustmentsection to find out more about this.) This has resulted in a lack of basic access to food, water, health, education and other important social services. This is a major obstacle to equitable development.
Subscribe to:
Posts
(
Atom
)
