Q&A for How to Make a Database Using MS Access

Return to Full Article

Coming soon

Add New Question

Question

How can I create a database for parts inventory? These parts have older p/n and replacement p/n and alternate p/n's also.

Community Answer

Create three columns and link all three together as shown in the article. (One employee can have many items and the item can belong to only one employee).

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 7 Helpful 23
Question

How do I make a field name capitalized in MS Access?

Community Answer

Open the desired table. Click on Design View. Type the field names in all caps at this point.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 8
Question

I want to make a database and sell it to offices, banks, and universities. What should I do?

Community Answer

Reconsider your platform. Whatever you build, build it with an enterprise database (e.g. SQL Server). If you absolutely, positively, cannot live without Access, build your solution as a SharePoint online app using Access Services.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 5 Helpful 16
Question

How do I insert a picture in MS Access?

Community Answer

In Forms and Reports, you can. On the Design tab, there is an option to insert image. If it is grayed out, then an image cannot be placed there, so click elsewhere until the option is available.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 4
Question

Can photos be added?

Community Answer

Yes, but only in the Forms and Reports. On the Design Tab, it has an option to insert image. If it is grayed out, then an image cannot be placed there, so click elsewhere until the option is available.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 1
Question

I would like to create training profile database for our employees at our department so I can track their training activities and status at any time. What can I do?

Community Answer

You might want to check out Airtable instead of working with MS Access. There is a higher learning curve with Access.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 2
Question

How do I create a table in MS Access?

Community Answer

Click the Create tab and then pick either Table or Table Design.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 2 Helpful 4
Question

How can I create a password and a username for an Access database?

Community Answer

You can't create a username and password for an Access database from Access 2007 onward. However, you can encrypt a database with a password by opening a database in exclusive mode and then going to File > Info > Encrypt With Password.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 1
Question

I want to build a database that I can use for my logistics company. How do I start?

Community Answer

Step 1 is to identify the results you desire. For instance, if you want 5 reports, then sit down and mock up your reports (you may already be doing reporting using Excel or Word for instance). The results of the reports will lead you to the fields you need in your tables. Then organize your tables. This will lead you to remembering additional information you want tracked/managed that isn't in the reports. After you've identified your tables, build data entry forms for each table. Then the reports. The a 'report criteria screen' (which is a form) for supplying criteria to the reports prior to running the reports.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0