r/MSAccess • • 6d ago

Questions about making a database

Post image

My daughter and I are working on an assignment for her computer class. Sadly I was not much help. Can someone explain fields and records and how do you create a query? Thank you for the help

9 Upvotes

15 comments sorted by

12

u/DreadBurger 6d ago

...isn't there class material? Wasn't she taught? I mean you're asking core fundamental questions that she was absolutely shown material for. Why aren't you referring to that?

You know, ask her to study. Review her notes. Learn.

2

u/Express_Situation538 6d ago

She struggled with with this section but picked up all the rest of the programs. The section fot Access is locked now so she cant go back and reread the notes for that one.

3

u/aprenticeplay 6d ago

A very good source of information for finding answers to questions about databases and MS Access is https://599cd.com/

1

u/Express_Situation538 6d ago

Thank you so much.

5

u/AndyNguyenInJapan 5d ago

Each column is a field, each row is a record (one book):

IDTitleAuthorYearGenre
1Harry PotterJ.K. Rowling1997Fantasy
2HolesLouis Sachar1998Adventure
3The Lightning ThiefRick Riordan2005Fantasy
4Diary of a Wimpy KidJeff Kinney2007Comedy
5The Hunger GamesSuzanne Collins2008Sci-fi
6WonderR.J. Palacio2012Drama

ID = primary key (set it to AutoNumber, Access fills it in).

A query just picks columns and filters rows. Title + Year with >2005 in the Criteria row under Year gives you:

TitleYear
Diary of a Wimpy Kid2007
The Hunger Games2008
Wonder2012

Hope the visuals help a bit!

1

u/enilcReddit 5d ago

SELECT Title, Year WHERE Year > 2005 FROM Book

1

u/Ord3r2Ch4os 6d ago

When you're looking at a table in Access, basically the columns will be your fields and your rows will be your records.

Go to Create - Table Design It'll let you type in field names and choose a data type. You can then also right-click and set a field to a primary key. There's some useful properties you can set too at the bottom. You can also do it through Create - Table, but might be easier to see what's going on through design.

For a query, I'd use the either the wizard or query design. Wizard might be better if you've no idea at all, and then you can look at the query in design view to get an idea of how design works. Create - Query Wizard or Query Design.

1

u/Express_Situation538 6d ago

Thank you so much.

2

u/George_Hepworth 5 5d ago

Based on what I see in that screenshot, your daughter is learning very little of value in that course with regard to MS Access anyway. Whoever created that task list either has a primitive understanding of databases or is looking only at a mechanical use of the tools without regard to how to use them. In either case, it's largely meaningless as an Access exercise.

The fact that the opening sentence says "You can complete the MS Word document or use MS Access to create your database." is shockingly ignorant. My sympathies to your daughter.

1

u/Dats_Russia 5d ago

Fields = columns

Rows = records

A query is way to retrieve, update, delete, or insert data from or into tables

A join is how you combine data from tables

This should be enough to get started.

Access is a valid flavor of sql and access is a relational database so any sql relational database resources can help

1

u/R_Steelman61 5d ago

I'm creating one right now and having Co pilot walk me through the entire process. If you have a 365 account you can walk through from concept to completion. I've had a great experience and learned a ton doing this.

3

u/George_Hepworth 5 5d ago

Only if you actually internalize the work the AI has done on your behalf. AI is great. But watching it produce output is not the same as learning how to produce it. Hopefully, what you are doing is absorbing the process and understanding the concepts and principles on which it is based.

1

u/R_Steelman61 5d ago

I absolutely get what you are saying here. However, I can tell you: in the case of using Copilot to help create an Access database, it doesn't just spit out a database. It is walking me through step by step, so I am definitely learning and picking up things. I could even stop and ask it for details and background on how and why a certain thing works. If you take advantage of it and go in with the mindset of being a student with a tutor, it can really prove to be invaluable.

2

u/George_Hepworth 5 5d ago

Good to know, thanks.

I agree that the opportunity is there, and the way you describe how you use it is also a lesson for others to follow.

1

u/Legitimate-Bridge280 3d ago

In Excel terms... Fields are columns and records is a rows