Windows 10: Ms access related

Can you tell me why ms access latest version is not pre installed I'm my hp victus laptop. But other things like ms Word excel power point 2021 is installed. Please reply.

:)

 

to add "ms access" in open with list when I right click on an

Hi Moideen,

Welcome to Microsoft Community.

I understand that you are willing to add MS Access in 'Open with' menu in Windows 10. I will certainly help you.

I suggest you to follow the below steps and check if it resolves the issue.

1. Right click on .mdb file, select
Open with click on Choose another app.

2. Look for MS Access from the list, if found, select it and click on
OK.

3. If not, navigate to More apps > Look for another app on This PC
and select the MS Access from the list.

4. Then on you can find MS Access default, on Open with
list.

Hope this helps. If the issue remains unresolved, please get back to us and we would be happy to help.

 

Not exactly Win 10 related -but....

Hi Willum08,

I'm using Word from Office 365, however; I believe that the feature was included with Word 2003.

Have a look for the sort shortcut on the home tab.






If you have access to Excel, it has much more versatile sorting features although Word will perform a simple sorting function.


According to this site, the sort feature in Word 2003 is located in the Table Menu.

https://ms-office.wonderhowto.com/ho...t-word-286907/


This link shows is more helpful by providing pics. Scroll down for Word 2003 demo.

How to Alphabetize in Microsoft Word: 8 Steps (with Pictures)

 

MS ACCESS: A7 Building Queries in Microsoft Access

Hello, I'm having problems with creating a database from this questions. I was able to do get to a point but won't show or missing something. Can anyone help on these questions:

2. Display the CustomerNum, CustomerName, OwnerName, Phone, RestaurantType, and FirstContact of customers who were first contacted in 1992 and 1993. The list should be sorted by the FirstContact date (with the most recent at the top) within RestaurantType in ascending order.

3. Write this query in SQL. It should be your SQL code and not the one generated by Microsoft Access. Show the CustomerNum, OrderNum, and InvoiceAmt for orders that were placed by customers with CustomerNum in the 500s (that is numbers that fall between 500 and 599) or valued at $2,000 or more. Sort the list by CustomerNum in ascending order.

4. Write this query in SQL. It should be your SQL code and not the one generated by Microsoft Access. Show the CustomerNum, OrderNum, and InvoiceAmt for orders that were placed by customers with CustomerNum in the 500s (that is numbers that fall between 500 and 599) or valued at $2,000 or more. Sort the list by CustomerNum in ascending order.

5. Show the CustomerNum, OwnerName, Kitchen Area, InvoiceAmt, and ZipCode for customers who are located in ZipCodes starting with 43 and have InvoiceAmt between $1,200 and $2,000. The list should be sorted by CustomerNum.


Attached is the File on a zip as access file is not accepted.
The queries I'm working from that I made for some of these are Customer Query, Restaurant Type, Order Query 1.
Thanks this will be a lot of help as I've been trying to do this for the last 3 days.