PDA

View Full Version : Theory and practice of database design

Pages : [1] 2 3 4 5
  1. Survey Databases
  2. Working on design tutorial
  3. Implementing Surrogate Keys In Access
  4. The Primordial Spark; Information Management Evolution
  5. Where does VBA comes in
  6. Database Documentation
  7. Multiple users, where to start/learn more?
  8. Database REpair
  9. BE/FE vs Stand alone work
  10. Ideas...
  11. Tables
  12. Relationship window and relationships
  13. E-R Diagram
  14. Automate Email treatment : Kick Off !
  15. Indexes
  16. Process flow via program table
  17. Clustered Indexes
  18. What should go into a design document for an Access application?
  19. Recap on ERD - foreign keys/relationships?
  20. Citrix
  21. Academic database multiple modules offered in multiple centre
  22. Looking for a little advice
  23. Setting up database relationships
  24. Relating tables DateTimes that have uneven times
  25. Multiple Front end for Single Back end
  26. Copying Data
  27. do I need relationships?
  28. Table Lookup or Query?
  29. Primary Keys for Static Tables needed?
  30. Attention Moderators
  31. Many to Many relationships
  32. Tree Controls Basics.
  33. database sharing problems
  34. Replicate with off site users (FTP?)
  35. Please Read
  36. Should I convert all SQL to queries?
  37. Automatic backup of the back end - can it be done
  38. Split databases and Cursors?
  39. Form printing
  40. Databases and ole objects (images)
  41. changing the primary key
  42. Front End / Back End split - where do you keep your tables?
  43. Questions on Choosing Primary keys
  44. Back end databases refering to each other
  45. relationship and autonumber prob
  46. Need to see if this will setup will work
  47. Principles of populating treeview controls
  48. One to One relationship - How?
  49. First time doing something serious in Acess
  50. Need some help/insight on structure of database
  51. Custom help file
  52. Invoice Database Feature?
  53. Table Set Up-Option Group or Linked Combo Box?
  54. Database Structure
  55. Database Help Needed Please
  56. last month / year, current month year same query
  57. Multilanguage and data redundancy
  58. Complex Staff and Weekly Rota Database Structure
  59. Relation Issue -- Really Need Your Help!!
  60. Publishing help please
  61. Table normalization
  62. Spares Tracking Advice Needed
  63. Populating field based on previous field criteria
  64. LMS design
  65. Over Normalization!
  66. Whats Your Understanding of PK FK
  67. Need Quick Help on Understanding Receipts
  68. Yes/No Answer Needed -- Dealing with Two Contract Types
  69. Front End on Network
  70. Help with Design/Structure of Database
  71. Need Help with Patient Communication Database
  72. Designing a database for a small lab
  73. Database design - car mechanic
  74. Principles of table/form design?
  75. Hotel Reservation style database HELP required!!
  76. Best way to import data on a monthly schedule
  77. Connect to Workgroup Secured .MDB
  78. Design Question: API Cookbook / Detail
  79. MDE Reports
  80. Many to Many Relationship? Should be done?
  81. Relationships' Help needed please
  82. Relationship design - is it correct?
  83. ? Database design
  84. SQL Question - Which comes first...
  85. Should I redesign?
  86. Database Design Question
  87. Simple inventory tracking database.
  88. In a muddle (Relationships)
  89. When a supplier is also a customer.....
  90. Database club bookings project help
  91. Is this a good structure?
  92. Proper Relationships Design
  93. Please help with this DB design...
  94. Quick help
  95. Developer best practices
  96. LookUp? What Do I Use Instead?
  97. Use of Access Queries, Best Approach
  98. Help needed in designing a database
  99. need help in correcting a design mistake
  100. Combo box, Form design Question
  101. cutting/processing
  102. Problem witn the code
  103. Emailing reports
  104. Simply can't wrap head around certain design.
  105. E-room alternative
  106. Don't know what to do next?
  107. Formula 1 Database
  108. Relationship question
  109. Noob design question
  110. History problem........
  111. Development contract
  112. Lock out
  113. Newbie : many2many advice needed...
  114. Making life easier
  115. Database Problems
  116. Anyone here designed an HR Database?
  117. Help: Database Design For Music Lesson tracking system
  118. More than one databases merged to one.(key issue)
  119. Referential Integrity with intermediate table
  120. Non-uniqueness problem - Please comment on my ENERGY database design …
  121. Relationship Question
  122. Transfer info from List Box to Text Box?
  123. Database Design for Testing Schedule
  124. Stock Control Database
  125. Many to Many
  126. Student Attendance
  127. Normalization problems
  128. Halfwit Newbie: Normalising and linking staff database
  129. EPoS System - Help!
  130. Silly relationship window display problem!
  131. Design: storing (external?) query criteria in table to be summarized by main query??
  132. Electronic Window Cards
  133. Is there a way to have Title Caps?
  134. Timesheet Design
  135. Help - Initial Design
  136. Question regarding designing a status report
  137. Normalizing & Data Arranging
  138. Normalization question
  139. many-many-many
  140. replicas and synchronizing
  141. Design for membership db
  142. Design with forms and reports
  143. Please tell me if i'm on mark with structure
  144. problem opening two copies of the same database
  145. What is the best way to represent a One to many in forms
  146. Lost relationships after split in BE
  147. Stock control syste, question.
  148. Little M:M problem...
  149. Use Access recordsource or DAO?
  150. Starting my Next Database - Need Opinions?
  151. Best way to set up SQL DB Backend?
  152. Need Help With A Database Design
  153. Best Practice Performance and Structure
  154. The FE BE argument for multiple users cannot be used in this problem
  155. Kill the hidden form trick
  156. Need some help tracking hours
  157. Relationship advice sought
  158. Cancel or undo mainform and subform
  159. Data editing control
  160. Creating a dynamic form?
  161. Cemetery DB design Guidance
  162. Making spreadsheets work in MS Access
  163. Allowing users to link to back-end database
  164. How to Persist a Recordset?
  165. Referential integrity - help required
  166. Bank Statement type form
  167. Where to put combo boxes and which field to save in table?
  168. A better way than a listbox?
  169. Multiple Tables = Reduced Performance?
  170. Error 3048: Cannot open any more databases
  171. Production Database Performance and Design
  172. Invalid Field Definition - Unable to set up cascade update
  173. Possibly setting up DB wrong?
  174. Custom login
  175. Your Esteemed Help, Please?
  176. Normalization Explained
  177. Database Design - Entities in Access
  178. Meaningless vs Meaningful Primary Keys
  179. Help, guidance or just general advice sought
  180. Is Auto Number PK more likey to produce Locking errors in a multiuser db
  181. FE/BE Question
  182. Candidate Key Using All Attributes
  183. Need Help to design a registration database..
  184. Formulas about Access
  185. Page to Explorer
  186. Help with table structure of kennel database
  187. "Visitors Book" Style Database
  188. Food for thought on indices
  189. remote sites, secure data
  190. Combining data into a single field
  191. way too many tables
  192. Access was unable to create MDE database
  193. Counterfiet Merchandise Tracking system
  194. CRM system - help with design
  195. FE/BE, MDE, What should I use?
  196. 2 continuous subforms
  197. RichText Formatting (RTF) vs HTML
  198. Scedule jobs
  199. Audit database design
  200. Two FE link to a master FE
  201. Access Levels - Security
  202. Relationship Question - I think??
  203. I think this may be a linking problem
  204. Advice needed
  205. Building a new database built on a spreadsheet design structure... help appreciated.
  206. FE/BE Database Locking
  207. Mail Inventory
  208. New project - Stuggling to get head round design
  209. Design Question(s)
  210. diary system
  211. Business FE/BE Help
  212. Too Late to Make Changes?
  213. MDB to MDE Conversion
  214. difference between candidate key and primary key?
  215. diary system ( access 2007)
  216. design advice for training session tracking
  217. Dividing and Relating My Data
  218. Design Issue: Resolving a many-to-many relationship
  219. A single company can be calle numours names
  220. multiple many-to-many relationships
  221. subtraction query
  222. Which is Better?
  223. Normalising Data?
  224. Linking
  225. Controling user access to ceratin areas of database
  226. Speed of my database
  227. Survey Table Structure
  228. Need Help With Database!!!!!
  229. Yes/No ....... NO!!!!
  230. Design question
  231. Looking For Design Confirmation
  232. How to safely deploy an access application
  233. Need a bit of help with my database
  234. Calculations dependent on previous record
  235. Back Up Suggestions
  236. Best way to manage time-dependent calculated data?
  237. Many to Many form setup
  238. Limited to same usergroup per workstation?
  239. Monitoring of Groups/Users modifications
  240. split/link/synchronize what the deal
  241. LETS Database
  242. Nulls: Should it ever be meaningful?
  243. Feedback on Complaint Database
  244. DB Design Conundrum
  245. Relationship Problem
  246. Many-to-many tables
  247. Transactions and Linked Tables
  248. Table desing problem
  249. Levels of Abstraction and Database Design
  250. How to secure Tables and Queries from those with know hows?