PDA

View Full Version : Theory and practice of database design

Pages : [1] 2
  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. Hotel Reservation (booking) database in Microsoft Access
  87. Database Design Question
  88. Simple inventory tracking database.
  89. In a muddle (Relationships)
  90. When a supplier is also a customer.....
  91. Database club bookings project help
  92. Is this a good structure?
  93. Proper Relationships Design
  94. Please help with this DB design...
  95. Quick help
  96. Developer best practices
  97. LookUp? What Do I Use Instead?
  98. Use of Access Queries, Best Approach
  99. Help needed in designing a database
  100. need help in correcting a design mistake
  101. Combo box, Form design Question
  102. cutting/processing
  103. Problem witn the code
  104. Emailing reports
  105. Simply can't wrap head around certain design.
  106. E-room alternative
  107. Don't know what to do next?
  108. Formula 1 Database
  109. Relationship question
  110. Noob design question
  111. History problem........
  112. Development contract
  113. Lock out
  114. Newbie : many2many advice needed...
  115. Making life easier
  116. Database Problems
  117. Anyone here designed an HR Database?
  118. Help: Database Design For Music Lesson tracking system
  119. More than one databases merged to one.(key issue)
  120. Referential Integrity with intermediate table
  121. Non-uniqueness problem - Please comment on my ENERGY database design …
  122. Relationship Question
  123. Transfer info from List Box to Text Box?
  124. Database Design for Testing Schedule
  125. Stock Control Database
  126. Many to Many
  127. Student Attendance
  128. Normalization problems
  129. Halfwit Newbie: Normalising and linking staff database
  130. EPoS System - Help!
  131. Silly relationship window display problem!
  132. Design: storing (external?) query criteria in table to be summarized by main query??
  133. Electronic Window Cards
  134. Is there a way to have Title Caps?
  135. Timesheet Design
  136. Help - Initial Design
  137. Question regarding designing a status report
  138. Normalizing & Data Arranging
  139. Normalization question
  140. many-many-many
  141. replicas and synchronizing
  142. Design for membership db
  143. Design with forms and reports
  144. Please tell me if i'm on mark with structure
  145. problem opening two copies of the same database
  146. What is the best way to represent a One to many in forms
  147. Lost relationships after split in BE
  148. Stock control syste, question.
  149. Little M:M problem...
  150. Use Access recordsource or DAO?
  151. Starting my Next Database - Need Opinions?
  152. Best way to set up SQL DB Backend?
  153. Need Help With A Database Design
  154. Best Practice Performance and Structure
  155. The FE BE argument for multiple users cannot be used in this problem
  156. Kill the hidden form trick
  157. Need some help tracking hours
  158. Relationship advice sought
  159. Cancel or undo mainform and subform
  160. Data editing control
  161. Creating a dynamic form?
  162. Cemetery DB design Guidance
  163. Making spreadsheets work in MS Access
  164. Allowing users to link to back-end database
  165. How to Persist a Recordset?
  166. Referential integrity - help required
  167. Bank Statement type form
  168. Where to put combo boxes and which field to save in table?
  169. A better way than a listbox?
  170. Multiple Tables = Reduced Performance?
  171. Error 3048: Cannot open any more databases
  172. Production Database Performance and Design
  173. Invalid Field Definition - Unable to set up cascade update
  174. Possibly setting up DB wrong?
  175. Custom login
  176. Your Esteemed Help, Please?
  177. Normalization Explained
  178. Database Design - Entities in Access
  179. Meaningless vs Meaningful Primary Keys
  180. Help, guidance or just general advice sought
  181. Is Auto Number PK more likey to produce Locking errors in a multiuser db
  182. FE/BE Question
  183. Candidate Key Using All Attributes
  184. Need Help to design a registration database..
  185. Formulas about Access
  186. Page to Explorer
  187. Help with table structure of kennel database
  188. "Visitors Book" Style Database
  189. Food for thought on indices
  190. remote sites, secure data
  191. Combining data into a single field
  192. way too many tables
  193. Access was unable to create MDE database
  194. Counterfiet Merchandise Tracking system
  195. CRM system - help with design
  196. FE/BE, MDE, What should I use?
  197. 2 continuous subforms
  198. RichText Formatting (RTF) vs HTML
  199. Scedule jobs
  200. Audit database design
  201. Two FE link to a master FE
  202. Access Levels - Security
  203. Relationship Question - I think??
  204. I think this may be a linking problem
  205. Advice needed
  206. Building a new database built on a spreadsheet design structure... help appreciated.
  207. FE/BE Database Locking
  208. Mail Inventory
  209. New project - Stuggling to get head round design
  210. Design Question(s)
  211. diary system
  212. Business FE/BE Help
  213. Too Late to Make Changes?
  214. MDB to MDE Conversion
  215. difference between candidate key and primary key?
  216. diary system ( access 2007)
  217. design advice for training session tracking
  218. Dividing and Relating My Data
  219. Design Issue: Resolving a many-to-many relationship
  220. A single company can be calle numours names
  221. multiple many-to-many relationships
  222. subtraction query
  223. Which is Better?
  224. Normalising Data?
  225. Linking
  226. Controling user access to ceratin areas of database
  227. Speed of my database
  228. Survey Table Structure
  229. Need Help With Database!!!!!
  230. Yes/No ....... NO!!!!
  231. Design question
  232. Looking For Design Confirmation
  233. How to safely deploy an access application
  234. Need a bit of help with my database
  235. Calculations dependent on previous record
  236. Back Up Suggestions
  237. Best way to manage time-dependent calculated data?
  238. Many to Many form setup
  239. Limited to same usergroup per workstation?
  240. Monitoring of Groups/Users modifications
  241. split/link/synchronize what the deal
  242. LETS Database
  243. Nulls: Should it ever be meaningful?
  244. Feedback on Complaint Database
  245. DB Design Conundrum
  246. Relationship Problem
  247. Many-to-many tables
  248. Transactions and Linked Tables
  249. Table desing problem
  250. Levels of Abstraction and Database Design