Database Development |
|
Yes |
No |
Can you analyze a process to
determine the necessary tables and fields? |
|
Yes |
No |
Can you create a table? |
|
Yes |
No |
Do you understand each of the
field types (text, memo, Yes/No, Number, etc)? |
|
Yes |
No |
Can you establish a key and
a multipart key for each table in the database? |
|
Yes |
No |
Do you know how master, transaction
and lookup tables are used? |
|
Yes |
No |
Can you switch between datasheet
view and design view in a table? |
|
Yes |
No |
Can you apply an input mask,
default value and format a field? |
|
Yes |
No |
Can you set the size for a text
field? |
|
Yes |
No |
Can you create a table relationship? |
|
Yes |
No |
Can you create a query with
a single table? |
|
Yes |
No |
Can you create a query with
multiple tables? |
|
Yes |
No |
Can you determine which tables
are necessary for a query based on your output
(what must print on a report)?
|
|
Yes |
No |
Can you add and remove specific
fields from multiple tables to/from the grid? |
|
Yes |
No |
Can you sort on one or more
fields? |
|
Yes |
No |
Can you enter selection criteria
for text, numeric, Yes/No and date fields? |
|
Yes |
No |
Can you combine selection criteria
for AND and OR statements? |
|
Yes |
No |
Can you use the expression builder
to create a formula? |
|
Yes |
No |
Can you use the expression builder
to join text fields? |
|
Yes |
No |
Can you switch between datasheet
view and design view in a query? |
|
Yes |
No |
Can you switch between form view
and design view? |
|
Yes |
No |
Can you move fields around on
the form? |
|
Yes |
No |
Can you move a data field separately
from the data label? |
|
Yes |
No |
Can you change the tabbing order
in a form? |
|
Yes |
No |
Can you create a sub form and
link it to the master form? |
|
Yes |
No |
Can you add a label to a form
for a title or instructions? |
|
Yes |
No |
Can you apply colors to the
background, borders and fields? |
|
Yes |
No |
Can you create a report using
the wizard? |
|
Yes |
No |
Can you switch between print
preview and design view? |
|
Yes |
No |
Can you move fields around on
the report? |
|
Yes |
No |
Can you move a data field separately
from the data label on the report? |
|
Yes |
No |
Can you add a label to a report
for a title or description? |
|
Yes |
No |
Can you group records in a report? |
|
Yes |
No |
Do you know the difference between
the report header/footer, page header/footer,
group header/footer and detail sections of the report?
|
|
|
