59 Answered Questions for the topic Microsoft Access

Microsoft Access

03/14/19

Data on excel from access database based on criteria in excel?
I have a MS Access database to which an excel file is connected to view output. MS Query is used to interface and fetch data based on two conditions date & ID. I am unable to specifiy the... more
Follows • 1
Expert Answers •1
Microsoft Access

03/14/19

MS Access split database queries?
When the frontend of a MS Access db queries a MS Access backend on another machine over the network, does it pull in the whole table/database/file, or does it have some way of extracting just what... more
Follows • 1
Expert Answers •1
Microsoft Access

03/13/19

How to design a simple database for charitable donations in MS-Access?
I have been asked to build a simple database for my church. Those using the database will need to use the form view only, so I am trying to make it very user friendly. The church has 3 bank account... more
Follows • 1
Expert Answers •2
Microsoft Access

03/13/19

MS Access - Auto-Update Data Type After Import?
I am looking to automatically update the data type of numerous fields in MS Access once I have imported some Excel data into the database.Almost all fields are set to `Text` fields, and this would... more
Follows • 1
Expert Answers •1
Microsoft Access

03/13/19

How do I allow multiple people to open my Access database?
I have an incredibly simple Access database. It has one pass-through query and that's it (no tables). The query simply executes a stored procedure against a SQL Server database to display the... more
Follows • 1
Expert Answers •1
Microsoft Access

03/13/19

How to make database accessible for multiple users?
I have database for my desktop application, a billing application. I want that database shared so it can be opened by multiple users, but I currently get an error message like `"database has been... more
Follows • 1
Expert Answers •1
Microsoft Access

03/13/19

What is the easiest way to edit an Access database online?
**Problem:**In our office we have an Access customer database that is about 20MB big. People mostly use it from within the office's LAN, but some other team members are external and they currently... more
Follows • 1
Expert Answers •1
Microsoft Access

03/13/19

How do I link data from an Access query into Excel?
I have a large amount of data that I want Access to query and not bring everything into Excel.How do I save the query from Access so that Excel will recognize it as an external source?
Follows • 1
Expert Answers •1
Microsoft Access

01/17/19

Is this true or false?
In Access, can a field be included in a query and not be shown in the query result?
Follows • 1
Expert Answers •1

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.