Microsoft Access

I'm actually not familiar with Access, but I'll try to help. Usually the primary key will physically order the rows in a database table. In SQL-query you can use "order by" clause. The default order is usually ascending. You can also add "asc" or "desc" after the column name.

Please do notice, primary keys are not for ordering rows. You should really let the database decide how to save the rows. You should always order the rows in your query (if needed), not modify or trust the physical order!

select col1

from foo

order by col2

select col1

from foo

order by col2 desc, col3 asc

To create a drop-down field on a table in Access, you can do this:

1. Open the table in design view.

2. If you haven't already, create the field and specify its characteristics on the 'General' tab(i.e. data type, field size, etc...). The tab is in the lower-half of the screen.

3. Select the field you wish to make as a drop-down.

4. There is another tab next to 'General' named 'Lookup'. Click on that.

5. Set the following Field Properties as follows:

a. Display Control: Combo Box

b. Row Source Type: Value List

c. Row Source: Here you can enter a list of acceptable values, separated by a semicolon. Example: if you want the user to specify from 3 choices (such as A, B or C), you'd enter: A;B;C.

d. Limit To List: Yes - recommended if you don't want the user to enter values other than what you've defined above.

As a minimum, this info may be enough to get your started. Note that this info comes from Office 2007 and your version may be different, thus some options may not be available.

Hope this is enough to start you off. Keep in mind, there is always more than one way to do what it is you ask. Good luck!

You can drag them onto the report.

Reserved words!

Secondary Sort Key

Wildcards

self join

Physical

Variable

You perform several edits in a table within an Access database. When should you execute the Save command?

You cannot improve their functionality as such, as the programs have been written and only the programmers can improve them and then release new versions. You can do more to improve what they do for you. You could learn how to use them more efficiently. You can use Macros. There are Add-ins that can be used for them.

Memo fields can store up to 1 gigabyte of characters or 2 gigabytes of storage (2 bytes per character), of which you can display 65,535 characters in a control on a form or report. In addition, you can now apply rich-text formatting to the data in a Memo field. For example, you can set colours, change fonts, and make data bold or italic. Fields of memo data type cannot be grouped while filtering and it is not possible to sort them however, they are searchable. It is not possible to add a look up property to a memo field. It is also not possible to set an input mask to a memo field meaning that the user can input data however they want without an input mask to guide them as to what format to input the data in.

Text field are for plain text or combinations of text and numbers, such as addresses. Also numbers that do not require calculations, such as phone numbers, part numbers, or postal codes. Text fields may store up to a maximum of 255 characters. Microsoft Access only stores the characters entered in a field; it does not store space characters for unused positions in a Text field. To control the maximum number of characters that can be entered, set the Field Size property. You can and should define a width, but Access doesn't use fixed width storage so is not as wasteful of disk space. Text fields may have look up properties to link them to other fields if necessary.

Yes it can do that.

Inventory.mdb could be a database as .mdb is the extension for Access files up to Office 2003.

Text is an example of a data type is that true

Because you want the field to be large enough to store the data. Also, you may not want to have it too large if you know values are going to be in a small range. If you allocate a large amount of space, that will be used by each record, even when actual values are small, so it is more efficient to use the right sizes. So, in short, you choose the appropriate size to ensure you don't have too little or too much size allocated for your intended data.

And.. Or

Whether you are designing a table or a query, select the field by clicking beside it in a table or above it in a query, so that it is highlighted. Then press the delete key.

Type in: http://www.peteranswers.com/

object type

she's a woman inventor

Yes.