Microsoft Access

Yes. Queries are often used to do calculations and can then produce a field. However anything that can be calculated from other fields should not go into a database table, which is why we use queries to get them. The queries just display them but do not add them into tables. There is no need to do so. From the perspective of users, they will see calculated data appearing on a form or in a query or in a report, as if the data was a field in a table.

No. A wpd extension is not one from Microsoft Access. It would be a word processing document.

A form is an object that allows you to input, edit, or view data from/in your database. Forms usually displays one record at a time and can be customized based on user preference.

One of the views a form has is Design View. It is used when designing the form, so it does not show the actual data. There is also a view called Form View, which shows the data.

the answer of course is Unique Values

It is a name given to a cell

AutoFormat

what is the individual data item in a record

Question doesnt make sense. There are tens of database types availible. Each using one or two drivers.

a query can output to a form and a report. The norm is a report

Absolutely ! Open Office is designed as 'open source' - which means it's perfectly legal to copy and re-distribute it. HOWEVER - you must not sell any copies. That is profiteering - which is not allowed.

AccessDBRunner is a software program addin for MS Access databases that users can build sophisticated run-step processing applications. It is used in corporate environments where hi-volume data processing is essential.

Ctrl and the plus key.

Basically a "query" is a way of asking the database a question, i.e.

How many people,

have a red car.

The query is set an can be a one off question or can be a question it is asked regularly.

The criteria is in effect the question you want answered i.e. how many people in you database have a red car So in the data base you may have the name, address, car type, car colour. In the colour field you would set the criteria as RED. Then running the query you will get all the cars that are red. If you then placed in the field on the database data about the type of car this could be Sports, saloon, hatchback SUV

So you can then ask red in the colour filed of the query and SUV for example in the TYPE field. It is the queries that make the database do its job of reporting back the information.

It is possible to do a simple calculation in a query without having any fields in it, but generally the whole point of queries is to work with data from tables, so there would be fields in them. If you wanted to do a calculation that did not involve any fields, then there would be no reason to use a database. You could use a spreadsheet or a calculator.

In files on your disk (like every other program does).

the space bar

Its a report. It can be screen based or hard copy (paperbased) you can also create a report which can be exported in other compatable applications

You could do each field individually. You could also select all of them and either drag them to adjust all of their widths at once or go to the properties and set a standard width for all fields.

Text String

They are stored on a hard drive or some other permanent storage device. The database application stores a table that identifies related files.

key

Datasheet view

The Validation Text in MS Access is the text that is shown when the conditions set by a Validation Rule are not met. In Access you can specify a Validation Text for each field in a table's Design View in the Field Properties panel.

A record is a row of Table in Microsoft Access. It contains information about a particular item stored in a table (book, student e.t.c)