Re: [MS_AccessPros] Access Database schema type question

 

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: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

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.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___