Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology

Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology
by

1 Answer

Answer :

Field PropertiesAfter you create a field and set its data types, you can also set additional field properties. Setting field properties can give the database extra flexibility and functionality.Some important properties of field are as follows:Field PropertyDescriptionSupported byField sizeIt limits the number ofcharacters that can be typed into a field.AutoNumber, Text, Number.FormatIt customises the way thattext or numbers aredisplayed and printed.Text, Memo, Number,DateTime, Currency, AutoNumber, Yes/No, Hyperlink.Input MaskIt sets up the field to receivedata in a particular format.Text, Number, DateTime,Currency.CaptionIt adds a label to the field to assist the user.All data type.Default ValueSets a value to appear in thefield before you enter anydata. It is used to avoid the typeText, Memo, Number,Date/Time, Currency, Yes/No, Hyperlink.Validation RuleA condition that must bemeet before the data isaccepted into the databaseText, Memo, Number,DateTime, Currency, Yes/No, Hyperlink.Validation TextThis appears if a validation rule is not satisfied.Same as a validation.RequiredMakes data entrycompulsory, so that field can not be left blank.Text, Memo, Number,Date/Time, Currency, OLEObject, Hyperlink, Attachment.IndexedTo speed up queries, sortingand grouping operations orto prevent users fromentering duplicate values.Text, Memo, Numbers,Date/Time, Currency, AutoNumber, Yes/No, HyperlinkSmart TagsAttaches smart tag to the field.Text, Memo, Number,Date/Time, Currency,AutoNumber, Hyperlink.Text AlignSpecifies the alignment (i.e.general, left, center etc.) of text within a control.Text, Memo, Number,Date/Time, Currency,AutoNumber, Yes/No, OLEObject, Hyperlink.
by

Related questions

Microsoft Office Access 2007 includes a set of database ………… which are designed for specific business needs. -Technology

Description : Microsoft Office Access 2007 includes a set of database ………… which are designed for specific business needs. -Technology

Last Answer : Microsoft Office Access 2007 includes a set of database templates which are designed for specific business needs.

What is database template? Give the description of five templates, used in Microsoft Access 2007. -Technology

Description : What is database template? Give the description of five templates, used in Microsoft Access 2007. -Technology

Last Answer : A template is a complete tracking application with predefined tables, forms, reports, queries, macros, and relationships. Each template creates a complete end-to-end solution that you can use ... to create a projects tracking database to track multiple projects and assign tasks to different people.

Write down the purpose and features of Show Markup option available in Review tab of Word 2007 document. -Technology

Description : Write down the purpose and features of Show Markup option available in Review tab of Word 2007 document. -Technology

Last Answer : Accepting or rejecting changes work much like the Spell Check feature. By cycling through the changes made to a document, the author can accept or reject any or all changes.For accepting or rejecting ... and (iii) until all changes/comments have been reviewed.5. When finished, save your document.

Explain the purpose of AutoFormat feature of Word 2007. How it can be used in a Word document? -Technology

Description : Explain the purpose of AutoFormat feature of Word 2007. How it can be used in a Word document? -Technology

Last Answer : Auto-formatting feature of Word processing tool allows the automatic formatting of certain kinds of text while' typing. By selecting certain formatting options, theMicrosoft Office 2007 system programs can automatically ... .7. Click Add button.8. Click OK button.9. Close the Symbol dialog box.

What is the purpose of Default Value field property? -Technology

Description : What is the purpose of Default Value field property? -Technology

Last Answer : If there is a situation when you want to enter the same value for all records. Then, to avoid typing the same thing many times, you can set as a Default Value property.

Give five names of database templates used in MS_Access 2007. -Technology

Description : Give five names of database templates used in MS_Access 2007. -Technology

Last Answer : Assets, Contacts, Events, Faculty and Issues.

When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Description : When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Last Answer : (d) Description field of the table is optional, as it depends on the databasedesigner that he/she wants to describe a field or not.

How will you create a blank database in MS_Access 2007? -Technology

Description : How will you create a blank database in MS_Access 2007? -Technology

Last Answer : Creating a Blank DatabaseTo create a new blank database, you need to perform the steps which are as follows:Step 1 Start Microsoft Access 2007, then Getting Started with Microsoft Office Access page will ... in the first empty cell in the Add New Field column as shown in the following figure:

When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology

Description : When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology

Last Answer : False Because ribbon appears on the top of the window.

How do you locate MS_Word 2007 on your computer system? -Technology

Description : How do you locate MS_Word 2007 on your computer system? -Technology

Last Answer : To locate MS-Word on our computer system:Click Start —> All Programs —> Microsoft Office —> Microsoft Office Word 2007.

What is the use of ruler in MS_Word 2007 document? -Technology

Description : What is the use of ruler in MS_Word 2007 document? -Technology

Last Answer : Ruler is used to set tabs, indents and margins for a document.

Write the name of alignments, which are available in MS_Word 2007. -Technology

Description : Write the name of alignments, which are available in MS_Word 2007. -Technology

Last Answer : Left, Right, Center and Justify.

What is the use of Crop option in MS_Word 2007? -Technology

Description : What is the use of Crop option in MS_Word 2007? -Technology

Last Answer : Crop option allows a user to edit pictures (only cropping).

What are the basic features of printing in MS_Word 2007? -Technology

Description : What are the basic features of printing in MS_Word 2007? -Technology

Last Answer : The basic features of printing in MS-Word 2007 are as follows:1. Print2. Quick Print3. Print Preview

Define MS_Word 2007. -Technology

Description : Define MS_Word 2007. -Technology

Last Answer : MS-Word 2007 is a Word processing software package, which allows you to easily create a variety of professional looking documents like letters, reports and other documents using features such as Themes, Styles, SmartArt and more. It is a powerful tool chat you can use to create effective documents.

Explain different types of tabs available in MS_Word 2007. -Technology

Description : Explain different types of tabs available in MS_Word 2007. -Technology

Last Answer : TabsThese are similar to the menu system of MS-Word 2003. Instead of having drop down menus, MS-Word 2007 creates a Ribbon system, where buttons and commands are grouped under the tabs. Some groups ... to change the outline or draft views, display the ruler or document map, zoom, switch windows etc.

1. What is MS_Word 2007? 2. List new features of MS_Word 2007. -Technology

Description : 1. What is MS_Word 2007? 2. List new features of MS_Word 2007. -Technology

Last Answer : 1. MS-Word 2007 is the Word processing software in the Microsoft 2007 Office suite.2. Some new features of MS-Word 2007 are as follows:(a) The Ribbon System(b) Themes(c) Quick Styles(d) Pictures(e) Live Preview(f) Shapes(g) ClipArt(h) Charts(i) SmartArt

MS_Word 2007 allows you to insert …………. in your documents. -Technology

Description : MS_Word 2007 allows you to insert …………. in your documents. -Technology

Last Answer : MS-Word 2007 allows you to insert picturesin your documents.

MS_Word 2007 allows you to easily create a variety of professional looking documents using features such as Themes, Styles, SmartArt and more. -Technology

Description : MS_Word 2007 allows you to easily create a variety of professional looking documents using features such as Themes, Styles, SmartArt and more. -Technology

Last Answer : TrueMS-Word 2007 is a powerful tool that allows you to create a variety of professional looking documents because in Word 2007, all the things are replaced with a new navigation system.

MS_Word 2007 tool menu is packed full of lines, arrows, squares and much more. -Technology

Description : MS_Word 2007 tool menu is packed full of lines, arrows, squares and much more. -Technology

Last Answer : FalseWord 2007 tool menu is not packed full of lines, arrows, squares but Word 2007 shapes menu is packed full of all these features.

Editing text in MS_Word 2007 only involves inserting text. -Technology

Description : Editing text in MS_Word 2007 only involves inserting text. -Technology

Last Answer : FalseEditing text means making corrections as desired end results.

How many types of Mathematical symbol sets are available in Word 2007? -Technology

Description : How many types of Mathematical symbol sets are available in Word 2007? -Technology

Last Answer : 8 types of Mathematical symbol sets are available in Word 2007.

Explain the feature, Track Changes of MS_Word 2007. -Technology

Description : Explain the feature, Track Changes of MS_Word 2007. -Technology

Last Answer : Track Changes is a feature in Microsoft Word which allows us to keep track of the changes that we make to a document. It allows us to accept or reject the track changes, insert or delete comments etc.

In PowerPoint 2007 under the Insert tab, there is a button named Text Box. What is the utility of this button? -Technology

Description : In PowerPoint 2007 under the Insert tab, there is a button named Text Box. What is the utility of this button? -Technology

Last Answer : Like a title placeholder, a Text Box is used to hold the text information

Explain the various views of a slide available in PowerPoint 2007. -Technology

Description : Explain the various views of a slide available in PowerPoint 2007. -Technology

Last Answer : In Microsoft Office PowerPoint 2007, different views of a slide are used to edit, print and deliver a presentation. PowerPoint slide views can be found in two places as follows:1. On the ... can make universal style changes to every slide, notes page, or handout associated with the presentation.

File extension for a PowerPoint 2007 presentation is ………………. (a) .ptt (b) .pptx (c) .docx (d) .clsx -Technology

Description : File extension for a PowerPoint 2007 presentation is ………………. (a) .ptt (b) .pptx (c) .docx (d) .clsx -Technology

Last Answer : (b) .pptx is the file extension given to all PowerPoint 2007 files.

Which field property sets limits on the data that is entered? -Technology

Description : Which field property sets limits on the data that is entered? -Technology

Last Answer : Fixed Field Length or Field Size property sets the limits on the data entered.

For which type of field, “Default Value” property is not applicable? -Technology

Description : For which type of field, “Default Value” property is not applicable? -Technology

Last Answer : Attachment, AutoNumber, OLE Object.

Which field property specifies whether the field can be left empty when entering data into a record? -Technology

Description : Which field property specifies whether the field can be left empty when entering data into a record? -Technology

Last Answer : Required property.

Write one example of data field for which you would set the Required property to Yes? -Technology

Description : Write one example of data field for which you would set the Required property to Yes? -Technology

Last Answer : In a table, when we declare a field as a primary key, then the field’s Required property must be set to Yes because, in a primary key field, we need to enter data always.

Which property is used to add a label to the field to assist the user? (a) Default value (b) Caption (c) Format -Technology

Description : Which property is used to add a label to the field to assist the user? (a) Default value (b) Caption (c) Format -Technology

Last Answer : (b) Caption is used to add a label to the field for assisting to the user.

Which field property helps in setting data validation in a table? -Technology

Description : Which field property helps in setting data validation in a table? -Technology

Last Answer : (d) Validation Rule property specifies a condition that must be met before the data is accepted into the database.

The ………….. field property makes data entry compulsory, so that the field cannot be left blank. -Technology

Description : The ………….. field property makes data entry compulsory, so that the field cannot be left blank. -Technology

Last Answer : TheRequired field property makes data entry compulsory so that the field cannot be left blank.

Distinguish between Number and AutoNumber data type field. Give example of each. -Technology

Description : Distinguish between Number and AutoNumber data type field. Give example of each. -Technology

Last Answer : Distinguishing between Number and AutoNumber dataNumberAutoNumberIt holds numeric values whichare used for calculations.It allows to store numbers thatare automatically generatedfor each record.The field ... for every newcustomer, this field willautomatically increase and willprovide a new number.

How NUMBER and DATE/TIME type fields are different in Access? Give any one difference. -Technology

Description : How NUMBER and DATE/TIME type fields are different in Access? Give any one difference. -Technology

Last Answer : NUMBER data type contains numeric values, while DATE/TIME type field contains date and time values.

Why doesn't the join line show up in Access 2007?

Description : Why doesn't the join line show up in Access 2007?

Last Answer : answer:I don't have that version of Access, so it probably wouldn't do me any good to have your file in any case. But I would check the two fields that you're attempting to link (look at ... to re-check the steps you took in creating the tables themselves. I suspect that your problem is that basic.

How to get the value from a listbox populated by a query in access 2007?

Description : How to get the value from a listbox populated by a query in access 2007?

Last Answer : Can the code be placed in the form with the list boxes? Then you could refer to them without the qualifiers, like this id_proyecto.Value id_muestra.Value

What is the right access 2007 sql syntax for adding the last record of another table?

Description : What is the right access 2007 sql syntax for adding the last record of another table?

Last Answer : INSERT INTO samples (id_sample) SELECT Last(project.Id) AS LastOfId FROM project I tested this and it works. One nice thing about Access is you can use the graphical query designer to test your syntax. The ... View if you prefer text over the GUI. It will not run or save your query if errors exist

Can't add records into a form in access 2007?

Description : Can't add records into a form in access 2007?

Last Answer : You need to make sure all the forms you create are labelled correctly, so they don’t interfere with each other. So unique names for each. You can do it within the same program. If i understand you correctly. lol

I want to open a file from a path stored in a record in access 2007?

Description : I want to open a file from a path stored in a record in access 2007?

Last Answer : What about something like this or have you figured this out already? Do you have visual basic? I found that working with visual basic as a front end was far easier than trying to use the forms built into access itself.

computer network. A computer network is a group of (i) ………. that are (ii) ……… to each other for the purpose o -Technology

Description : computer network. A computer network is a group of (i) ………. that are (ii) ……… to each other for the purpose o -Technology

Last Answer : (i) computers(ii) connected(iii) communication(iv) network(v) share

Did the Apple iPhone first become available in 2005, 2006 or 2007?

Description : Did the Apple iPhone first become available in 2005, 2006 or 2007?

Last Answer : 2007

Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology

Description : Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology

Last Answer : (b) Key is a data item that allows you to uniquely identify individual occurrences which is defined as the column or set of columns.

How are field types Text and Memo different from each other? -Technology

Description : How are field types Text and Memo different from each other? -Technology

Last Answer : Distinguishing between Text and Memo are as follows:TextMemoIt is used for relatively short entries.It is used for long text paragraphs.It can storeupto255 characters only.It can storeupto65536 characters. ... number of characters.It does not use field size property.e.g. Emp_namee.g. Emp_description

Write one example of each field, for which you would use 1. Text data type -Technology

Description : Write one example of each field, for which you would use 1. Text data type -Technology

Last Answer : 1. Text data type It allows to store text or combination of text and numbers as well as numbers that don't require calculations such as phone number. This data type allows maximum 255 characters ... Description will be of Memo data type, because the length of description of employee may be large.

…………. is a field which is used as a primary key and numbers each record sequentially. -Technology

Description : …………. is a field which is used as a primary key and numbers each record sequentially. -Technology

Last Answer : AutoNumberis a field which is used as a primary key and numbers each record sequentially.

What is the name of the column heading for each category in a data source? (a) Data field (b) Field (c) Field name (d) Record -Technology

Description : What is the name of the column heading for each category in a data source? (a) Data field (b) Field (c) Field name (d) Record -Technology

Last Answer : (c) Field name is the name of the column heading for each category in a data source.

A question about Microsoft Office PowerPoint Veiwer 2007- please help!

Description : A question about Microsoft Office PowerPoint Veiwer 2007- please help!

Last Answer : I am unsure of what the issue is you are having. Can you open the file? Does it show the last saved data?

Is there a big difference between Microsoft Office 2007 and 2010?

Description : Is there a big difference between Microsoft Office 2007 and 2010?

Last Answer : answer:there is more integration with shared services since the big push now is for for cloud computing. But as far where stuff is located with the program, the layout hasn't changed much so you will ... safe following in your book. I tried searching for a trial but its not out there anymore. Sorry.

How can I get back Microsoft Office 2003 after downloading a trial of Office 2007?

Description : How can I get back Microsoft Office 2003 after downloading a trial of Office 2007?

Last Answer : You would likely have to find a disk and reinstall the program. It sounds as if your student allowed 2007 to upgrade 2003 instead of installing it along side of 2003.