Microsoft Access

by clicking grey are on the left

Every field must have a name. They also must have a data type. For some field types, you also need to have a size, though a default size will be set for those fields.

It allows the user to apply a filter based on what is selected at that moment. Say you have a field that contains the marital status of people. If you were on a record where the person was married and you put the cursor into that field and applied a filter by selection, then only records for people that were married would show until the filter was removed. It is a very handy way of finding something to filter on, by using a standard value that is in a record already.

how to get the percentages to change amount of payment in each column

pre query

inner join

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.