Re: Can I duplicate a record in Access?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Access is inherently multi-user, though the Jet database engine it uses
by default is not suitable for large numbers of simultaneous users and
requires reliable LAN connections. All you need do is to "split" the
database into a back end - on the server - containing the data tables,
and a front end containing all the forms, reports, queries and the rest
of the user interface, with a copy on each workstation.

The practical number of simultaneous users depends on the complexity of
the database and what the users are doing. Heavy data entry usually
places the biggest strain; if you have more than a handful of full-time
data entry clerks it's worth looking at a more powerful back end than
Jet (such as MSDE/SQL Server), though Access will still be fine for the
front end.

For the actual design, take a good look at the Northwind sample
database, which has customers, products, orders, etc.



On Tue, 7 Jun 2005 15:41:01 -0700, "GypsyRose31299"
<GypsyRose31299@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>The company I work for is considering building a database to control our
>orders. I am looking into using Access, but have a few questions to see if
>Access can meet our needs.
>
>I've worked in Access before (in the data entry side) but am new to building
>a database. I've designed forms in Outlook and I use the formulas and whatnot
>in Excel.
>
>>From the research I've done, I've concluded that I'd need to have a table
>for Customer Records, Vendor Records, and Orders, possibly Rates.
>
>The Customers and Vendors all have unique codes to distinguish between them.
>The Orders will also have a unique numbering system.
>
>My first question...It looks like Access can be multi-user, but does it
>require additional software? We are set up on a server but I'm not sure about
>the specifics.
>
>Next, we need to be able to use a "Duplicate" function for ease in entering
>new orders...They would have a unique order number, and the PO numbers, and
>vendors associated with them can/will change. Is this possible? Is it
>something an inexperienced user can figure out without too much difficulty?
>
>Thanks in advance for any advice or insight!

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

Relevant Pages

  • Re: OT: Database application
    ... I'd like to automate some of the ... spreadsheets and/or have some simple database applications...you know, ... other DOS based database managers. ... data entry, data query, and analysis software. ...
    (rec.crafts.metalworking)
  • Re: formatting columns
    ... This works for columns either to the left or right of the cell to be copied. ... >> I am preparing to set up a database in Access2002. ... >> have the time to set up the Access database so I must do ... >> my data entry into Excel. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Forms do not show
    ... Data Entry? ... Controls do or do not have Control Source. ... and Enabled properties. ... Did you have the Database Window open, highlight the form, and then click ...
    (comp.databases.ms-access)
  • Re: Where to start
    ... It would be possible to use one form for the data entry of all the hymn assignments. ... This would involve making a query based on the LitEvents and Assignments tables, and basing the form on this query. ... The ability to use a form/subform structure for data management is one of the key benefits to using a database like Access. ...
    (microsoft.public.access.gettingstarted)
  • Re: Data Capture using Word on PPC
    ... Data Entry, nothing is found. ... Please see the Pocket PC Mag Expert Blog at ... for a REAL form-based database application. ...
    (microsoft.public.pocketpc)