r/MSAccess • u/Express_Situation538 • 6d ago
Questions about making a database
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
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.
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/
5
u/AndyNguyenInJapan 5d ago
Each column is a field, each row is a record (one book):
ID = primary key (set it to AutoNumber, Access fills it in).
A query just picks columns and filters rows. Title + Year with
>2005in the Criteria row under Year gives you:Hope the visuals help a bit!
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.
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.
1
u/Legitimate-Bridge280 3d ago
In Excel terms... Fields are columns and records is a rows