Creating A Blank Desktop Database Access 2013

After starting Access as described at the beginning of Section 2, “Creating a custom Web App,” you can use one of the available template databases, or you can create a blank database as described in this section. 

Access offers you the flexibility to use templates of commonly encountered database structures or to start with an empty database into which you can either import existing data or create a solution tailored to your specific needs. 

Create a blank desktop database:

1. Click Blank Desktop Database. 
2. Type a name for your database. 
3. Select a file location in which to save the database. 
   
4. Click Create. 
5. When the new blank database opens in layout view (described later in this section), you will see that Access has created a table called Table1. At this
   
   point, we can close this table without saving any changes to the new table. Click the Close button to close the table. 

TIP: The templates for a desktop application all begin with the word desktop, and you can scroll down the list of templates to see these. Other templates are for creating a Web App.

The following table lists the available data types when you are adding fields to a table in a desktop database.

Data type	Description
Short Text	Text up to 255 characters. In earlier versions of Access, this data type was called Text.
Long Text	Large amounts of text, up to 65,536 characters. In earlier versions of Access, this data type was called Memo.
Number	Field Size property provides for Byte, Integer, Long Integer (default), Single, Double, Replication ID, Decimal.
Date/Time	Date and Time field.
Currency	Currency field.
AutoNumber	Sequential Automatic Number, Long Integer (default).
Yes/No	True/False (default is False).
OLE Object	Can hold images or other documents.
Hyperlink	Hyperlink to the Internet and local documents.
Attachment	Allows multiple documents to be saved.
Calculated	Calculated field.
Lookup	Creates a foreign key lookup.