Like "D*"
Solution:
MS Access > Create > Table > Rename Table1 to table_name > Add column first_name Short Text > Add Debra, Donna, Daniel
OR
MS Access > Create > Query Design > SQL View
CREATE TABLE table_name (first_name Text);
-- Note: In MS Access SQL, you cannot directly insert multiple values into a column.
-- Note: In MS Access SQL, you need to execute each statement separately.
INSERT INTO table_name (first_name) VALUES ('Debra');
INSERT INTO table_name (first_name) VALUES ('Donna');
INSERT INTO table_name (first_name) VALUES ('Daniel');
-- Press F5 to refresh Datasheet View.
Check queries:
SELECT first_name FROM table_name WHERE first_name Like "*n*"; -- Donna, Daniel
SELECT first_name FROM table_name WHERE first_name Like "*[ro]*"; -- Debra, Donna
SELECT first_name FROM table_name WHERE first_name Like "De* or Do*"; -- null
SELECT first_name FROM table_name WHERE first_name Like "D*"; -- Debra, Donna, Daniel