Which of the following datatypes will you use to store files in a field?
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Table Design
Which of the following options can be used to retrieve data from a database without directly connected to the tables in the database by using a visual basic application?
A query can be used to retrieve data from the database without directly connected to the tables in the database. It can be created for either a single table or for joining two or more tables. The query acts as a virtual table and users can retrieve data from it.
Answer options A, B, and C are incorrect. These are not valid options for this.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Table Design
You want to perform the following tasks to manipulate data before importing it into Access:
* Add fields.
* Combine fields.
* Use complex mathematical functions.
Which of the following is the best place to perform the above listed tasks?
A Microsoft Office Excel worksheet is the best place to perform the following tasks to manipulate data before importing it into Access:
* Add or remove fields.
* Combine or split fields.
* Use complex mathematical functions.
You can easily import a worksheet or a named range from a worksheet into a new table or an existing table. You can also import some particular fields from a worksheet or a named range into Access.
Answer options C, B, and A are incorrect. You can use these three places for importing data into Access, but all these have a complicated process of importing information.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Import, Export and Link data
Which of the following functions will return the current system date and time?
The Now() function is used to return the current system date and time.
Following is the syntax for the Now() function:
Now() Answer option A is incorrect. The Format() function is used to take an expression and return it as a formatted string.
Following is the syntax for the Format() function:
Format(expression, [format, [firstdayofweek, [firstweekofyear]]] )
Answer option B is incorrect. The DatePart() function is used to return a specified part of a given date.
Following is the syntax for the DatePart() function:
DatePart(interval, date, [firstdayofweek], [firstweekofyear])
Answer option C is incorrect. The Date() function is used to return the serial number of a date.
Following is the syntax for the Date() function:
Date(year, month, day)
Chapter: ADVANCED SPREADSHEETS
Objective: Functions
Which of the following controls are available in a form?
Each correct answer represents a complete solution. Choose all that apply.
The following controls are available in a form:
* Rich Text: It is used to provide a text block control and is typically used for text entry that a user does not want changed or accessed.
* Text: It is used to provide a text block control.
* Picture Content Control: It is used to select an image to insert into the form.
* Building Block Gallery: It is used to select text blocks from a building block gallery.
* Combo Box: It is used to select a response from a drop-down list.
* Drop-Down List: It is used to provide a list of responses for the user.
* Date Picker: It is used to select a date from an interactive calendar.
* Check Box Content Control: It is sued to provide a check box for user response.
* Legacy Forms: It is used to supply a list of legacy Word form controls and ActiveX controls.
Answer option B is incorrect. It is not a valid control in a form.
Chapter: ADVANCED WORD PROCESSING
Objective: Enhancing Productivity
