I want to build a program but am unsure of where to start. I want to build something that would allow a user to enter different options/preferences and upon hitting the search button, it would pull like results from several in house databases. I'm not expecting this to happen overnight with my lack of skills but would just like a good starting point.
This is really easy, you can do it overnight, it almost looks like natural language:
-- Create your table
BEGIN TRANSACTION;
CREATE TABLE Cars(Id integer primary key autoincrement, Name text, Dimension text, Color text);
INSERT INTO Cars VALUES(1, 'Jeep Cherokee', '4x4', 'Brown');
INSERT INTO Cars VALUES(2, 'BMW M3', 'Coupe', 'Red');
INSERT INTO Cars VALUES(3, 'Mercedes E350', 'Cabriolet', 'Black');
COMMIT;
-- Then query it
SELECT * FROM Cars WHERE dimension like '4x4';
-- You get:
-- 1|Jeep Cherokee|4x4|Brown