Which of the following types of action queries allows a user to add records from one or more tables to the end of one or more other tables?
An action query is used to update multiple records in one operation. It is a form of select query that performs an action on the results of the selection process. There are four types of action queries available in Microsoft Office Access 2007, which are as follows:
1. Delete queries: A delete query allows to delete records from one or more tables.
2. Update queries: An update query allows to modify fields. This is used to update a field with an expression or data from another table.
3. Append queries: An append query allows to add records from one or more tables to the end of one or more other tables.
4. Make-table queries: A make-table query allows to create a new table from all or part of the data in one or more tables.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design
Which of the following properties binds the object to a source from which data is to be retrieved?
The RecordSource property belongs to the form and report objects. This property binds the object to a source from which data is to be retrieved. This source can be a table or a query. When a form or a report is bound to a table or a query, the controls can be bound to a column of the table through the ControlSource property.
Answer option D is incorrect. The ControlSource property bounds a control to a field of a table. If a control is bound to a field by using this property, the control is known as a bound control. If the value of this property is blank, the control is known as an unbound control. If the ControlSource property contains an expression, the control is known as a calculated control.
Answer option C is incorrect. The RowSource property belongs to the combo box and list box controls. When these controls are bound to a column by the RowSource property, all the data of the column is displayed in the list box or the combo box.
Answer option B is incorrect. The TextFormat property of a control helps to change a text to rich text format. This helps to apply multiple formatting options for the text in a control. A user can change the format of the text to bold, italics, etc., The user can also change the font of the selected text and can apply other types of formatting.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design
Which of the following datatypes will you use to store files in a field?
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Table Design
Jasmine is creating a presentation. When she selects a textbox and starts typing, the existing text is not replaced with what she has typed. Which of the following is the most likely cause of the issue?
Which of the following datatypes generates a consecutive number that can be used as the primary key of a table?
The AutoNumber datatype is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table. The increment can be changed through the New Values property. This property has the following two values:
Increment
Random
The AutoNumber datatype generates a consecutive number that can be used as the primary key of a table. Answer option C is incorrect. The Currency datatype is used to store monetary values. The format of the currency can be changed by using the Format property. The various formats of the Currency datatype are as follows:
* General Number
* Currency
* Euro
* Fixed
* Standard
* Percent
* Scientific
Answer option D is incorrect. The Hyperlink datatype is used to store a hyperlink that is linked to a Web page or to a local or network file. It can store 1GB of data. Any type of file can be linked through this datatype. Each row of a table contains only one hyperlink.
Answer option A is incorrect. The OLE Object datatype is used to attach files and add binary data to a table. This datatype stores each data in a bitmap format. This results in an increase in the size of a database file. Only a single file can be added to each row of a table. The files attached can be Microsoft Office files, graphics files, sound files, pdf files, etc.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Table Design