Explain the different object available in Microsoft Access?

Answer 1

Choosing Field Names Microsoft Access gives you lots of flexibility when it comes to naming your fields. A field name can be up to 64 characters long, and can include any combination of letters, numbers, spaces, and special characters except a period (.), an exclamation point (!), an accent grave ('), and brackets ([ ]); however, the name cannot begin with a space, and cannot include control characters (ANSI values 0 through 31).

In general, you should give your fields meaningful names and should use the same name throughout for a field that occurs in more than one table. You should avoid using field names that might also match any name interval to Microsoft Access or Visual Basic. For example, all objects have a Name property, so it's a good idea to qualify a field containing a name by calling it CustomerName or ClubName. You should also avoid names that are the same as built-in functions, such as Date, Time, Now, or Space. See Microsoft Access help for a list of all built-in functions names. For character data,

You should normally select the Text data type. You can control the maximum length of a Text field by using a field property. Use the Memo data type only for long strings of text that might exceed 255 characters or that might contain formatting characters such as tabs or line endings (carriage returns). When you select the Number data type,

You should think carefully about what you enter as the Field Size property because this property choice will affect precision as well as length. (For example, integer numbers do not have decimals.) The Date/Time data type,

Useful for calendar or clock data and has the added benefits of allowing calculations in minutes, seconds, hours, days, months, or years. For example, you can find out the differences in days between two Date/Time values.

Use the Date/Time data type to store any date, time, or date and time value. Currency data type,

For storing money values. Currency has the precision of integers, but with a fixed number of decimal places. When you need to store a precise fractional number that's not money, use the Number data type and choose the Decimal field size. The AutoNumber data type,

Specifically designed for automatic generation of primary key values. Depending on the Field Size and New Values properties you choose for an AutoNumber field, you can have Access create a sequential or random long integer. You can include only one field using the AutoNumber data type. Use the Yes/No data type,

Hold Boolean (true or false) values. This data type is particularly useful for flagging accounts paid or not paid or orders filled or not filled. The OLE Object data type allows you to store complex data, such as pictures, graphs, or sounds that can be maintained by a dynamic link to another Window-based application. For example, Access can store and allow you to edit a Microsoft Word document, a Microsoft Excel spreadsheet, a Microsoft PowerPoint presentation slide, a sound file (wav), a video file (avi), or picture created using the Paint or Draw application. The Hyperlink data type lets you store a simple or complex "link" to an external file or document. This link can contain a Uniform Resource Locator (URL) that points to a location on the World Wide Web or on a local intranet. It can also contain the Universal Naming Convention (UNC) name of a file on a server on your local area network (LAN) or on your local computer drives. The link can point to a file that is in Hypertext Markup Language (HTML) or in a format that is supported by an ActiveX application on your computer. For more details refer http://msaccess.batcave.net/page04.htm

Answer 2

1. Table: A table stores data about an entity (a person, place, or thing) and is the basic element in any database. A table is made up or records, which in turn are made up of fields. It is columnar in appearance, with each record in a separate row of the table and each field in a separate column.

2. Form: A form provides a more convenient and attractive way to enter, display and/or print the data in a table.

3. Query: A query answers a question about the database. The most common type of query specifies a set of criteria, then searches the database to retrieve the records that satisfy that criteria.

4. Report: A report presents the data in a table or query in attractive fashion on the printed page.

5. Macro: A macro is analogous to a computer program and consists of commands that are executed automatically one after the other. Macros are used to automate the performance of any repetitive task. Macros are beyond the scope of this class.

6. Module: A module provides a greater degree of automation through programming in Access Basic. Macros are beyond the scope of this class.

Answer 3

The data types in Microsoft Access are Text, Memo, Number, Date/Time, Currency, AutoNumber, Yes/No, OLE Object, Hyperlink, Attachment, Calculated and Lookup Wizard.

Data type usages

Text is used for small texts upt o 255 characters

Memo is used for texts larger than 255 characters

Date/Time is used for date and time values

Currency is used for currency values. The currency type avoids small rounding differences in fractions.

AutoNumber is used for primary key fields that need an automatically incrementing, database generated numeric id.

Yes/No is used for situations where a yes/no answer must be stored, like 'does this user want to receive our weekly newsletter'.

OLE object is used to embed or link to documents from other programs like Excel and Word.

Hyperlink is used to store links.

Attachment is used to store files in a database field.

Calculated is used to store the result of a calculation that involves other fields.

Lookup Wizard is used to have the user choose from a list of predefined options.

Answer 4

A data type in MS Access (and in databases in general) is a property of a field that determines what type of data the field can hold.

Most databases have data types for whole numbers, for numbers with fractions, for very large numbers, for small texts, for large texts and for date and time values.

Access (2010) has 12 data types of which a couple are used very frequently, like Text, Memo, Number, Currency and Date/Time.

Answer 5

While there are too many data types to individually list here, the related link below does a great job documenting all of them and their ODBC equivalents.

Some limitations of MS Access data types that I know off hand are that Varchar's can only contain up to 255 characters and a table can only hold around 45,000 records. However if a file gets to that size, I'm not sure I know of a computer that could choke down the size of that file.

Answer 6

Text,Number,Currency,Counter,Date/Time,AutoNumber. Here r the some data types used in ms access

from:- Mithu(Harison)

Answer 7

Text, Memo, Number, Date/Time, Currency, AutoNumber, Yes/No, OLE object, Hyperlink, Attachment, Calculated

Answer 8

number