-->
Home FREE SKILL DEVELOPMENT TRAINING'S LAB ASSIGNMENT

Microsoft Access day two

Steps to open the Microsoft Access :
  • Click on Start Button
  • Click on Run
  •  Type “MSACCESS" 

(OR)

  • Click on Start Button
  • Click on All Programs
  • Click on Microsoft Office
  • Then Click on “Microsoft-Office Access 2007”
  • Choose the Blank Database
  • Type the name you want to give your database in the File Name field. Access will automatically append .accdb to the name.
  • Click the Browse button. The File New Database window appears.
  • Locate the folder in which you want to store your database. Note that the name of the file appears in the File Name field.
  • Click OK.
  • Click the Create button. Access creates the database and opens a datasheet with the Table Tools available to you.


Note the Table Tools in the upper-right portion of the Ribbon.

Home Tab: View Group: Design View

Data types :

The following table provides a list of the available data types in Microsoft Office Access 2007, along with usage guidelines and storage capacities for each type.


Data Type Use Size
TextUse for alphanumeric characters, including text, or text and numbers, that are not used in calculations (for example, a product ID).Up to 255 characters.
MemoUse for text greater than 255 characters in length, or for text that uses rich text formatting. Examples include notes, lengthy descriptions, and paragraphs that use text formatting, such as bold or italics.
Use the Text Format property of a Memo field to specify whether the field supports formatted text.
Set the Append Only property of a Memo field to Yes to retain previous versions of the field value when the value changes.
Up to 1 gigabyte of characters, or 2 gigabytes of storage (2 bytes per character), of which you can display 65,535 characters in any single control.
NOTE:  The maximum size for an Office Access 2007 database file is 2 gigabytes.
NumberUse for storing numeric values (integers or fractional) that will be used in calculations, except for monetary values.
NOTE: Use the Currency data type for monetary values.
1, 2, 4, 8, or 12 bytes (16 bytes when used for a replication ID)
For more information, refer to the Number Field Size entry in the Field properties reference table.
Date/TimeUse for storing date and time values. Note that each stored value includes both a date component and a time component.8 bytes
CurrencyUse for storing monetary values (currency).8 bytes
AutoNumberUse for generating unique values that can be used as a primary key, which Access inserts when a record is added. Note that AutoNumber fields can be incremented sequentially or by a specified increment, or assigned randomly.4 bytes (16 bytes when used for replication ID).
Yes/NoUse for Boolean values: Yes/No, True/False, or On/Off.1 bit (0.125 bytes).
OLE ObjectUse for storing OLE objects from other Microsoft Windows programs.Up to 1 gigabyte
AttachmentUse for storing binary files (that is, files that you cannot read by using a text editor), such as digital images (photos and graphics) or files created by using other Microsoft Office products.
You can attach more than one file per record to an Attachment field.
For compressed attachments, 2 gigabytes. For uncompressed attachments, approximately 700kb, depending on the degree to which the attachment can be compressed.
NOTE: The maximum size for an Office Access 2007 database file is 2 gigabytes.
HyperlinkUse for storing hyperlinks, which provide single-click access to Web pages through a URL (Uniform Resource Locator) or to files through a name in UNC (universal naming convention) format. You can also link to Access objects that are stored in a database.Up to 1 gigabyte of characters, or 2 gigabytes of storage (2 bytes per character), of which you can display 65,535 characters in any single control.
NOTE: The maximum size for an Office Access 2007 database file is 2 gigabytes.
Lookup WizardUse to start the Lookup Wizard so that you can create a field that uses a combo box to look up a value in another table, query, or list of values. Note that Lookup Wizard is not an actual data type.If the lookup field is bound to a table or a query, the size of the bound column.
If the lookup field is not bound to another column (and stores a list of values), the size of the Text field used to store the list.