Table of contents
Example_serial_Number_Year

• Tables
  • orders
• Queries
  • new_ID_current_year
• Forms
  • orders
• Modules
  • Module1
• Index

List of fields by table

Table name	Field name	Field type	Primary key	% not Null	Most positive	Oldest date	Newest date	Longest string
orders	date	DATE		100		07/02/2012	21/02/2015
	ID	INTEGER	✔	100	5
	order	VARCHAR		63				25
	year	SMALLINT	✔	100	2015