COM 140 (2025): Creating and using databases

Learn basic database concepts, terms, and operations. Create and navigate a simple table, query, and form. Create and modify tables by defining fields, field properties, and a primary key. Import data and define a relationship between two tables .Find, modify, and delete records in a table. Create, run, and save queries as well as perform calculations, sort, and filter data in a query. Create forms, find data using a form, and print selected form records.Create reports, move and resize fields, insert a picture, custom format, and print a report. 

Explain your problem to Microsoft CoPilot or another AI, such as chat GPT. Specify that you are using the Microsoft Access platform to solve your problem(s). Use specific prompts to ask your AI of choice such as Microsft CoPilot or chat GPT to explain the solution in terms of Microsoft Access. The AI will tell you which tables you need, and if your prompt is specific enough, will probably describe it the forms you need.

Once you have a list of tables you can ask the AI to write the VBA code to create those tables.Now in the Microsoft Access database interface you will see a list of tables on the left. Select one of the tables and then in the top you will have a selection to create a form. one of the selections will create the form from the selected table. This is just the startign point - you will need to continue your conversation with the AI, fine tuning the results until you get the results you want.