ORCAD Building an Access database

Just entered a small company, received the first Circuit design case is from scratch, hard not to say, the key is so not rigorous, prone to error, so, the problem, can start from scratch to build a similar to the previous company's database, management schematic package, PCB packaging and specification book!

Thanks to OrCAD's help document, is simply a hands-on teaching Ah, writing is very detailed, in addition to a little bit of English is not too accustomed to see, there is a small problem when really can not rule out whether it is the other computer settings in addition to the problem, this is a bit troublesome.

Here's the day's busy today:

1, the first of course is to see the Help manual, cis that part, do not have to look at, but must have a concept of the general process;

2, with hands-on teaching manual, paddle, where to find a usable database software, Access, not the second choice, MS Office suite part, off-the-shelf, impression than what mysql,oracle what simple, the key is, OrCAD gave the model is just the use of it;

3, to build a database, then what to put in the library, the original is to have a few to tidy up, but since the time to establish a database, you have to take things into thoughtful and long-term, convenient later, part number, part type, schematic part, Value and other items are mandatory, there are datasheet, PCB footprint, description, vender, and so is also necessary, then, the template copy over use it, simple, not wrong;

3, there is one thing can be simple and complex, set up a set of naming management, which in the original to the PCB footprint named when the review of a lot of information, and finally, self-organized a set of

First, resistors, capacitors, inductors and LEDs are directly the simplest form of R0402

Second, two-row outward pin is named Pin-packagename-bodywide

Three, not to the foot but also not BGA packaging named Pin-packagename-bodywide ' x ' bodylength

Four, BGA named Pin-bga-pindistance-bodywide ' x ' bodylength

V. Other named Type-value

4, to the part number named when I refer to the original company 353 the name of the method, simplify a little, with a 252 material number, how I was a small company, right-. -

Xx-xxxxx-xx

1x-Main IC

xxxxx-start at 16. Representing the year, and then starting from 1 onwards, that is, 16001 is the first main IC in the library.

2x-Peripheral ICS

Ditto

3x-Resistor

Xxxxx-the first two take the general dimension description of the last two bits, the latter three bits with universal resistance size general description of the three-digit 02102 means 1 K 0402 of the resistor

4x-Capacitor

Ditto

5x-Other

xxxxx-with IC

5, the following is in accordance with the hands-on teaching documents in a step-by-step configuration is good, in fact, I have not configured well, spent a whole day-. -

-Open the 32-bit ODBC source configuration settings for Windows and join the established database

-Open the CIS configure settings in the OrCAD, select New, follow the wizard step down settings, configure the database and CIS communication rules

6, there is No 6, the configuration of two, is not very simple, actually, read the English manual you know-. -

ORCAD Building an Access database