Microsoft Access

Criteria is an particular data which we want to specify in our field to highlight it.

Thus we can say that criteria is used to specify a particular age, amount, working, department of peoples of different age whose age we can specify according to those age (less then or more then).

Some of the criteria you could have would be that you only want to show females, or people who live in a certain town, or people above a certain age, or people who work in a certain department or a product that has had sales over a certain amount. You decide what you want and then apply the criteria to the field or fields you want, in the criteria cell

The database is a collection of data on which we can perform operations such as:

1. Storing data (Save)

2. Manipulating data (Update, Delete, insert, sort)

3. Retrieve data (Whenever necessary, we can see the data in a particular table form, or use selected data, as in a computer program)

Typically a database is made up of many linked tables of rows and columns, each containing specific data (E.g. name, address, location, size, weight, dates).

Field: each column represents a field.

Record: each row represents one record.

Table: collection records.

Database is the collection of data . Or we should say that database is the collection of interrelated data.

Database A database is an organized collection of data, today typically in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies). The term database is correctly applied to the data and their supporting data structures, and not to the database management system (DBMS). The database data collection with DBMS is called adatabase system. The term database system implies that the data is managed to some level of quality (measured in terms of accuracy, availability, usability, and resilience) and this in turn often implies the use of a general-purpose database management system (DBMS).[1] A general-purpose DBMS is typically a complex software system that meets many usage requirements, and the databases that it maintains are often large and complex. The utilization of databases is now spread to such a wide degree that virtually every technology and product relies on databases and DBMSs for its development and commercialization, or even may have such embedded in it. Also, organizations and companies, from small to large, heavily depend on databases for their operations. Well known DBMSs include Oracle, IBM DB2, Microsoft SQL Server, PostgreSQL, MySQL, WebDNA and SQLite. A database is not generally portable across different DBMS, but different DBMSs caninter-operate to some degree by using standards like SQL and ODBC to support together a single application. A DBMS also needs to provide effective run-time execution to properly support (e.g., in terms of performance, availability, and security) as many end-users as needed. A way to classify databases involves the type of their contents, for example: bibliographic, document-text, statistical, or multimedia objects. Another way is by their application area, for example: accounting, music compositions, movies, banking, manufacturing, or insurance. The term database may be narrowed to specify particular aspects of organized collection of data and may refer to the logical database, to physical database as data content in computer data storageor to many other database sub-definitions. Graphics Graphics (from Greek γραφικός graphikos) are visual presentations on some surface, such as a wall, canvas, screen, paper, or stone to brand, inform, illustrate, or entertain. Examples arephotographs, drawings, Line Art, graphs, diagrams, typography, numbers, symbols, geometric designs, maps, engineering drawings, or other images. Graphics often combine text, illustration, andcolor. Graphic design may consist of the deliberate selection, creation, or arrangement of typography alone, as in a brochure, flier, poster, web site, or book without any other element. Clarity or effective communication may be the objective, association with other cultural elements may be sought, or merely, the creation of a distinctive style. Graphics can be functional or artistic. The latter can be a recorded version, such as a photograph, or an interpretation by a scientist to highlight essential features, or an artist, in which case the distinction with imaginary graphics may become blurred. Computer graphics Computer graphics are graphics created using computers and, more generally, the representation and manipulation of image data by a computer with help from specialized software and hardware. The development of computer graphics has made computers easier to interact with, and better for understanding and interpreting many types of data. Developments in computer graphics have had a profound impact on many types of media and have revolutionized animation, movies and the video gameindustry.]] and the video game industry.

A database is an electronic way of storing information so that it is easily accessible by searching more than one field.

Microsoft Access recognizes 10 data types.

1. Text - Short, alphanumeric values, such as a last name or a street address.

2. Number - Numeric values, such as distances. Note that there is a separate data type for currency.

3. Currency - Monetary values.

4. Date/Time - Dates and times.

5. Memo - Long blocks of text and text that use text formatting. A typical use of a Memo field would be a detailed product description.

6. Yes/No - Boolean values.

7. AutoNumber - Numbers that are automatically generated for each record.

8. Hyperlink - Hyperlinks, such as e-mail addresses.

9. OLE Object - OLE objects, such as Word documents.

10. Attachment - Files, such as digital photos. Multiple files can be attached per record. This data type is not available in earlier versions of Access.