Rabu, 31 Januari 2018

Re: [MS_AccessPros] Access Database schema type question

 

Thank You Duane. it helped a lot.

Jim Wagner


On ‎Wednesday‎, ‎January‎ ‎31‎, ‎2018‎ ‎10‎:‎33‎:‎13‎ ‎AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

Sorry Jim. Here is some additional information based on my experience. Most of us have our own system for naming and they are all correct (just mine is a little more correct).

I typically prefix my query names with the type:
qsel   Select
qgrp   Totals
qxtb   Crosstab
qupd   Update
qmak   Make table
qdel   Delete

For subforms and reports I use sfrm and srpt. 

I will also abbreviate Supervisor to Sup and Employee to Emp. Maybe use "Accr" for Accruals. Be consistent. There is nothing I hate more in projects than documenting but it is crucial if you want to make sure your application can be maintained by you and others.

All of my field names in a table are prefixed with the three letters from the table name:

tblEmployees
empEmpID   autonumber primary key
empFirstName
empLastName
empCellPhone
empHireDate
empLastUpdate
empLastUpdateEmpID


tblDepartments
dptDptID
dptTitle
dptDescription
dptLastUpdate
dptLastUpdateEmpID

Duane Hookom



From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, January 31, 2018 8:01 AM
To: Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Access Database schema type question
 


Duane,

Thank You. I was looking to get some advice more on others use of an object schema to name the objects with a coordinating naming convention to identify them more easily. My boss used to put numbers to identify a process... But as soon as an object was added she would have to put "a" or "b" to put them in order. It became unmanageable.

Jim Wagner


On ‎Wednesday‎, ‎January‎ ‎31‎, ‎2018‎ ‎01‎:‎57‎:‎44‎ ‎AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

Jim,


I would work with a copy and use one of the Access find and replace tools. One of these could save you tons of time and frustrations. Search the web for "Access find and replace tools". 


Regards,

Duane




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, January 30, 2018 9:26 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Access Database schema type question
 


Hello all,


Not sure if I have this correct but I am rebuilding a database that has about 50 objects, many related to 1 topic for Accruals for Employees. I was thinking of renaming the objects with a naming convention that will better identify the objects related to Accruals. Right now the objects seem to be all over the place. mostly because we moved many objects from another database that had Accruals also. we are trying to get all of the objects into a database with other related information.

My questions are is it worth it or is there are a naming convention that has worked for others? The Database also has Scheduling data, Timesheet data and employee reports.


I was thinking of for example of the following


qryAccruals_UpdateVACAccrual

qryAccruals_UpdateCOMPAccrual

tblAccruals_AccrualsForReport

qryAccruals_DeleteSupvListTempTable

qryAccruals_AppendtblSupervisorListTotblSupvTemptbl

rptAccruals_AccrualSummary


What are the thoughts of the group?


Thank You


Jim Wagner





__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar