I need a database created. I have submitted a word doc that lays out the tables to be created along with the datatypes. The finshed product show be sentto me so I can easily install it on my Server. I am told that would be restoring a backup you can let me know how you will do this.
So your price should be to create the database and whatwever I need to install it on my server.
Let me know if you have any questions.
Data types are funny under SQL vs Access. Here are some common ones you need to know.
*************
All ID fields will be an autonumber
Autonumber ??" data type is INT, but you’ll need to set the INDENTITY SPECIFICATION. Is Identity = YES / Identity Increment = 1 / Identity Seed = 1 (this will be in the column properties at the bottom)
Text ??" use nvarchar(x) x= 20, 50, etc. (whatever length you need)
Decimal ??" use numeric (12, 2) 12 places, 2 decimal ??" I use this for currency or anything with decimals
Date/Time ??" use datetime
Memo ??" use ntext
Binary ??" YES/No ??" use bit, set the default value or Binding (see General under the column properties) to ((0)) ??" false or ((1)) for true Also Allow Nullls = NO
## Deliverables
See the attached doc outlining the database to be created.