1.
**Preview** view
2.
**Layout** view
3.
**Design** view
4.
**Form** view
Q 1 / 30
1.
Double-click the button control to lock it on, then left-click in the form to add each button
2.
Right-click the button control and select Drop Multiple Controls. Then left-click to add each button to a form
3.
Select the Multiple Object check box in the Design tab before selecting the button control
4.
Left-click the button control to select it, then add multiples to the form by right-clicking in the position you'd like to add them
Q 2 / 30
"In a desktop database, you can also use the ampersand operator (&) for concatentation. In an Access app, you must use the plus sign (+)."_1.
`&`
2.
`!`
3.
`#`
4.
`-`
Q 3 / 30
`<p align="center"><img src="./images/question_4.png"></p>`1.
lookup
2.
reference integrity
3.
pick list
4.
validation rule
Q 4 / 30
1.
Sort on month number, then sort on month name
2.
Sort on month number, then group on month name
3.
Group on month number, then sort by month name
4.
Group on month number, then sort on month number
Q 5 / 30
1.
crosstab
2.
select
3.
simple
4.
spreadsheet
Q 6 / 30
1.
Scientific
2.
Standard
3.
General Number
4.
Fixed
Q 7 / 30
1.
removes the ribbon interface
2.
removes all ribbon tabs except Home and Print Preview
3.
disable the right-click menu when working with objects
4.
removes the **Design** view contextual tabs, which forces most design changes to be made in **Layout** view
Q 8 / 30
1.
Use a form to display the customer details with a subform linked to their order information
2.
Create a split form that displays the customer information at the top and the order history in the table below
3.
Create a navigation form that includes a form for the customer details and a separate form for the order history
4.
Create a continous form that uses a query to gather all of the customer details and order history in a single record source
Q 9 / 30
1.
In the **Access Options** dialog box, click **Current Database**, then select the form you want to open in the **Display Form** property
2.
Open the form you want to display automatically in **Design** view. Then in the property sheet, set **Open on Launch** to **true**
3.
Right-click the form you want to open automatically and select **Startup Form**
4.
On the **Database Tools** tab, click **Database Options**, then set the form you want to open as the **Initial View** object
Q 10 / 30
1.
**Page Layout**
2.
**View** section
3.
Form body
4.
**Detail** section
Q 11 / 30
1.
Object dependencies
2.
Table analyzer
3.
Access database manager
4.
Database documenter
Q 12 / 30
1.
After Insert
2.
Before Change
3.
After Update
4.
Before Delete
Q 13 / 30
1.
a group header
2.
nothing
3.
a group header and footer
4.
a group footer
Q 14 / 30
| General | Lookup | | --------------- | ------------------------------- | | Display Control | Combo Box | | Raw Source Type | Value List | | Raw Source | 1:"High"; 2 :"Normal"; 3: "Low" | | Bound Column | 1 | | Column Count | 2 | | Column Heads | No | | Column Widths | 0; 1 | | List Rows | 16 | | List Width | Auto |1.
1
2.
3
3.
2
4.
Normal
Q 15 / 30
https://support.microsoft.com/en-us/office/iif-function-32436ecf-c629-48a3-9900-647539c764e31.
`Switch()`
2.
`IsError()`
3.
`IIf()`
4.
`Choose()`
Q 16 / 30
1. [Text:](https://support.microsoft.com/en-us/office/format-a-text-field-a5e5bcde-85da-4c7a-8164-1fe286636668) 2. [Numerical:](https://support.microsoft.com/en-us/office/format-a-number-or-currency-field-e48f2312-67f0-4921-aca0-15d36b7f9c3b)1.
left; right
2.
right; left
3.
left; left
4.
right; right
Q 17 / 30
1.
Attachment
2.
Replication ID
3.
BLOB
4.
Hyperlink
Q 18 / 30
1.
Set the Indexed property to No
2.
Set the Required property to Yes (Unique Values)
3.
Set the Validation Rule property to No Duplicates
4.
Set the Indexed property to Yes (No Duplicates)
Q 19 / 30
1.
Database Documenter
2.
Compact and Repair Database
3.
Database Splitter Wizard
4.
Table Analyzer Wizard
Q 20 / 30
1.
`A serialized backup number, such as "_Backup_2"`
2.
`The current date, such as "_2019-08-21"`
3.
`The characters "_bu"`
4.
`The word "_Archive"`
Q 21 / 30
1.
Popup Text
2.
Description
3.
Caption
4.
Tool Tip
Q 22 / 30
1.
ControlTip Text
2.
Status Text
3.
Tool Text
4.
Help Text
Q 23 / 30
1.
comparison operators
2.
logical operators
3.
string operators
4.
arithmetic operators
Q 24 / 30
1.
page header
2.
group header
3.
detail header
4.
report header
Q 25 / 30
1.
When you want to retrieve every record from the left table, plus any matching information from the right table where it exists
2.
When you want to retrieve all of the records from the right table that have matching records in the left table
3.
When you want to retrieve just the records from the left table that have matching records in the right table
4.
When you want to retrieve just the records from the left table that do not have any matching records in the right table
Q 26 / 30
1.
Use an If container in the macro.
2.
Call the submacro with the [MacroName]![SubMacroName
3.
Use a RunMacro or OnError macro action.
4.
Expand the macro in the **Navigation Pane** and double-click the submacro name.
Q 27 / 30
1.
Control Source
2.
Row Source
3.
Value List
4.
Data Source
Q 28 / 30
1.
the current system date
2.
the current system date, time, and time zone
3.
the current system date and time
4.
the current system time
Q 29 / 30
1.
discouraged terms
2.
reserved words
3.
retired objects
4.
system names
Q 30 / 30