Practical Databases

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

How to import a CSV into access

1. Open up access External data Text file 2. Click on browse and finde your excel file Click open and OR 3. Click next 4. Tick- first row contains field names Click names 5.Click next Choose your primatie key, if there is non. And if there are 2, click on your primatie key 6. Advanged bottom and change to a full stop

Boolean

2 opptions Yes or no

Definition of Relational database

2 or more tables that we link together

Explain what a runtime calculation is

A calculation using the information from the table in the database

Item

A particular piece of data (one cell)

Definition of database

A place to store large amounts of sinlar data (same type info)

What is a wild card?

A wildcard is a star *=wildcard K*= begining with K *K=ending with a K *A*= A in the middel

Currency

Anything to do with money

Text

Anything with letters, number or symbols

How to create a form to make data entry easier

Create-Form wizard-makesure table is selected-next-next-finish

Date and Time

Date and time

Name the 5 main parts of a standard flat file database

File/table Record Field Item Primary key

Field

Generally heading in the table

Where do you create a runtime calculation?

In the Query

Numeric

Integer-10 Decimal-10.5

Record

One row The details of one person

Definition of Flat file

Only one table

Advantages when using a Relational database

Primary key- unique identifies record Tables are linked No repeated data Editing once all updated

Explain these features of a database: Primary key Foreign key Relationship (link)

Primary key: Unique record (number) Foreign key: Links the table (primatie key from one table is now in second table) Relationship (link): How they link togehter

File/table

The hole table

Explain what a Query is used for

To find specific critreria in a table Filters answers for questions

Primary key

Unique code Key field Used for searches

Disadvantages when using Flat file database

Unorganised Large Repeated data (redvndant data)

Advanced Query

Were you have to write several critiras to find your specific info

Simple Query

Were you only have to type in one critira to find the specific info you need


संबंधित स्टडी सेट्स

BGD part 3 people and parsing poetry

View Set

Genetics Final Practice Questions

View Set

NFPT Exam Chapter 8: Nutrient Review

View Set

OMM Semester 1 Savarese Practice Comlex Exam

View Set

Chapter 35: Caring for Clients with HIV/AIDS

View Set