[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: luvmymelody@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

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

.

__,_._,___