Microsoft access workspace

For general feedback on the Resource Center or content, please submit your feedback to your Microsoft representative. For specific requests and content updates regarding the Services Hub, contact our Support Team to submit a case. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Open in new tab. Sign me up Stay informed about special deals, the latest products, events, and more from Microsoft Store.

Sign up. Thank you! Talk to an expert. DirectX 10 graphics card for graphics hardware acceleration for PC. It also needs a Primary Key, which would most likely be the AutoNumber datatype. This table has at least two fields, and probably several others. You will also, no doubt, need fields in the Drop table for DateDelivered, QuantityDropped, and anything else pertinent to each Drop. You know what you might need here. Now, you can enter as many leaflets as you want for each customer in the Drop table, and as many Customers as you want in the Drop table.

Just make sure you include both Foreign Keys in each Drop record. The way this is usually put into an interface--well, the most appropriate method--is to use a main form bound to one of the two source tables, either leaflets or customers, whichever is primary in your marketing scheme.

Then, in that form, you place a subform bound to the junction table, tblDrop. This allows you to select a leaflet in the main form, and in the subform select as many customers as needed to complete an order for Drops.

You'll find examples of this approach in many places. Ken Sheridan has one in his public OneDrive. Integrate data between Access and line-of-business apps using the Access connector library to generate aggregated visuals and insights in the familiar Access interface.

Microsoft Access is available for PC only. Learn more. The most up-to-date version of Microsoft Access is always available with a Microsoft subscription. Microsoft Access is the latest version of Access available as a one-time purchase. Access is compatible with Windows