473,322 Members | 1,496 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Access Data

cjbrx3115
Are tables the only information displayer you can use for Access? And is SQL Server a bigger version of Access?
Mar 18 '07 #1
2 1051
brynne
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
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

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

Similar topics

0
by: sedefo | last post by:
I ran into this Microsoft Patterns & Practices Enterprise Library while i was researching how i can write a database independent data access layer. In my company we already use Data Access...
63
by: Jerome | last post by:
Hi, I'm a bit confused ... when would I rather write an database application using MS Access and Visual Basic and when (and why) would I rather write it using Visual Studio .Net? Is it as easy...
9
by: WalterR | last post by:
This is my first time here, so there may be earlier relevant threads of which I am unaware. Though my experience with DB2 is not extensive, such as it is was under OS/390 or equ. My main...
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
20
by: Olav.NET | last post by:
I am a .NET/C++ developer who is supposed to do some work with Access. I do not know much about it except for the DB part. Questions: *1* I am looking for INTENSIVE books to get quickly up to...
9
by: Tony Lee | last post by:
Some time a ago, on this newsgroup the following comments were made in recommending good references for Access (2003) >I used to recommend Dr. Rick Dobson's, "Programming Access <version>" for...
17
by: DaveG | last post by:
Hi all I am planning on writing a stock and accounts program for the family business, I understand this is likely to take close to 2 years to accomplish. The stock is likely to run into over a...
5
by: B1ackwater | last post by:
We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a...
17
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...
21
by: nihad.nasim | last post by:
Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.