Create a database

Question

Hi,

I am trying to create a database/list/form, where ultimately I have a list of clients details (A,B,C, etc) and the respective items purchased by each client listed below it. Every time I want to key in new items purchased, I can do it by the client name, key in the items details without keying the redundant details ie the client details, address, names etc.

I have no data to key in at the moment, only those headings needed to create the list, so that others can key in.

Any idea what app/software I can create this?

Thank you.

Naili

Answer 1

Dear FarhanahN,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

Except what Rohnski2 mentioned, if you want a cloud solution for other company members or the company members who are working in other regions, I recommend you use Microsoft Lists or SharePoint Online Lists.

You can create list content types with each clients' information for example, create content type A for client A, create content type B for client B and add the site column such as Client Information A with the default value to content type A and add the site column such as Client Information B with the default value to content type B.

Then add the two content types to the SharePoint Online list.

For your reference: Create or customize a content type (the article is also applied to the modern content type experience and SharePoint Online)

Result:

@Rohnski2, thanks for sharing the suggestions and ideas here.

Sincerely,

Cliff | Microsoft Community Moderator

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

Answer 2

You have 2 options in Office, either Access or Excel.

.

It really depends on how complex you want to make this database.

.

Excel is probably more straight forward, Access is more "traditional"

.

A simple DB of customers and purchases can fit in to Excel easily enough. Until you start adding embellishments.