Problem using ms access file structure

Problem using ms access file structure

Hi Patricia,

I will tell you about two of the basic things you will need to know when working on databases or MS Access in your case, these are Tables and Queries.

Tables

MS Access tables are lilke your MS Excel worksheet in that you put your data, can be text, numbers, etc., into rows and columns. In Access, rows are called Records and columns are called Fields. Records are where specific details are stored, for example you have a table for a store inventory, where each record will correspond to one item and each item has specific details associated with it like quantity, unit price or type, these details are stored in different fields.

Queries

Queries on the other hand are used to extract or to isolate certain records in your table. This is especially useful when you have a large table and you only want to see certain data. Using our earlier example, you can use a query to get all items in your inventory that has a quantity that are less than 100 or items that are of a certain type i.e. food, hardware, etc. This is like filtering in MS Excel where you can specify different criteria to get the information that you want.

 

Here's a couple of links you can use to learn more of the basics of databases and MS Access.

https://support.office.com/en-us/article/Database-basics-a849ac16-07c7-4a31-9948-3c8c94a7c204?CorrelationId=ce77bf5f-8c99-4802-b630-fe958e3fd4e7&ui=en-US&rs=en-US&ad=US&ocmsassetID=HA010064450

https://support.office.com/en-us/article/Getting-started-with-Access-2007-23a9abb4-2d41-451a-b81c-bbdc00623aa0?CTT=1&CorrelationId=c821626b-365e-489d-92a9-c556f7cc7393&ui=en-US&rs=en-US&ad=US&ocmsassetID=HA010064616

 

Hopes this steers you in the right direction.

 

Regards,

Laurie