All data will be validated. Incomplete data may not be saved.
The application will manage all its files and directories, and allow the User to locate files where appropriate. The application will not “fall over” if a file or directory is not located.
Messages to Users will address them by their forename.
The application will manage Users and their privileges.
The application will manage all lookup-tables.
The application will integrate all Administrative elements, and will not require a separate application to provide this functionality.
All objects in the MS Access front-end shall bear their full descriptions.
The Reddick-VBA extended naming scheme will be used.
In the case of Oracle or MS SQL Server back-ends, names will not be mixed-case. Some improvisation of mnemonics is required to facilitate the field types that are different to those described in the RVBA standard.
Mnemonic prefixes will be followed by an underscore.
Examples are :
 |
dtm_StartPeriod |
|
frm_MainMenu |
|
ztmac_Temp |
Access Database Explorer object tags :
|
Tag |
Object Type |
|
tbl |
Table |
|
qry |
Query |
|
frm |
Form |
|
rpt |
Report |
|
mcr |
Macro |
|
bas |
Module |
|
dap |
DataAccessPage |
MS Access object variable tags :
|
Tag |
Object Type |
|
aob |
AccessObject |
|
aops |
AccessObjectProperties |
|
aop |
AccessObjectProperty |
|
app |
Application |
|
bfr |
BoundObjectFrame |
|
chk |
CheckBox |
|
cbo |
ComboBox |
|
cmd |
CommandButton |
|
ctl |
Control |
|
ctls |
Controls |
|
ocx |
CustomControl |
|
dap |
DataAccessPage |
|
dcm |
DoCmd |
|
frm |
Form |
|
fcd |
FormatCondition |
|
fcds |
FormatConditions |
|
frms |
Forms |
|
grl |
GroupLevel |
|
hyp |
Hyperlink |
|
img |
Image |
|
lbl |
Label |
|
lin |
Line |
|
lst |
ListBox |
|
bas |
Module |
|
ole |
ObjectFrame |
|
opt |
OptionButton |
|
fra |
OptionGroup (frame) |
|
brk |
PageBreak |
|
pal |
PaletteButton |
|
prps |
Properties |
|
shp |
Rectangle |
|
ref |
Reference |
|
refs |
References |
|
rpt |
Report |
|
rpts |
Reports |
|
scr |
Screen |
|
sec |
Section |
|
sfr |
SubForm |
|
srp |
SubReport |
|
tab |
TabControl |
|
txt |
TextBox |
|
tgl |
ToggleButton |
Specific object tags and suffixes for Access Database Explorer objects :
|
Tag |
Suffix |
Object Type |
|
tlkp |
Lookup |
Table (lookup) |
|
qsel |
(none) |
Query (select) |
|
qapp |
Append |
Query (append) |
|
qxtb |
XTab |
Query (crosstab) |
|
qddl |
DDL |
Query (DDL) |
|
qdel |
Delete |
Query (delete) |
|
qflt |
Filter |
Query (filter) |
|
qlkp |
Lookup |
Query (lookup) |
|
qmak |
MakeTable |
Query (make table) |
|
qspt |
PassThru |
Query (SQL pass-through) |
|
qtot |
Totals |
Query (totals) |
|
quni |
Union |
Query (union) |
|
qupd |
Update |
Query (update) |
|
fdlg |
Dlg |
Form (dialog) |
|
fmnu |
Mnu |
Form (menu) |
|
fmsg |
Msg |
Form (message) |
|
fsfr |
SubForm |
Form (subform) |
|
rsrp |
SubReport |
Form (subreport) |
|
mmnu |
Mnu |
Macro (menu) |