Introduction to Access 2016 ( Access 2016: Introduction to Databases (gcfglobal.
org))
Access user Interface ( Guide to the Access user interface - Microsoft Support)/ ( Access
2016: Getting Started in Access (gcfglobal.org))
Introduction to objects ( Access 2016: Introduction to Objects (gcfglobal.org)) / ( MS
Access - Objects (tutorialspoint.com))
Working with tables (Access 2016: Working with Tables (gcfglobal.org)/ MS Access - Create
Tables (tutorialspoint.com)
Data Types ( MS Access - Data Types (tutorialspoint.com))
Query Data (MS Access - Query Data (tutorialspoint.com))
Query Criteria ( MS Access - Query Criteria (tutorialspoint.com))
Create a simple database table
For each database we need to assign a primary key, a primary key is a unique record that is not
duplicated. Every record will have a unique ID
Table relationships ( MS Access 2016 - Create Table Relationships)
Example 1
Let’s create a table and name it “customer”
We have the Field Name and the Data Type
ID (Auto Number)
First Name(short text)
Last Name (short text)
The difference between short text and long text is the field size, for the short text we have only 255
characters or for the long text no limit for the characters. We can also for the phone number put a
short text it’s not necessary the data type be a number as long as we don’t have a calculation.
Address (Long text)
ZipCode (short text)
City(short text)
Mailing List (Lookup Wizard) it’s to set my values if for example I want to send them an email
yes/no/ Maybe (Special offer)
DOB (date/time)
Location In Beirut ( yes/no)
Once we finish on the ribbon on the top select datasheet view and let’s put some records
Example 2: Create a car model database
Car_ID ( AutoNumber) if we look on the properties down because we didn’t put it as a primary key
so in the indexed (yes duplicates ok ) to change it right click on the field and set primary key and it
will changet it on properties to no duplicates
Manufacturer (short text and I can change the field size to 25 instead of 255 characters
Model ( short text) in the properties in the validation rule we type is not null and the validation text
you must enter a validation number
Engine capacity ( Number) validation rule: > 100 and validation text: the capacity should be greater
than 100
Price (currency) validation rule: > 2000 and a validation text
Hybrid (yes/no)
Seats (Lookup Wizard) 2/4/5/7
