Certainly! Here is an example of a basic table structure for an address book database in Microsoft Access:

Copy code
CREATE TABLE AddressBook (
    ID INT PRIMARY KEY AUTO_INCREMENT,
    FirstName VARCHAR(255),
    LastName VARCHAR(255),
    Address VARCHAR(255),
    City VARCHAR(255),
    State VARCHAR(255),
    ZipCode VARCHAR(255),
    Phone VARCHAR(255),
    Email VARCHAR(255)
);

You can use the following code to fill in the city and state when the user enters their zip code:

Copy code
CREATE TRIGGER ZipCode_Update
AFTER INSERT ON AddressBook
FOR EACH ROW
BEGIN
    DECLARE @zip VARCHAR(255);
    SET @zip = (SELECT ZipCode FROM AddressBook WHERE ID = NEW.ID);
    UPDATE AddressBook SET City = (SELECT City FROM ZipCodes WHERE ZipCode = @zip), State = (SELECT State FROM ZipCodes WHERE ZipCode = @zip) WHERE ID = NEW.ID;
END;

Note that the above code assumes that you have a separate table called "ZipCodes" that contains the mapping of zip codes to cities and states. Also, this is just an example and you can modify it according to your need.