Q&A for How to Use Microsoft Access

Return to Full Article

Coming soon

Add New Question

Question

How do I put a password on a Microsoft Access database?

Community Answer

In the File tab, you can click 'encrypt with password'. Type in the password and encrypt it.

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 9 Helpful 18
Question

How do I make the Access Database I have open to a specific form?

Community Answer

Go to where your form is listed in your computer window. Right-click on the form, then choose "Open With". Choose Microsoft Access. Alternatively, open Access, and got to "File>Open", (CTRL + O), and browse to the file you want to open.

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 13 Helpful 9
Question

What kind of data can be used only with the Access database?

Community Answer

For any form of valid CSV (Comma Separated Value), Access, Word, Excel may be used. Integers, words, symbols, yes/no are all logical inputs for 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 13 Helpful 11
Question

Can two people work in Access and have it update and save the data in real time?

Community Answer

If the company that you work for has Office 365 and has a data it runs the program on, then yes.

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 11 Helpful 3
Question

How do you print labels in Microsoft Access?

K Kumar

Community Answer

Open your database in Microsoft Access. Go to Label Wizard: Click Create > Labels under the Reports group. Select your label type (e.g., Avery) and style (font, size). Choose the table or query (e.g., Customers) with the data you want to print. Insert fields like Name, Address, etc., into the label format. Optionally, sort the data (e.g., by name or zip code). Preview labels, then go to File > Print to print on label sheets. You’ve now printed your labels.

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