A table is really just one part of a database. The database consists of other things like the queries and reports. In general we do specifically think of the tables as being the database as that is where the data is stored and tables are central to everything else. As there can be multiple tables and other things as part of the system the term database is used to cover them all as one or as what is called a database management system.
Yes, tables store all the data. Things like the forms, reports and queries are all using data that originally comes from the tables. When you enter data using forms, the data is being stored in the tables. Forms, queries and reports can process data to get information, like getting totals. The underlying source is still the tables.
Schemas and Tables
Databases and spreadsheets make good data sources for mail merge.
Relational tables if stored locally (vs Excel). Can use ODBC interface to access SQL/Oracle/etc databases. Idiot friendly with drag and drop joins.
Each of the Microsoft Office applications are completely different to each other. Microsoft Access is for creating databases. Microsoft Excel can do some databases, but it is not designed to do them, as it is a spreadsheet application. Microsoft Access has many facilities to create databases. Those things are not present in the other applications, which are each designed for their own tasks. Microsoft Access allows you create tables, queries, forms and reports as the main elements of its functionality.
2 GB, but the user can link tables in multiple databases together if a database over this limit is needed.
You can link excel tables, text files, access tables, ODBC tables
Some types of databases (abbreviated as db) include:Hierarchical databaseNetwork databaseRelational databaseObject-oriented databaseThere may be other types.
common field
ODBC / System DSN
Tables can have columns. You will find them in word processors, spreadsheets and databases. Buildings can have columns.
By good programming practice, deadlocks can be avoided (but not altogether eliminated) by locking tables in the same order each time. Have an ordered list of access by tables and then go down the tables in order.
You can make as many as you want, there is no license restriction with how many databases you can create with MS Access 2007.