Are tables the only information displayer you can use for Access? And is SQL Server a bigger version of Access?
You can display data in tables, forms, queries and reports. Tables and queries are formatted like a datasheet, the difference being that you can link tables in a query so show selected fields from two or more tables. From the design point of view, forms and reports work in a similar way. You can base them on either tables or queries and drag and drop the selected fields onto the background area. Forms are used principally to facilitate data entry, though they are also useful for viewing the data held in the underlying table or query. Reports, as the name suggests, are principally used to produce a nicely formatted paper hard copy output.
SQL is not a larger version of Access, though it is capable of holding very many more records and is compatible with Access. Developers use it for large-scale business-critical multi-user applications as it comes with a range of sophisticated admin and security functions. SQL does not provide for much in the way of a graphical user interface, so most developers would use it in conjuction with an Access front end.
B