• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/19

Click to flip

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]