Looking to create an Access database using 2007 version to keep track of projects for my company. It will be used by 4-6 users. Those users need to be able to create new projects in Access that contain information about a project (Project Name, Phase, Bid Date, Bid Time, Bidders, Price, Manufacturer Selected, Notes, etc).
That information will be manually typed in, picked from a drop down list, or have a drop down list with multiple selections allowed for one cell. I looked at the Projects template, and that was close to what I need, but it really has more than I need with employee lists, etc. This makes it difficult to edit because Microsoft packed so much into that template. I'm just looking for a basic table with one row per project and each column having the Project Name, Phase, Bid Date, Bid Time, etc listed in the picture. On the Projects template, when a "new" project is started, the Form pops up to enter in information about a new project.
The Notes are on that pop up Form and I would need to enter notes about a project in there as the project progresses. All of the editing can be done in that pop-up form if the tables need to be locked for a split database. I want to be able to create reports or even just sort the jobs based on price, only view jobs that are Quoted (jobs that were bid but have not been awarded yet), and other similar reports/sorting capabilities.
I know I need to split the database into a Front End (FE) and Back End (BE), what info would be split? Would the Form that creates a new job be on the FE, and the table of all of the projects be on the BE? All users need to be able to create new projects, but also be able to edit the old projects also. What happens if two people try to access a project at the same time? Do they need to access old projects in the Form that opens a new window instead of editing the table?
Basically, I'm wondering, will Access work for my application?