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 (3)

---

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

.

__,_._,___