0
Microsoft Access
Microsoft Access is a database management system. Part of the Microsoft Office suite, Access can be used to edit data stored in various database formats, such as SQL (multiple varieties), Oracle, Excel, XML, etc. Questions about this software and how to use it belong here.
1,050 Questions
What is Microsoft's access database tool used for?
Microsoft's Access database is used for gathering and understanding information such as your phone numbers, inventory, guest lists, things you are tracking in order to provide a convenient way to enter, navigate, and report your data.
How do I close a database without exiting Access?
Click the X in the top corner of the Database Window. You could also press the Ctrl - W key combination.
What are the four filters used in access?
Four types of filters are available in Access: Filter By Selection, Common Filters, Filter By Form, and Advanced Filter/Sort.
When you perform certain tasks Access displays tabs called what?
Access displays tabs called_____ when you perform certain tasks.
What connects the records in access in separate tables?
Joins or relationships. This is done through having values that appear in both tables. A record in one table can then be linked to a corresponding record in another table. It can also be done through queries.
=Count([FirstName])
By Kole G
What is table in Microsoft Access?
A table contains data. It's structure is fields like date or birth, phone number, marital status, gender etc. , and the data is broken down into records, which is data for each individual. So your data would form one record, and someone else's data would form another record.
I believe it is "Delete Column"
How can users increase the magnification of the print preview?
In print preview you have two options, zoom in and zoom out. Click on the screen with the magnifying glass icon or click on the zoom button to toggle between zoom in and zoom out.
You can not increase the magnification more than the zoom in setting. However, you can see more if you decrease your windows screen resolution. Changing your windows screen resolution reduces the amount you can see on the screen, but everything displayed will appear larger.
How will you access the help feature in Access?
Press the F1 key or go to the Help menu and choose the option from there.
What are charts and tables used for in a presentation?
It is a visual way to represent figures or statistics.
How do you set up ascending and descending order in a table and a query?
I'm actually not familiar with Access, but I'll try to help. Usually the primary key will physically order the rows in a database table. In SQL-query you can use "order by" clause. The default order is usually ascending. You can also add "asc" or "desc" after the column name.
Please do notice, primary keys are not for ordering rows. You should really let the database decide how to save the rows. You should always order the rows in your query (if needed), not modify or trust the physical order!
select col1
from foo
order by col2
select col1
from foo
order by col2 desc, col3 asc
