Putting two subfields within a field

[Clarendon]

I have data that might be too complex for Access to handle. I am analyzing
features of instances of a phrase I search in the internet:

Phrase Feature 1 Feature 2 Feature 3

A 5 (50%) 5 (50%) 0
X2, Z3 Y5
B

This table shows phrase A has 9 (=5+4) instances in total, 5 with Feature 1
and 5 with Feature 2. These instances can have further features that can be
marked as X, Y, Z. The five Feature 1 instances can be broken down to 2 of X
and 3 of Z, and so forth. Is there a way to put this data in Access? I also
want to sort and filter the features (not records!!) by the composition of X,
Y, Z and percentage of instances, for inatance: 'For a given phrase give me
the features that score below X percentage', 'For a given phrase give me the
features with one XYZ mark only (Feature 2 in above table)'.

Note that multiple tables are not likely to help. You can use multi tables
if you want to add further information for a value, but my case is not adding
information for a value but for a field (Features).

I would greatly appreciate your help.
Thanks.

 

[PieterLinden via AccessMonster.com]

Describe this with just nouns (things) and verbs (relationships). Sounds
like it's a simple relationship...
A [phrase] has {many} [features]

HasFeature(
Phrase (PK1),
Feature (PK2)
)

The example below is a crosstab... not a proper table.

You want to sort features, but not records? What is there in a database
besides records?

I have data that might be too complex for Access to handle.

Your design must be wrong... explain how it's too complex.