I am a professional resume writer. Up until now, I’ve kept a really (really) big Excel spreadsheet filled with keywords for 100+ professions and job titles. Here’s my dilemma - since job titles sometimes vary for the essentially the same role, is there a base where I can upload everything in a more searchable way? Does anyone have ideas?
What base should I use?
This topic has been closed for replies.
+29It sounds like you want to associate job titles with keywords.
You can create a new base with two tables and links between them.
For example:
Job Titles Table
----------------
Jobs Keywords
---- --------
pianist: reads music, piano
drummer: reads music, drums
singer: reads music, sings
guitarist: reads music, guitar
songwriter: reads music, sings, piano
Keywords Table
--------------
Keyword Jobs
------- ----
reads music: pianist, drummer, singer, guitarist, songwriter
piano: pianist, songwriter
drums: drummer
guitar: guitarist
sings: singer, songwriter
The first table Job Titles has one job title per row.
The second table Keywords has one keyword per row.
After you create both tables, create the link between them.
In the Job Titles table, create a new field.
Under Field Type, select Link to a record.
Under Link to Table, select the Job Titles table.
Under Relationship, allow linking to multiple records.
You can then copy paste information from your spreadsheet into the tabes (assuming that the spreadsheet has columns set up the same way).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.