is this a good db design for a language center?

Best Microsoft Access Programmer Portland OR

In total I have 4 tables (Students, Staff, Classes, and Projects).

Students Table:

  • FirstName (Short Text)
  • LastName (Short Text)
  • BirthDate (Date & Time)
  • NationalIDNumber (Number or Large Number – Also PK)
  • Gender (Short Text)
  • Class (Number – FK Indicating Which Class Student Will Be In)

Staff Table:

  • FirstName (Short Text)
  • LastName (Short Text)
  • BirthDate (Date & Time)
  • NationalIDNumber (Number or Large Number – Also PK)
  • Gender (Short Text)
  • Role (Short Text?)
  • Salary (Number or Large Number)

Classes Table:

  • ID (Auto Increment – PK)
  • Name
Read More

Part 2 Deliveries, Please

Best Microsoft Access Programmer Portland OR

by Anonymous

Safeway, cont. Driver showed up without mask. I didn’t think of that til later. It was also just a weird feeling, truly awkward, not sure what was happening. There was one item substituted, like he wanted to go through the receipt and i wanted to go about my day. I said sorry, I can’t tip a late delivery. He understood said, we can’t accept tips anyway, and said it wasn’t his fault. I felt a little bad. I don’t understand who this … Read More

Online, Deliveries, and Not Knowing Shit

Best Microsoft Access Programmer Portland OR

by Anonymous

Im fine with online shopping and deliveries for groceries too now. When you live 20 min walking to the nearest 7-11, that ain’t food, Pizza ain’t bad, or a whole walk and bus ride to a grocery, it’s too much hassle. Prepandomonium, post, or during, I gotta look after time and mind. Grubhub has always come through for me, cept a time the delivery was made, and I did not get it. So if food is stolen well by driver, well, who … Read More

VBA it’s hard

Best Microsoft Access Programmer Portland OR

ingles

Hi I have a problem and I don’t know if you could help me here I have the following code to save but I get an error in CurrentDb.Execute “INSERT INTO”

español

hola tengo un problema y no se si aqui podrian ayudarme tengo el siguiente codigo para guardar pero me sale un error en CurrentDb.Execute “INSERT INTO”

Private Sub Guardar_Click()

Dim wshNetwork As Object ‘New wshNetwork

Set wshNetwork = CreateObject(“WScript.Network“)

Me.Usuario = UCase(wshNetwork.UserName) ‘CurrentUser

Set wshNetwork = Nothing

Read More

Rights and Equity in Education

Best Microsoft Access Programmer Portland OR

by Anonymous

the closure of in class instruction disproportionately affects families in poverty, single parent households, and minority and immigrant populations. Here’s why it is inequitable to close in class instruction to these populations.
1. A single parent who must work to pay rent and buy food is now expected to homeschool their children at home. If that single parent has a teenaged child, more often we see older students foregoing thier education to help their parent with teaching their younger sibling. This hinders … Read More

You asked for it

Best Microsoft Access Programmer Portland OR

by Anonymous

I been waking up at 2 or 3 am lately, sometimes from not sleeping at all, or passing out around 9 or 10 pm then waking up. It happens for whatever reason then I struggle to sleep before work, or just stay up enjoying myself when I don’t work.
My point is, it’s quiet especially with Pandemonium, Protests, and Fires going on. You can see interesting things at that time. I don’t remember any. I can’t recall any.
We got rain right … Read More

Is there a way to display two linked datasheets on a single form?

Best Microsoft Access Programmer Portland OR

I can link a form and a sub form and where one is a data sheet and the other is a form. I made a third form and put each data sheet into it, but I cant figure out how to link them so that when you select a record in the top data sheet it automatically selects the corresponding record on the bottom data sheet.

All of this is built on a query that takes data from two tables.

submitted by /u/MotherGarbage
[link]Read More

Looking for examples of common use case that database software/apps like access could help us with

Best Microsoft Access Programmer Portland OR

Looking for examples of common use case that database software/apps like access could help us with

  • Then could see what common things these software/apps can help us with

For example, can see if airtable does it

What things does the free version do that would help us that all other free spreadsheet options do not do?

  • An airtable link that showcases what things exactly you’re talking about would be helpful.
  • This way we all could find some use for this

I understand airtable

Read More

Creating Access Menu with Tree View Control

Best Microsoft Access Programmer Portland OR

Creating Access Menu with Tree View Control

The Microsoft Access Project Menu, when finished with the Tree View Control, will look like the Image given below.

The Image above shows the Report Group’s third Option Custom Report is selected and highlighted, with the Report Filter Parameter Form open, overlapping the Menu Screen, for User’s input.

Before going into that, in last Week’s Lesson we have learned how to organize the related items in hierarchical order, using Microsoft Tree View Control, based on the Sample  data Table. 

I have made a point … Read More

[Access 2016 Help] – updating yes/no field from a form. And based on yes/no, show the row in dropdown.

Best Microsoft Access Programmer Portland OR

Update a ‘yes/no’ field in a table from a form.

when field is marked ‘yes’, the row is not visible in the form drop-down selection.

Example.

ProductA, ProductB, ProductC, productD. ‘yes/no’ = out of stock.

On a form, ability to mark ProductD ‘yes’ to where it is out of stock and it will not show on a drop-down menu to select a product.

submitted by /u/Help-me-notice
[link] [comments]

Microsoft Acess Developer Portland ORRead More

Page 1 of 814
1 2 3 814