designing a relational database 13.4 page 13-4. a database should be created based on a design ...
DESCRIPTION
Creating a new relational database You MUST name the database BEFORE you save it. Start Programs, Microsoft Office Access Create new file, blank database Navigate to YOUR folder Give the database a name CreateTRANSCRIPT
![Page 1: Designing a Relational Database 13.4 Page 13-4. A database should be created based on a design Three steps Determine what information should be stored](https://reader036.vdocuments.us/reader036/viewer/2022062504/5a4d1b0b7f8b9ab05998aed8/html5/thumbnails/1.jpg)
Designing a Relational Database
13.4Page 13-4
![Page 2: Designing a Relational Database 13.4 Page 13-4. A database should be created based on a design Three steps Determine what information should be stored](https://reader036.vdocuments.us/reader036/viewer/2022062504/5a4d1b0b7f8b9ab05998aed8/html5/thumbnails/2.jpg)
A database should be created based on a design Three steps
Determine what information should be stored Know the purpose of your database
Divide information into named tables Grouping the related information
Define fields and determine the primary key Field names (p 13-2) Primary key given to fields that cannot be
duplicated (p 13-4)
![Page 3: Designing a Relational Database 13.4 Page 13-4. A database should be created based on a design Three steps Determine what information should be stored](https://reader036.vdocuments.us/reader036/viewer/2022062504/5a4d1b0b7f8b9ab05998aed8/html5/thumbnails/3.jpg)
Creating a new relational database You MUST name the database
BEFORE you save it. Start Programs, Microsoft Office Access Create new file, blank database Navigate to YOUR folder Give the database a name Create
![Page 4: Designing a Relational Database 13.4 Page 13-4. A database should be created based on a design Three steps Determine what information should be stored](https://reader036.vdocuments.us/reader036/viewer/2022062504/5a4d1b0b7f8b9ab05998aed8/html5/thumbnails/4.jpg)
Database Window (13-6)
![Page 5: Designing a Relational Database 13.4 Page 13-4. A database should be created based on a design Three steps Determine what information should be stored](https://reader036.vdocuments.us/reader036/viewer/2022062504/5a4d1b0b7f8b9ab05998aed8/html5/thumbnails/5.jpg)
Parts of the screen Toolbar – contains buttons that represent
different actions Database Window – used to display and
create objects for the open database Buttons – used to display database objects
and icons Window toolbar – buttons that represent
different actionsSee picture 13-6
![Page 6: Designing a Relational Database 13.4 Page 13-4. A database should be created based on a design Three steps Determine what information should be stored](https://reader036.vdocuments.us/reader036/viewer/2022062504/5a4d1b0b7f8b9ab05998aed8/html5/thumbnails/6.jpg)
Creating tables Click tables Double-Click create
table in design view
![Page 7: Designing a Relational Database 13.4 Page 13-4. A database should be created based on a design Three steps Determine what information should be stored](https://reader036.vdocuments.us/reader036/viewer/2022062504/5a4d1b0b7f8b9ab05998aed8/html5/thumbnails/7.jpg)
Create tables
Type in a field name
Select the field typeType a description IF NECESSARY
![Page 8: Designing a Relational Database 13.4 Page 13-4. A database should be created based on a design Three steps Determine what information should be stored](https://reader036.vdocuments.us/reader036/viewer/2022062504/5a4d1b0b7f8b9ab05998aed8/html5/thumbnails/8.jpg)
Field Properties
Once you have entered a field name, field properties options are available
![Page 9: Designing a Relational Database 13.4 Page 13-4. A database should be created based on a design Three steps Determine what information should be stored](https://reader036.vdocuments.us/reader036/viewer/2022062504/5a4d1b0b7f8b9ab05998aed8/html5/thumbnails/9.jpg)
Primary Key To complete a table, a primary key
must be designated. Put your insertion point inside the
field name Click the primary key button on the
toolbar That field is now the primary key
![Page 10: Designing a Relational Database 13.4 Page 13-4. A database should be created based on a design Three steps Determine what information should be stored](https://reader036.vdocuments.us/reader036/viewer/2022062504/5a4d1b0b7f8b9ab05998aed8/html5/thumbnails/10.jpg)
Save and Close the table Click the Save button on the toolbar Name the table Close the table (little X)
![Page 11: Designing a Relational Database 13.4 Page 13-4. A database should be created based on a design Three steps Determine what information should be stored](https://reader036.vdocuments.us/reader036/viewer/2022062504/5a4d1b0b7f8b9ab05998aed8/html5/thumbnails/11.jpg)
Table is now ready for you to open and input data
![Page 12: Designing a Relational Database 13.4 Page 13-4. A database should be created based on a design Three steps Determine what information should be stored](https://reader036.vdocuments.us/reader036/viewer/2022062504/5a4d1b0b7f8b9ab05998aed8/html5/thumbnails/12.jpg)
Assignment Complete Practice 1 on page 13-4
Yes, you must write down and plan the database
Sample database planning sheets are on the center tables
Complete Practice 2 on page 13-8-11 Read each step carefully Save with correct names