Does MS Access support multiple rows per record?

Question

If not is there any database system which supports multiple rows per record? For example in any given record first row of a field contains First Name while second row in the same field contains Last Name.

Answer 1

Does MS Access support multiple rows per record?



In Access, you have a single row which is a single record, so the answer is simply no.



However, what you could consider as a work around is to have every two rows in a table which can be treated as a single record by creating a field with the same ID (which of course can not be unique - set as a primary key).



This does however break normalisation rules in RDBMS (relational database management systems) but with clever reporting as an output, this can appear a single record.



The ID field can instead be indexed as a secondary key (a key which is indexed as 'Duplicates OK'). If you want to still add a unique field to simply act as an audit trail then include it too (as a primary key).



If anyone else has another suggestion, I would very much like to hear - so this question gets my vote as 'interesting'.



Thanks for asking and hope this helped

Ben Beitler

Answer 2

This sounds like either of 2 possible scenarios:



1) A "Memo" field, which is a TEXT field that allows for carriage returns to be displayed resulting in multiple "lines" within each record.



2) Your looking at an XML/HTML (or similarly structured) data file and asking what data base supports it. MS Access can both read and generate them, depending on the version (2003 with some work, and later versions more easily. Earlier versions I dunno.).



Once imported (or linked) the DB will display it in the Typical format with Fields aligned as Columns and each row being one Record.



Within the XML/HTML Data file (viewed with a Browser or Text Editor) it would look something like this:











Bob

Roberts

R





Tom

Thomason

T









These data files can actually contain multiple tables and Access will import each seperately.



Otherwise I am unaware of any GUI based DB Apps that represents it with Records as Columns and Fields as Rows. There may be a Chinese based one, since Chinese is wriiten & read Down then Across, as opposed to European languages which are read Across then Down...

Answer 3

The whole rows and columns thing is just a convention. You have an entry in a database which contains fields. In a graphical interface like Access, they represent each entry with a row and each field with a column. You can have separate fields/columns for first and last names, but each row represents an entire entry.

Answer 4

If you decided in finding out to talk Chinese then you need to now that the very best choice is a Program for Mandarin.

Answer 5

Are you specific that's numerous types, or numerous archives being displayed on one form? curiously you have set the types default view assets to non-stop types. instead, set your sub-archives form's default view assets to datasheet or single form. single form will exhibit one record at a time, whilst datasheet will exhibit it as in case you have been finding on the table.