ACCESS learning Diary

Source: Internet
Author: User
ACCESS learning Diary

ACCESS learning Diary

1. ACCESS objects
A) a table is the basic object of a Database. Other objects are generated based on it.
B) query: You can search for required records based on the index, filter records as required, and join several fields to form a new table.
C) The form provides a convenient window for browsing, inputting, and changing data.
D) reports: Data Classification summary and printing.
E) macro: execute a series of operations in batches.
F) module: functions are similar to macros, but they are more refined and programmed.
2. Six objects and three types
A) tables and queries: data sources and basics
B) forms and reports: used for display and printing
C) macros and modules: Mainly used for control.
D) supplement: access data through data access pages (a web page)

A) Table concept:
I. Table attributes; Table records; Table components;
Ii. Operations on records: projection and selection;
Iii. A connection can be established between tables;
B) Table Design Principles
I. The table functions should be single (in line with the paradigm)
Ii. Unique fields;
Iii. Unique record (no identical record exists)
Iv. Function relevance (excluding irrelevant attributes)
V. Field Independence: modifying a field does not affect the data of other fields (the solution is usually to split the table)
C) create a database (using a template, using the Wizard to create a table, and using the table designer to create a table ;)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.