View Full Version : Theory and practice of database design


Pages : 1 [2] 3

  1. How to secure Tables and Queries from those with know hows?
  2. Need help/input with database design
  3. logical data model help
  4. (Triple) Compound Key
  5. Multi user Database - sizing issues
  6. Very large number of users - options?
  7. Is adding a new table/column to mature database bad?
  8. Analyzing complex relationships: How to?
  9. Many to Many Relationships
  10. relationships disappearing
  11. Access to Output into Word
  12. How to select non-entries
  13. from chaos
  14. Table of attributes and grouping of attributes thereof
  15. normalization question
  16. Advice on database design for complex questionnaire
  17. Build a Database
  18. Multi Price Products
  19. Design of Tables for Rosters
  20. Stumped - How do I create infirmary tracking system?
  21. Set up users and password
  22. 5th Normal Form Applied
  23. Questionnaire Table Design
  24. ERD creation help
  25. RI to more than one table
  26. Access' Source Control with TFS???
  27. Tables relationship - a bit challenging!
  28. Tennis League
  29. Multi user switchboard access
  30. User access setup
  31. Splitting databases
  32. What would your approach be. Multi-user, no network.
  33. Using Access Objects vs. Pure VBA Code
  34. Do you go beyond 3rd Normal Form? Would you?
  35. New to multiple users
  36. Default records tables design
  37. Setting up a many to one DB
  38. Switchboard glitches and others
  39. 3 Part Compound Key
  40. Advice Sought on Best Practice for Database Construction
  41. Recordset Problems..I think
  42. Trying to plan out a db. Plan is attached. Advice welcome.
  43. Is there a best way to keep track of multiple edits to records?
  44. DSN File Required for Linked Table Front-end Access?
  45. Outlook "Task" Functionality in an Access DB
  46. Multi-user database on server with no access
  47. Merging cells in Access
  48. Theory and Implimentation
  49. Tracking the query that created a table
  50. Help in desinging an access db that will act as a front end to an SQL server table
  51. How do I create a stand alone application with Access
  52. Timesheet Database
  53. Job Report Database
  54. Datbase design
  55. guery by form to search in database
  56. hide the button afte click on it
  57. absolute position of a recordset after deletaion a record
  58. Security and record locking
  59. how to filter the form with VBA without Enter Parameter Value popup
  60. Tables
  61. Is there a "right" way to store data for a treeview control?
  62. how to link this tables so it will work?
  63. One Field, or multiple fields?
  64. Small Library Project - Design Advice?
  65. A specific type of Database
  66. Table Refresh
  67. Receipt/invoice database
  68. Application efficiency
  69. Hi i'm new, need help on a db
  70. Suggestions on design/structure
  71. Constants, one table or many?
  72. Relationships problem
  73. Order/ Invoice Design Problem
  74. Theoretical Puzzle for 2008
  75. Distributing my database?
  76. Looking for Suggestions - how to create unique updatable recordset?
  77. Recipe Data modal (w/ pic)
  78. I want make ERD for my Oracle Project , help me plz
  79. Help in creating database
  80. recipes and weight conversions
  81. Two combobox fields take information from same table
  82. Estimation database - Structural help needed
  83. Tables correct
  84. Relational Database System
  85. Problem convert from MySQL to Access
  86. Multi-user database
  87. Bitten off more than I could chew (i.e. design help!)
  88. Sequential data
  89. Databse structure plan: can you point me in the right direction?
  90. table correct
  91. Cannot run custom ReplicationConflictFunction
  92. one app or many?
  93. Database Design simple FAQ
  94. Basic access help ASAP!!
  95. Student Database Design
  96. database structure
  97. Tracking mulitple time variables per record
  98. Booking System Problem
  99. How to pull information effectively from a GIS system
  100. Manual DB splitting
  101. help with a DAP
  102. table record design
  103. Inventory Database needed for School District...please help!
  104. Tag Cloud
  105. Using a table twice
  106. Normalization Help
  107. Help with relationships and design
  108. Need Help With Database
  109. Calculated Values
  110. Back end and Front End
  111. Lease Refresh and populating other tabs
  112. car hire firm e-r
  113. Newbie ? on Database Design and Import
  114. Relationship Example
  115. Building Database
  116. 1:m
  117. Time Count - > 24 h
  118. access invoicing database
  119. Help in Database design
  120. Spread data amongst users
  121. A Starter's Doubt
  122. Academic vs practical design question
  123. Do you see normalisation as mandatory?
  124. Tabledef, querydef, recordset
  125. Comments on DB Redesign?
  126. problem with Locking file
  127. Importing Large Table Causes Disk Error
  128. What types of normalisation are there?
  129. Suggestions for Improvement
  130. Database Cluster possibilities
  131. Scoping a Dabatabase - How do I estimate time for development?
  132. Access database response times
  133. Medium Size Database Design Help - Mainly Key Help
  134. ER Diagram - Relational Schema
  135. Removing the Ribbon 07
  136. Client Table and Input Form
  137. Best ways to update date
  138. VBA Timing Question...
  139. Update database
  140. Marketing Database Design Help
  141. Need Help in database design...
  142. Manufacturing Quotes
  143. FrontEnd BackEnd
  144. Data that varies (Prices)
  145. How to go about my database
  146. Many-to-Many Relationship to same table
  147. Use of Connections
  148. Conceptualizing and Executing a Complicated Database
  149. Advice on my database design?
  150. Normalizing Sage linked tables
  151. Stock control program
  152. Migrating from Access to SQL Server
  153. combining 2 databases
  154. Adding old Data to new DB
  155. Help with relational database for a TV station
  156. Database design issues
  157. Best way to share a database?
  158. Extraction, Transform, Load (ETL)
  159. data dictionary
  160. Linking Access to Webpage
  161. Synchronizing databases - which method is better?
  162. Directory Tree View
  163. m:n relationship - new pk for connecting table
  164. Reserved Words Case Sensitive?
  165. Good Tech-Ed video
  166. Relationships
  167. Is MS Access the right programme to use?
  168. Improving performance of database and correct design
  169. Yes/No Data Type vs. Indexed Lookup Fields
  170. ticketing system with CRM running SQL Server
  171. Generally - Queries vs Reports/Forms
  172. Help with structure plz :)
  173. Inventory help on workaround
  174. Replication?
  175. Database Structure Help
  176. Structure to record a football tournament
  177. not sure how to normalize my db
  178. Help needed with Renting Database
  179. First step to design Database?
  180. Table Structure?
  181. Relational Database Modelling Question
  182. Help - Error making an MDE?
  183. Value List Table vs. Static List for Drop-Downs
  184. ADO vs SQL Insert
  185. One company has bought another
  186. Simulating Access Database as .Exe
  187. DB Design ?
  188. trying to understand design from 1NF to 3NF
  189. Suggestions for improvement of my db
  190. Mike & George's normalization exercise
  191. Access and RDBMS Backend: Functionalities & Extensions
  192. table or extra field
  193. Critique, advice, help, what have you...
  194. Database Speed on Network
  195. Calendar/Schedule/Date Picker Project Design Structure
  196. Standards and conventions!
  197. Enforce referential integrity
  198. Can Sap Bi Complement Acc--sql
  199. Organising a Database Window
  200. When 1 records "relates" to another in same table
  201. Creating New MDB, easily upsizeable to SQL Server
  202. lookup question ("lookup column" or "type in the values that I want")
  203. Beginning Design
  204. Corruption : What actually happens
  205. DB design problem
  206. Design Suggestions Please
  207. Distributing work to user
  208. How to handle approved data
  209. Will my database work?
  210. Starting my first database.. Pointers for this situation?
  211. Properties and Tenants Database
  212. Sharing a many side table with more than one one-side tables
  213. Confused on how to structure...please help!
  214. One to many relationship
  215. am I on the right track? - attendance database
  216. Making Normalization seem normal
  217. ?junction table? Sales_Items, Item_Types, and Menus: How to put this together?
  218. forms, totals, and speed
  219. More structure ?s
  220. Access to SQL help
  221. Replicas/ Synchronization.
  222. Redesigning the database at work
  223. Access noob - need help Normalizing a database to 3NF, did I do it rite?
  224. Link Excel to Access DB problem,Office 2007
  225. Database design query
  226. Time Calculations
  227. How to import Excel to Access
  228. Week No Design
  229. Problems normalising some data
  230. Problem relating to data normalisation
  231. Using Treeview to display hyperlinks to forms
  232. Access Editions made by only creator/password
  233. Normalisation and Relationships problem
  234. make my database web based
  235. Budget Forecast project
  236. Attendance Tracking
  237. A database for generating and running cmdline batches
  238. An insurance database
  239. Multiple Forms data Entry
  240. Sample Survey?
  241. Beginner - help with design/relationships
  242. Stock Usage And Sales with Price Changes
  243. Building a database, relationships and tables from a text file??
  244. Immediate help needed for an Access beginner!
  245. Blog search tags design
  246. Database design with "nested" tables
  247. Help with a basic database design
  248. Are my relationships correct?
  249. best way to handle yes/no fields
  250. Why do DB-s sometimes have "extra" tables