Tuesday 27 January 2015

World of Database

General Info
Data is stored in tables. Example: address book is a table of the address book database. Each address is a data record, presented as a row in that table. The data records (the data row) consist of data fields and the e-mail field.


1. Data sources
2. Forms and reports
3. Queries
4. Tables

Information abou database:
1.

1. Create a new database file
File > New > Database

2. Create new table
1. Select fields
2. Set types and formats
3. Set primary key
4. Create table


In Datasheet view, you can edit fields, add data, delete data, search for data.
Data types: Boolean, Integer, Long, Currency, Single, Double, Date, string

No comments:

Post a Comment