An Access table contains all the data in a database. Learn more about creating and modifying tables in Microsoft Access. In a well-designed Access database. The database can store a huge number of data into a single file and users can access that data using a programming language or any other third party software. A table is where data is stored and a table lives within a database. Without a database, we cannot access any data. A table in Access is quite different than a table in real life.