Customers List in Northwind example

[Guest]

Hi,

Can someone tell me how the customers list in the northwind db was created?
I'm trying to replicate it but I cant figure it out. Is is a split form? if
so, how did they hide the form fields and only show the data sheet view?
Also, how did they do the total line at the bottom?

Im a begginer and trying to learn access.

Thanks

 

[fredg]

Hi,

Can someone tell me how the customers list in the northwind db was created?
I'm trying to replicate it but I cant figure it out. Is is a split form? if
so, how did they hide the form fields and only show the data sheet view?
Also, how did they do the total line at the bottom?

Im a begginer and trying to learn access.

Thanks

The list can be added to using the Customers form.
It's just a plain, every day old form.

Click on Forms in the Object pane. Double-click on Customers.
The customers form will open (displaying the Globe as it's background
picture). If you are getting a datasheet view instead, open the form
in Design View. Click on View + Properties.
Click on Format + Default View. Set it to Single Form.
Close and save the change. Open the form now.

The form is bound to the Customers table.