date stamp marco

http://office.microsoft.com/en-us/access-help/recording-the-date-and-time-when-a-record-is-modified-in-access-HA001034535.aspx

validation rules

http://allenbrowne.com/ValidationRule.html

variable in message box

http://www.pcreview.co.uk/forums/msgbox-display-variable-msgbox-t3634165.html




iff age2<18 then msgbox."sorry but you are to young to be  a member2 else "welcome to the cinema club","username="&query!user......

message macro

message macro

functions

http://www.techonthenet.com/access/functions/

incrementing-the-numeric-portion-of-a-string

http://office.microsoft.com/en-us/access-help/incrementing-the-numeric-portion-of-a-string-in-access-HA001055083.aspx

incrementing counter

video

reset autonumber

Method 1
You can reset an AutoNumber field value so it corresponds with one of the fields in the table. To do this in Microsoft Office Access 2003 and in earlier versions, follow these steps:

1. Delete the AutoNumber field from the main table.
   
   Make note of the AutoNumber field name.
2. Click Queries on the left pane. Double-click Create query in Design view on right pane.
3. In the Show Table dialog box, select the main table. Click Add and then click Close.
4. Double-click the required fields in the table view of the main table to select the fields.
5. Select the required Sort order.
6. On the Query menu, click Make-Table Query. Type the new table name in the Table Name text box and then click OK.
7. On the Query menu, click Run.
8. A dialog box appears with the text that follows: You are about to append # row(s) into a new table. Click Yes to insert the rows.
9. On the File menu, click Close. Click No to close the Make-Table Query window.
10. Click Tables on the left pane. Right-click the new table and then click Design View.
11. In the Design view for the table, add an AutoNumber field with the same field name that you deleted in step 1. Add this AutoNumber field to the new table and then save the table.
12. Close the Design view window.
13. Rename the main table name. Rename the new table name to the main table name.

autonumber

http://www.developerbarn.com/access-database-samples/925-how-set-autonumber-easy-method.html
http://support.microsoft.com/kb/209696

duplicates

http://www.ehow.com/how_2020526_wizard-duplicates-access.html

DOB

http://office.microsoft.com/en-us/access-help/calculating-age-from-a-birth-date-in-access-HA001055071.aspx

age from birthday

http://office.microsoft.com/en-us/access-help/calculating-age-from-a-birth-date-in-access-HA001055071.aspx

date to age

link

presence check

A presence check means that the computer looks to see if data is present in a
field. Presence checks are used in cases where it is not allowed to leave a field
blank. In Access, to create a presence check for a field, we set the ‘Required’
option in the table design view to ‘Yes’.

Validation rules

 rules

http://office.microsoft.com/en-us/access-help/create-a-validation-rule-to-validate-data-in-a-field-HA010096312.aspx

next part of Unit 7

See you Thursday and Friday 10 o'clock in canteen
Jake

next stage of Unit 7

see you Thursday and 10 o,clock Friday in canteen if thats ok with you.
jake

link data- see both

http://www.youtube.com/watch?v=zzrd4tjPiYY

joining strings with concatenation

http://www.youtube.com/watch?v=EpRSczP6aOA

access input

http://www.bigresource.com/VB-Access-table-in-database-Login-System--muWBmFsWIm.html#YxZFJxehYe
link

multiple access video tutorials

http://www.youtube.com/playlist?p=PL1F92EC4198094437

more password

http://www.youtube.com/watch?v=UO4HeWnuT3A&playnext=1&list=PL1F92EC4198094437

password

http://www.youtube.com/watch?v=pT2boGE-bAg

login

http://www.databasedev.co.uk/login.html

Finished

Hello!


I finished. When do want to meet??

scan of proposal

https://docs.google.com/leaf?id=0BwLfsq9Sg7EbNWU5ODUyOWEtYWI3Yy00YjA4LWFlN2YtMTk1YzA2MzgwMDBj&hl=en_GB&authkey=CMjJ7dcL


https://docs.google.com/leaf?id=0BwLfsq9Sg7EbNzE5NGEwMzItMGQ3Zi00ZWNmLTkzYzctMWIxNjRkOTEzN2E2&hl=en_GB&authkey=CMOUuOIJ

Emails!

Did you get my emails this time??

Megan no emails

email is toftscot@hotmail.com and yes i have marked the unit8 some small changes to clarify marks but no emails form you have been looking for them but no arrival


 jake