Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / December 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
compound primary key versus autonumber31 Dec 2005 21:03 GMT11
I'm creating a table to hold conference call minutes.  Each call must
have exactly one Study, exactly one CallType, and exactly one CallDate.
I'm torn between two designs.  Do I use a three-field composite primary
key or do I create a CallID Autonumber as PK and add a composite ...
Dividing table31 Dec 2005 16:06 GMT8
I have a tech inventory database.  It has one table with about 50 fields on
it.  The first field is "item".  ITEMS include computers, software, servers,
etc.  Can a query include a field like "item" multiple times?  I'm having
difficulty creating such a query and I'm wondering if ...
Table design for School Registration system31 Dec 2005 12:36 GMT1
I was wondering if someone could help me a bit here. Im trying to
desing an electronic register system for a school. In terms of the
table design, I obviously need a Student Details table with such
attributes as ID, FNAME, SNAME, Age, Tutor Group, Class, Dependant.
how to create a multi-part IF statement31 Dec 2005 12:03 GMT6
In an Access database form I have a drop down field that has three possible
choices. I want to create a calculated field with an IF statement that says
if choice#1 display "CHOICE#1", if choice#2 display "CHOICE#2", if choice#3
display "CHOICE#3" otherwise leave this space empty.
EXCEL31 Dec 2005 06:13 GMT5
HOW DO I GET CELLS TO EQUAVAL TIME?  AS IN 2:00PM + 6:45PM = 4.75 HRS.
?is my table design poor?31 Dec 2005 04:41 GMT5
I need to create a database to track employee movement (new & terminate). I m
afraid I have poor table design, which cause me to supplement many queries to
prepare monthly report. Would appreciate comment & suggestion on my table
design
delete query will not work with tables joined in the query31 Dec 2005 03:26 GMT6
We have two tables in a query and joined on ID for a one time data project
and we need to delete some records from one of the tables. We are using the
other table to identify our records to be deleted. Our delete query won't
allow records to be deleted. We get the error message ...
How can I create a Field that gets a value from a calculation?30 Dec 2005 23:56 GMT2
I have created a database, there is two fields Minutes and Hours, I wish the
Hours field to perform a calculation of Minutes/60 and automatically get the
value, how can i achieve this?
Referential Integrity30 Dec 2005 21:09 GMT6
I have three tables that I am trying to build relationships for:
Employee Table: which has Name,Address, and EquipNum with EmpID as the
primarty key.
Equipment Table: which has CompCode with EquipNum as its primary key
Can Time fields be added to show total?30 Dec 2005 20:37 GMT7
I have two time fields a STime and ETime.  I need them to add together to
show a total number of hrs in a separate field.  Can this be done?
Signature

Thank you!!

Access should provide for relative path links to tables.30 Dec 2005 13:24 GMT2
Currently, linking tables creates an absolute path to the external tables.
I would like to create relative path links to external tables so that if
drive letters are changed, for example, it is not necessary to relink the
tables using the Linked Table Manager.
creating response card30 Dec 2005 08:20 GMT1
I have created my personal wedding invites and I am trying to take the one
complete ready to print response card, and wondering how I make it two per 1
sheet. Works/Word Processor. Can someone help?
electronic orders30 Dec 2005 05:14 GMT1
i'm student and i need to make database for electronic orders so i'm asking for help. what tables are needed and their relationships?
tnx in advance
--------------=  Posted using GrabIt  =----------------
------=  Binary Usenet downloading made easy =---------
Access 2003, autonumbers30 Dec 2005 01:47 GMT21
I've been trying to design an Access database for my coin collection.  I've
been at it since 01, but that doesn't matter, does it.  I can set the
autonumber to work for the alternate country names, so filtering is easier.  
I'm having trouble being able to link the autonumber for ...
Importing data in to an Access table.29 Dec 2005 23:24 GMT3
I am importing data from a linked table in to an Access table.
I am using queries to do this.
the Linked Table is named Source_Table
the Access Table is named Target_Table
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 November, 2005
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.