PDA

View Full Version : Theory and practice of database design

Pages : 1 2 3 [4] 5
  1. Normalizing audit log
  2. A preffered Approach in Table Design for Filtering
  3. How to correct an incorrectly-setup db
  4. handling variable object and attribute types
  5. Is it correct to store both the fks for the category and subcategory
  6. Referential Integrity
  7. Linking two different db's
  8. Normalization with tag storage
  9. Data truncated at start when written to table
  10. How do you handle data relationships where no clear relationship exists
  11. Linked Tables - path or current folder
  12. Many problems...very confused! Need help!!!
  13. Buildling A "Scheduling" Database
  14. auditing table??
  15. How do create a survey/ questionaire
  16. Tracking contacts and calls for several entities
  17. Splitting a database
  18. Examples? User ComboBox Maintenance Form
  19. Check my Relationships
  20. SQL Statement to build database
  21. converting this questionnaire into a database ?
  22. New Database Project - Advice with Design
  23. Help with attachment Database New Project
  24. Updating a BE and FE on a disconnected computer
  25. Effect of many instances of Access
  26. Training Database Assistance
  27. Database Design
  28. Virtual Delete
  29. Deploying a Runtime Database
  30. Help for a wedding list structure
  31. DATA MODELS - Check before you re-invent
  32. Normalisation of Dates
  33. Hidden Fields Access 2007
  34. Hidden Fields Access 2007 Answered
  35. Design to Avoid Repeating Addresses
  36. Issue withe Relationships and form
  37. Replication
  38. Better choice
  39. How do I distribute my DB
  40. 2 steps forward 1 back
  41. One item - one user
  42. Need to Normalize
  43. Quick Theory Question
  44. User rights acces 2003
  45. Please help with database structure
  46. Page Viewing Query
  47. Slow connection to Backend
  48. Representing conditional relationships
  49. Designing a database table structure. Advice appreciated.
  50. Composite keys... is there a better way?
  51. database normalization - question on practices of this
  52. Database Structure Question
  53. Primary Keys and Indexes
  54. Multi-Value Fields - designing tables with them.
  55. Did I Normalize this correctly?
  56. Access web page
  57. Multiple User Question
  58. Financial Modelling with Access - is the following possible?
  59. Creating multiple table relationships
  60. Survey Database... and Analyzing...
  61. New FE or control UI with VBA?
  62. Database design question
  63. Update server database from local
  64. Equipment inventory database design
  65. =fOSUserName()
  66. Association of Customers to Groups Design Considerations
  67. ER diagram bookstore
  68. Looking for table structure (Best Practice) suggestions
  69. Need help with Sql criteria and a Many to Many relationship
  70. Popup vs hidden controls for an add new
  71. Best method, lookups and bounded columns / SQL
  72. Best way to show multiple tables on one form?
  73. Relationship Advice
  74. Passing query parameters (in Tables) where the parameter varies
  75. Three Way (four?) Association Table
  76. Duplicating data (normalisation?)
  77. Philosophy: Null input to functions
  78. Disconnected Data.
  79. Front end auto update - please advice!
  80. Hopefully a simple question
  81. Package and Deploy - Using your db with the Access Runtime
  82. Need help with this question ( about E-R diagram )
  83. Table relationships - storing folders into boxes
  84. Limited Access
  85. Field Value Determines Form(s)
  86. Split Data
  87. Importing Financial Statements From Excel To Access
  88. Normal form
  89. Need simple database for stock control
  90. Making legacy system data available in Access
  91. Normalization
  92. Inventory Control Database
  93. Hungarian (Leszynski/Reddick) Naming Conventions
  94. Help with database design
  95. help
  96. Need help with Normalization please?
  97. Inventory Opinions: Union Query
  98. Advice needed on DB design
  99. User-Level security example, please review
  100. How best to manage date/milestone-specific data + applying to continuous transactions
  101. Help linking difficult data (2 system's extracts)
  102. Planning an events based app
  103. Problem with database. Rejected Records?
  104. design of investment portfolio database
  105. Multiple Hierarchies from a Single Table
  106. Relationship issues
  107. Help with New Contact Database
  108. Implicit / explicit relationships in Access
  109. Real estate/ leasing database help?
  110. Designing the Perfect User Interface
  111. Advice on schema for multiple tax rates on order management system
  112. Need some serious help please
  113. Maintaining hostoric data in DB-how?
  114. Common record for multiple items
  115. Help with a simple Update Field problem
  116. Use Access or Excel? (monthly billing)
  117. Parameter Queries verses A Matrix Form
  118. Lots of Many-Many Tables
  119. Help!!!! creative database designer wanted
  120. splitting the database
  121. Access and the Internet
  122. how to automatically generate feevoucher every month
  123. MS Access - better to have more tables or more columns?
  124. Known Network Bug in Access 2010?
  125. Access Dashboard Structure
  126. Signing using .pfx and/or .cer
  127. Concurrency Access 2007: Some Design & Implementation Questions
  128. Table or Query as the recordsource for a form
  129. Normalisation and new System Purchase.
  130. Database Design
  131. Lots of data
  132. Database Normalisation (Again)
  133. How to Hide Microsoft Access Database Design Buttons
  134. Database with 20k-40k items per day.
  135. Contact Database Relationships
  136. "offline" version and synchronisation
  137. link tables or DAO/ADO
  138. A Case for Temporary Tables in Data Entry
  139. Reliable Methodology for Offsite Data
  140. Many-to-Many Grouped into one larger table?
  141. one to many, but almost like many to many
  142. Dijunctive searches
  143. Validation, at application or at Database
  144. Active record changes when other users save their changes
  145. Database Linking To PDF Files
  146. What would be the fast way to populate fields?
  147. Highly Normalized Data and Wizards
  148. ODBC to a Security Application
  149. Order list / Receipt: Concept = OK, Implimentation = Help
  150. Want to use separate tables but how to query all later?
  151. Pulling data from other databases
  152. Database Design for data input
  153. Split database & Multiusers
  154. Designing forms - what is important?
  155. DB Design Basics
  156. The Macgyver Approach, or is it MacGruber?
  157. Entities, Attributes and Primary Keys
  158. relation and display issue....?
  159. help me in drafting a better EmployeeID coding structure
  160. Imported contacts show on table but won't show on form
  161. ER diagram question
  162. Seeking a normalization expert & coach - who's in?!
  163. Normalizing various city/county/state relationships (w/out zip)
  164. Syncing Databases
  165. Help me define the relationships
  166. Defining relationships (mm?)
  167. How many forms does your big application form have
  168. Calling a form from a referenced db
  169. DB Structure Help
  170. Basic Internal Messaging
  171. New to Access Question on Database Design
  172. Using a value or variable in a control name
  173. Suggestion for School Database Design
  174. Simple question on table design
  175. Recommended approach to storing text for dialog and prompts
  176. To Public or Not to Public
  177. Overview - relationship diagram
  178. database design for a literature review (help)
  179. Adding PK as FK to table
  180. Access Read only FE
  181. Access 2007 advice needed. Do I need a Form? Query? Both?
  182. Steps to secured database
  183. Adding Employees to Sales that are completed
  184. Access DateDiff
  185. Simple Inventory Plastic Barrel Different capacity with Logo Printed
  186. Normalize existing table
  187. need help in ERD
  188. If you need to post a picture or database before 10 posts...
  189. Going round in circles
  190. how to minus specific product.....
  191. Lookup tables in Access
  192. Help in setup please
  193. Call Center data
  194. Many-many Relationship on a Form
  195. Notation of Business Rules
  196. Best Mail List/Merge Strategy
  197. Lock Down past years records so they cannot be changed
  198. Adding in an appointment system?
  199. Basic Q: Having 'total' amount in table updated from subtable?
  200. How To Secure Access Database
  201. Access or other tools?
  202. Data Optimization
  203. is this Entity Relationship diagram correct?
  204. Data in Access, uses Excel charts for a Word report, how to automate?
  205. Questionnaire with multiple data types
  206. how to correctly normalize table structure of my database
  207. Bouncing Recordnumbers
  208. Application Level Presentation
  209. Upgrade file from mdb (2000) to accdb???
  210. Dynamically created buttons
  211. Question about questionnaires
  212. Use of multiple copies of the same database within the database itself
  213. addresses. Single fileld v multiple fields
  214. Scanned Images Database
  215. Establishing a many to many relationship and writing data to a “bridge” table
  216. set default value of field the value of other table field value
  217. set default value of field the value of other table field value
  218. Security in Access 2010
  219. Revision Control
  220. Time Sheet Pairs
  221. Working with remote networks?
  222. Database Normalization
  223. Using Attachment field to store graphics
  224. Map Making
  225. Table Design
  226. Resource booking database
  227. REST and Database Design
  228. Advise on Structure and Relationships
  229. Database for tools calibration
  230. Beginner assistance
  231. Blocking of historical data before changes
  232. The effect of network servers and common drives on DB
  233. Unbound ole object
  234. Best structure for clients and enquiries
  235. Multi-Entity Document Archiving Data Model
  236. What would people recommend? Form or Report?
  237. Is this on the right lines
  238. Database Design Questions
  239. Help designing maintenance database
  240. struggling designing my layout.
  241. Filter Vs Queries or both
  242. Alternative "modular"database design: wise to do so?
  243. How to query large table for matching beginning characters?
  244. Will it need to be unbound?
  245. Is Access right for me?
  246. help me in normalization
  247. Survey Database Design - hit a snag
  248. Which field of table is suitable for primary key?
  249. Constants Table
  250. Make the database work correctly on any PC