Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
19 Cards in this Set
- Front
- Back
- 3rd side (hint)
Write dim and set statement for a recordset
|
dim db as dao.database
dim rs as dao.recordset set db = currentdb() set rs = db.openrecordset("tablename") set rs = db.openrecordset(_ "select tablename.* from table anem where x = y",dbopendynaset) |
db database
rs recordset dynaset select |
|
Use with statement to add a screen field firstname to a table
|
with rs
.addnew !firstname = txtfirsname.text .update end with |
no hint
|
|
Create Class statement for creating a record 2 lines only
|
public sub createrecord
end sub |
public or private
|
|
Create a switch using the iif function
|
sw = iif(value1 = x,true,false)
|
sw =
|
|
create an instance of the validate input object
|
private validate as new clsvalidateinput
|
no hint
|
|
Use qbe grid to illustrate between
|
between "a" and "n"
|
Criteria
|
|
use qbe grid to illustrate like
|
like "3/*/94"
|
Criteria
|
|
use qbe grid to illustrate less than or equal to twenty five
|
<=25
|
no hint
|
|
use qbe grid to show query indicating non blank state/province
|
field state/province
table customers sort ascending cirteria is not null |
field
table sort criteria |
|
what is the secret of the autolooup query
|
many to one
|
no hint
|
|
How do you prompt for input firts name field using the qbe grid
|
field first name
criteria [what first name?] |
field
cirteria |
|
use qbe to show the total city and states for each customer if you are given the city, state and customer id's sort should be in ascending order
|
field city state count :customer id
table customers customers customers total group by group by count sort ascending |
field
table total sort |
|
using qbe given category id, current price show average price for each category
show smallest first |
field category id avgprice:currentprice
table products products total group by avg sort descending |
field
table total sort |
|
convert this select query to an update query increasing the price by 15%
field current price product name table products products sort ascending ascending criteria < 30 |
field current price product name
table products products update to 1.15*[current price] criteria < 30 |
field
table update to criteria |
|
Write the statements to bring in a text file 811 bytes long
|
Private Sub cmdConvert_Click()
Dim InString As String Dim NewFile As String Dim ConvertedRecord As String Dim ExistingFile As String GoSub OpenExistingFile GoSub OpenNewFile While Not EOF(1) InString = Input(811, #1) Write #2, Converted(InString) Wend Close #1 Close #2 Kill ExistingFile Name NewFile As ExistingFile Exit Sub OpenExistingFile: On Error GoTo FileopenErrorRoutine ExistingFile = "c:\test.txt" Open ExistingFile For Input As #1 Return OpenNewFile: On Error GoTo FileCreationErrorRoutine NewFile = "C:\temp.txt" Open NewFile For Output As #2 Return FileopenErrorRoutine: MsgBox "Error opening file: " & Err.Description, vbOKOnly Exit Sub FileCreationErrorRoutine: MsgBox "Error creating file: " & Err.Description, vbOKOnly Exit Sub End Sub |
|
|
p? means
|
values that start with p folowed by any single character
|
|
|
(619)*
|
any text starting with (619)
|
|
|
9# means
|
9 plus any single digit
|
|
|
! means
|
any character except [!n-z]
|
|