Knox County. UT Extension serves the citizens of Knox County with educational programs in the areas of Agriculture, Family and Consumer Sciences, Community Resource Development, and 4-H Youth Development.
Both Excel and Access are capable of doing a lot of things that the other can do. Both can store data. Both allow you to manipulate data. Access is primarily for lists of data, such as names and addresses, while Excel mainly deals with numbers.
Overview. An Access database is made up of objects, such as tables, queries, and forms. Tables store data. Every other kind of database object helps you use the data that is stored in tables. When you want to share a database, you usually want to share the tables, because they contain your data.pen the database that you want to share. Click the File tab, and then click Share. Under Save Database As, in the Advanced section, click SharePoint. In the Save to SharePoint dialog box, browse to the document library that you want to use.