By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

Access Data

cjbrx3115
P: 93
Are tables the only information displayer you can use for Access? And is SQL Server a bigger version of Access?
Mar 18 '07 #1
Share this Question
Share on Google+
2 Replies


P: 13
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
Mar 21 '07 #2

cjbrx3115
P: 93
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
Ok thanks.
Mar 25 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.