<< Chapter < Page
  Microsoft access   Page 1 / 1
Chapter >> Page >
chuong 1

GIỚI THIỆU MICROSOFT ACCESS

  • Microsoft Access là 1 trong 4 phần mềm ứng dụng của bộ Microsoft Office (Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft PowerPoint).
  • Access là một hệ quản trị cơ sở dữ liệu (HQTCSDL) dùng để tạo, xử lý các cơ sở dữ liệu.
  • Khởi động:
  • Cách 1: Nhắp Start->Programs->Microsoft office->Microsoft Office Access 2003
  • Cách 2: Nhắp vào biểu tượng
    trên thanh Microsoft Office.
  • Màn hình Access:
  • Chọn Blank Database: nếu muốn tạo mới một file CSDL
  • Chọn From Existing file: nếu muốn mở 1 file CSDL đã có. (đối với Access 97, chọn Open an existing database)
  • Sau khi tạo hoặc mở CSDL, màn hình có dạng như sau:
  • Cơ sở dữ liệu trong Access:

Mỗi CSDL của Access được lưu trữ trong 1 file có đuôi là .mdb.

Mỗi CSDL của Access gồm có các thành phần sau:

  • Table- bảng dữ liệu:

Là thành phần quan trọng nhất, chứa các dữ liệu cần thiết của CSDL

  • Query-Bảng truy vấn (Bảng vấn tin)

Dùng để tính toán, xử lý các dữ liệu của Table, Query

  • Form: là công cụ tạo ra các mẫu trình bày dữ liệu theo các dạng mà người sử dụng mong muốn.
  • Report: là công cụ tạo mẫu và in báo cáo
  • Macro: lệnh vĩ mô

Là tập hợp các lệnh được chọn, sắp xếp hợp lý cho việc tự động hóa các thao tác.

  • Module: đơn thể chương trình

Là phương tiện lập trình trong Access với ngôn ngữ lập trình Visual Basic.

  • Tạo-Mở-Đóng một CSDL trong Access:
  • Tạo một CSDL mới:

 Bước 1:

  • Nếu mới khởi động Access thì chọn Blank Database
  • Nếu đang làm việc tại cửa sổ CSDL thì nhắp menu File/ New Database (hoặc nhắp
    ), rồi chọn Blank Database

 Bước 2: Tại hộp thọai File New Database

    • Trong khung Save in: chọn ổ đĩa chứa CSDL
    • File name : gõ tên file CSDL
    • Nhắp
  • Mở một CSDL:

 Bước 1:

  • Nếu mới khởi động Access thì chọn From Existing file (hoặc Open an existing database).
  • Nếu đang làm việc tại cửa sổ CSDL thì nhắp menu File/ Open Database hoặc nhắp

 Bước 2:Tại hộp thọai Open

    • Trong khung Look in: chọn ổ đĩa chứa CSDL
    • Nhắp chọn file CSDL cần mở, nhắp
  • Đóng CSDL:

Nhắp menu File/Close

Questions & Answers

differentiate between demand and supply giving examples
Lambiv Reply
differentiated between demand and supply using examples
Lambiv
what is labour ?
Lambiv
how will I do?
Venny Reply
how is the graph works?I don't fully understand
Rezat Reply
information
Eliyee
devaluation
Eliyee
t
WARKISA
hi guys good evening to all
Lambiv
multiple choice question
Aster Reply
appreciation
Eliyee
explain perfect market
Lindiwe Reply
In economics, a perfect market refers to a theoretical construct where all participants have perfect information, goods are homogenous, there are no barriers to entry or exit, and prices are determined solely by supply and demand. It's an idealized model used for analysis,
Ezea
What is ceteris paribus?
Shukri Reply
other things being equal
AI-Robot
When MP₁ becomes negative, TP start to decline. Extuples Suppose that the short-run production function of certain cut-flower firm is given by: Q=4KL-0.6K2 - 0.112 • Where is quantity of cut flower produced, I is labour input and K is fixed capital input (K-5). Determine the average product of lab
Kelo
Extuples Suppose that the short-run production function of certain cut-flower firm is given by: Q=4KL-0.6K2 - 0.112 • Where is quantity of cut flower produced, I is labour input and K is fixed capital input (K-5). Determine the average product of labour (APL) and marginal product of labour (MPL)
Kelo
yes,thank you
Shukri
Can I ask you other question?
Shukri
what is monopoly mean?
Habtamu Reply
What is different between quantity demand and demand?
Shukri Reply
Quantity demanded refers to the specific amount of a good or service that consumers are willing and able to purchase at a give price and within a specific time period. Demand, on the other hand, is a broader concept that encompasses the entire relationship between price and quantity demanded
Ezea
ok
Shukri
how do you save a country economic situation when it's falling apart
Lilia Reply
what is the difference between economic growth and development
Fiker Reply
Economic growth as an increase in the production and consumption of goods and services within an economy.but Economic development as a broader concept that encompasses not only economic growth but also social & human well being.
Shukri
production function means
Jabir
What do you think is more important to focus on when considering inequality ?
Abdisa Reply
any question about economics?
Awais Reply
sir...I just want to ask one question... Define the term contract curve? if you are free please help me to find this answer 🙏
Asui
it is a curve that we get after connecting the pareto optimal combinations of two consumers after their mutually beneficial trade offs
Awais
thank you so much 👍 sir
Asui
In economics, the contract curve refers to the set of points in an Edgeworth box diagram where both parties involved in a trade cannot be made better off without making one of them worse off. It represents the Pareto efficient allocations of goods between two individuals or entities, where neither p
Cornelius
In economics, the contract curve refers to the set of points in an Edgeworth box diagram where both parties involved in a trade cannot be made better off without making one of them worse off. It represents the Pareto efficient allocations of goods between two individuals or entities,
Cornelius
Suppose a consumer consuming two commodities X and Y has The following utility function u=X0.4 Y0.6. If the price of the X and Y are 2 and 3 respectively and income Constraint is birr 50. A,Calculate quantities of x and y which maximize utility. B,Calculate value of Lagrange multiplier. C,Calculate quantities of X and Y consumed with a given price. D,alculate optimum level of output .
Feyisa Reply
Answer
Feyisa
c
Jabir
the market for lemon has 10 potential consumers, each having an individual demand curve p=101-10Qi, where p is price in dollar's per cup and Qi is the number of cups demanded per week by the i th consumer.Find the market demand curve using algebra. Draw an individual demand curve and the market dema
Gsbwnw Reply
suppose the production function is given by ( L, K)=L¼K¾.assuming capital is fixed find APL and MPL. consider the following short run production function:Q=6L²-0.4L³ a) find the value of L that maximizes output b)find the value of L that maximizes marginal product
Abdureman
types of unemployment
Yomi Reply
What is the difference between perfect competition and monopolistic competition?
Mohammed
Got questions? Join the online conversation and get instant answers!
Jobilize.com Reply

Get Jobilize Job Search Mobile App in your pocket Now!

Get it on Google Play Download on the App Store Now




Source:  OpenStax, Microsoft access. OpenStax CNX. Oct 07, 2008 Download for free at http://cnx.org/content/col10588/1.1
Google Play and the Google Play logo are trademarks of Google Inc.

Notification Switch

Would you like to follow the 'Microsoft access' conversation and receive update notifications?

Ask