In order to create an Access database

1. Click File and New
2. Select Database and OK
3. Type name of database and click Create

1. Double Click create table by using wizard
2. Select a table form close to the one required and then select individual fields in order to customise to the task required
3. When fields have been selected and renamed (if needed) click Next
4. Click Next to have Access define primary key
5. Select option for wizard to create a data entry form

If some of the fields required drop down lists so that standardised fields can be selected a separate table containing that information needs to be defined. Create both tables separately.
For example, you may have a customer table that contains a drop down list of services used by customers on particular days (rows in the table). The customer table and the services table will have a relationship.

1. Open the main table (e.g. customer) and click on design, click on Insert on the task bar and click on Lookup Field. Click Next
2. Select referred to table (e.g. services) and click Next
3. Select fields to be displayed during lookup and click Next
4. Give the field a label