sql - How Can I do Access Query -Count- -

how can write query database output excel tables.

please me.

my databese , excel table

if helps, have screenshots access 2013. menu descriptions same. grid output asked different mode. there table design view used make table.

switch data sheet view through menu option.

select query 1 of 4 possibilities:

1. select
2. update
3. delete
4. append

depending on trying data, query type should chosen. used select.

i used select query data. won't change data when run it.

run query , view results:

the select query created has mode called sql view have query there if used guide design query. sql looked like:

select employee.ename, employee.job employee order employee.ename desc; 

enjoy!