I've redesigned a database that's primary purpose is to assign batch numbers to users. There are two main forms, an Assign Batch form and a Delete Batch...

I have a very simple form in Access 2000 that a user can enter information about IV Pumps and keep track of them. They enter the patient, facility, serial #,...

I have written an app for my daughter in C# with an Access 12 database holding the data. It creates html pages for a website based on details provided by...

I'm debating (with myself) whether or not to archive records in a database and would like to hear opinions on what others may have done, or what others may...

I have a series of many-to-may relationships that can be traced in a circular fashion - is this likely to cause problems?

Again, my small backpackers hostel located in Panama is keeping my wheels spinning. Now I am beginning to wonder. Is it so bad to have duplicates in my...

Hello folks. I'm relatively new to MS Access and I'm having a Dickens of a time figuring out whether materialized views are supported in MS Access, or even...

I read somewhere that *ALL* tables should have a primary key, but no explanation was given as to why or what benefit it serves. After looking around for an...

Are Primary keys needed in child tables? How important is having a defined primary key in child tables? Here is my dilemma; I have 35 groups running around...

Hi, This is just a point of curiosity for me. I realize that Access works the Access works. Does any one know if the rows are stored in the database as...

Are they just the tool of a false god? I split my database, and all I got was this lousy backend. Front End on each user's C:\ Drive. Back End on the...

Using either Infopath or Access---I need a template that is designed for church membership that includes personal contact information and join dates, etc.

I want to create two tables from my source data. The source data contains patient registrations and encounters based on date and time of registration. I want...

I've switched from Access 2003 to Access 2007, and am designing a new database. I normally open several tables, queries, forms, or reports, in design view,...

I need to design a database that keeps information about documents. Each document will consist of multiple topics. Each topic will have attributes. A given...

Art Gallery Database: I have built the following: Member table storing member data: MemberId (autonumber), FirstName, LastName, address, media, commissions?,...

I have a field Memo, named Art and I would like to insert a date so that when my users see the memo field in a form they will also see the embedded date field...

I’ve been working with this table for some time now that has about 15 or so fields in it which I know is way too many. For the life of me, I would like to...

Hi experts, I'm porting a database developed in Access to a Web site. In Access, I define a number of queries that are then used in other queries just as...

Hello, I have a relational database well written if I do say so myself :) About 75,000 records in one table, linked to an examinations table with details of...