Does MS Access support multiple rows per record?

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.

5 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    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

  • 1 decade ago

    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:

    <File type specification statement>

    <FileName>

    <Tablename>

    <Record>

    <First Name>Bob</First Name>

    <Last Name>Roberts</Last Name>

    <Middle Init>R</Middle Init>

    </Record>

    <Record>

    <First Name>Tom</First Name>

    <Last Name>Thomason</Last Name>

    <Middle Init>T</Middle Init>

    </Record>

    </Tablename>

    </FileName>

    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...

  • Ben
    Lv 7
    1 decade ago

    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.

    • 6 years agoReport

      But how do you make that entry expand for each row when you want a lot of information in each entry but *don't want* to divide it into separate rows?

  • 4 years ago

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

  • How do you think about the answers? You can sign in to vote the answer.
  • 3 years ago

    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.

Still have questions? Get your answers by asking now.